dAuditTrail locking issue

[aftershokk]

I have 2 databases that run the audit trail which works great. My new DB links to a table in my first DB which has the audit trail. Both DB's are shared but when one person opens the new second DB it locks out an other users? I cannot seem to figure it out!! help!

 

[HiTechCoach]

It does not sounds like it has anything to do with using hte Audit Trail. It is probably because the database are not set up properly for multi users.

You should never have two people opening the same database at the same time. Only do it if you want to lose data and corrupt your databases. If you do, make sure you make very frequent backups!

You need to split the database into a front end and back end. Your front end can link to table in multiple databases.

 

[HiTechCoach]

See:

Splitting your Microsoft Access MDB into a front end and back end

Hope this helps ...

 

[aftershokk]

I am using a new access DB to link to the tables but the linked tables keep getting stuck in exclusive mode.

 

[DCrake]

Check the default settings for opening the mdb. Take a look as to where the ldb file is being created.

David