How do I not allow updates when linking

C

cclark

I have an external sql database and I am using access to link to the sql
database to do reports but I don't want users to be able to see the tables
and make changes (deletes, inserts, updated) to the actual sql database
using the links. I would like to be able to have real time data from the sql
database when using access to do reporting (don't want to import data). How
can I accomplish securing the sql database and keeping the access
reporting database real-time?
 
C

cclark

Rick Brandt said:
You could create a passthrough query instead of using a link. They are
automatically read only.

Otherwise you should handle this by setting the security on the server table
so that no unauthorized peoople can edit the data.
Click to expand...

Thanks Rick,

Can you explain passthrough query or point me to a document?
 
C

cclark

cclark said:
Thanks Rick,

Can you explain passthrough query or point me to a document?
Click to expand...

Thanks Rick,

I see the info under help in Access. Thanks for the assistance.

cclark
 
C

cclark

Rick Brandt said:
You could create a passthrough query instead of using a link. They are
automatically read only.

Otherwise you should handle this by setting the security on the server table
so that no unauthorized peoople can edit the data.
Click to expand...

Can I use passthrough with an Oracle database also?

Thanks,
cclark
 
Top