Can I modify record information from an ODBC connection in Access Chuck 07.07.2006 23:03:01 I have an ODBC connection to tables in MS-SQL Server. Is it possibly for my profile to be set up on the Enterprise Manager to have access to modify records from Access? I currently have DB-Datareader rights, but what if I had DB-Owner rights? Could I modify the records if I am looking at the tables in Access? Is this possible? Thanks for your input!!!!

Re: Can I modify record information from an ODBC connection in Access "Joe Fallon" <jfallon1[ at ]nospamtwcny.rr.com> 08.07.2006 01:34:26 Yes it is possible. Access has been able to talk to SQL Server for many years now. You are correct that your SQL Server permissions establish how you can use the data. Many DBAs will refuse to grant you read write access to the DB though. They expect you to use the application instead. The application will enforce many rules that you may not be aware of when you change the data directly. -- Joe Fallon "Chuck" <Chuck [ at ]discussions.microsoft.com> wrote in message news:9C571886-18C6-433A-BF10-298341DDF736[ at ]microsoft.com... [Quoted Text] >I have an ODBC connection to tables in MS-SQL Server. Is it possibly for >my > profile to be set up on the Enterprise Manager to have access to modify > records from Access? I currently have DB-Datareader rights, but what if I > had DB-Owner rights? Could I modify the records if I am looking at the > tables > in Access? Is this possible? > > Thanks for your input!!!!