How do I link a table in read-only mode

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access 2003 database that is updated frequently and one of my
co-workers needs to access one of my database tables in his database, but he
doesn't want to accidentally modify my data. How can we link the table he
needs into his database as a read-only table?
 
gjoverto said:
I have an Access 2003 database that is updated frequently and one of
my co-workers needs to access one of my database tables in his
database, but he doesn't want to accidentally modify my data. How
can we link the table he needs into his database as a read-only table?
Click to expand...

Use a query with the IN clause instead of a link and then set the
RecordSetType of the query to Snapshot. That will make it read only.

SELECT * FROM TableName IN 'Path to your mdb file'
 
Short of applying security, I don't think it's possible.

What you can try, though, is to create a query that uses the IN
externaldatabase syntax, and make the query non-updatable using SELECT
DISTINCT:

SELECT DISTINCT Field1, Field2
FROM MyTable IN \\server\share\folder.file.mdb
ORDER BY Field1
 
Back
Top