If you use MS Access security, you can set appropriate permissions (read data) on the linked table either in the source database or in the database where the link resides
Scott Shearer MCSD, MCDB
(e-mail address removed)
----- Hans van Meel wrote: ----
Does anyone know if it's possible to link MSAccess 2000
tables on a read-only basis
Thank
Another idea might be to set security on the directory where the source table\database resides such that the users only have read access - therfore they would have read-only access to any table in the .mdb file to which you link.
Scott Shearer MCSD, MCDBA
(e-mail address removed)
----- Hans van Meel wrote: -----
Does anyone know if it's possible to link MSAccess 2000
tables on a read-only basis.
Thanks
Another idea might be to set security on the directory where the .mdb with the linked table resides such that users only have read access - therefore they would have read-only access to the tables in the .mdb file.
Scott Shearer MCSD, MCDB
(e-mail address removed)
----- Hans van Meel wrote: ----
Does anyone know if it's possible to link MSAccess 2000
tables on a read-only basis
Thank
Thanks Scott,
This would be a good idea, but for several reasons
I prefer not to use the group or user security. I would
prefer a read-only for the linked tables.
Any ideas??
Thanks for your help
Hans van Meel
-----Original Message-----
Another idea might be to set security on the directory
where the .mdb with the linked table resides such that
users only have read access - therefore they would have
read-only access to the tables in the .mdb file.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
