Creating a Read-Only link to another database

[Wes1961]

I want to create a database (db1) that links tables from another database (db2). Then allow users in db1 to write their own queries/reports but without the fear that they can actually change the data in db2.

Can I link a table from another database as read-only without using MS Access security? If so, how?

 

[LittleSmudge]

One solution that quickly comes to mind is to create queries in db2 that link to each of the tables in db1
Each query will be of the form
"SELECT DISTINCT * FROM tableName"


Distinct queries are not updatable because JET cannot guarantee that each record is uniquely identifiable.

However, YOU will need to make sure that every table is correctly normalised and each record is unique - else you'll get missing records

You can then treat each Query as a ReadOnly table, create new queries based on then, bind them to Forms, Reports etc.


'ope-that-'elps

G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.