How do I not allow updates when linking

  • Thread starter Thread starter cclark
  • Start date Start date
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?
 
cclark said:
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?
Click to expand...

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