Can I modify record information from an ODBC connection in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!
 
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.
 
Back
Top