Linked Tables

[chr1stoper1]

Hi Folks

I was wondering if you can link a table in two access databases and make the link one way only. So if someone deleted a entry in one table it would not delete it in the other .

We have a database which someone has been accidently deleting entries from a table . I would prefer not to add a password but we keep losing data.

Any help would be much appreciated

 

[arnelgp]

you can use Form and Disallow deletion of record in the form.
you can also add "Audit trail" on deletion of record.
so you will know who is the culprit and forever remove
him/her from the office.

 

[GPGeorge]

Hi Folks

I was wondering if you can link a table in two access databases and make the link one way only. So if someone deleted a entry in one table it would not delete it in the other .

We have a database which someone has been accidently deleting entries from a table . I would prefer not to add a password but we keep losing data.

Any help would be much appreciated

No, that's not how linked tables work.

There is ONE table. It exists in one accdb or in one SQL Server database, etc.

The LINKS only "point" to that one table. They are not "data storage" in themselves. They are little nuggets of information that tell Access where to go to get the real data.

That means if you delete a record using a linked table, it is actually going to that source table and deleting it there. It's not possible, therefore, for any other "linked table" to still see that record which is now gone from the source table.

You can use Arnel's technique to prevent people from deleting records.

 

[theDBguy]

Hi. Do you allow for additions, just not deletions?