Hi,
I am working on an Access application where the author used SQL back
end via linked tables.
I wrote some general functions that would execute pass through queries
and was going to call them for all new DB interaction.
They work fine as long as I go into SQL Server and give the User
Select, Update, Insert and Delete privileges. However this Access
application using internal queries is running fine with virtually every
table in the SQL database not offering ANY privileges to this user.
As this is a large organization I would rather not go thru the "red
tape" with the DBA staff to change numerous SQL DB settings to support
pass through so I will probably continue what the author started.
My question is... what is the difference? How does Access through
linked tables successfully Select, Update, Insert and Delete when the
user ID used to connect doesn't have any privilges according to SQL
Server?
Thanks