Linked Table(s)

[alex]

Hello all,

using Access '03

I have two mdb files, we'll call them 1.mdb and 2.mdb.

I want to link a table in my 1 database to the 2 database and then
query off this table in the 2 database. I want to lock the linked
table, however, so that data can never be changed/deleted in the
actual table in the 1 database. Can this be done?

Caveat: 1 is an active database with a number of different users,
entering data throughout the day. I do not want to manipulate the
settings of the table(s) in the 1 database; I only want to manipulate
the link, such that data can flow to the 2 database, but never the
other way around (kind of like a one-way valve).

Thoughts?

alex

 

[Allen Browne]

After linking the table, Create a query such as:
SELECT * FROM Table1;

In the Properties of the query (Properties box in query design view), set
the Recordset Type to:
Snapshot

The query will be read-only, so any form based on the query will be
read-only too.

There are other solutions involving Access security, or placing 1.mdb in a
shared folder that does not give update rights.

 

[alex]

After linking the table, Create a query such as:
    SELECT * FROM Table1;

In the Properties of the query (Properties box in query design view), set
the Recordset Type to:
    Snapshot

The query will be read-only, so any form based on the query will be
read-only too.

There are other solutions involving Access security, or placing 1.mdb in a
shared folder that does not give update rights.

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.










- Show quoted text -

Thanks Allen for your help.

I figured a query would help protect the integrity of the table. I
didn't want anyone, however, to accidently access the linked table. I
think I'll make sure that I and others that will be accessing the 2
database only have read only access to the 1 mdb. Thanks again.

alex