How do I not allow updates when linking

[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?

 

[Rick Brandt]

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?

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.

 

[cclark]

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.

Thanks Rick,

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

 

[cclark]

Thanks Rick,

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

Thanks Rick,

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

cclark

 

[cclark]

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.

Can I use passthrough with an Oracle database also?

Thanks,
cclark

 

[Douglas J. Steele]

Can I use passthrough with an Oracle database also?

You should be able to use pass-through with any ODBC-compliant database.

 

[cclark]

You should be able to use pass-through with any ODBC-compliant database.

Thank you,
cclark