MS Access Multiuser - record locking

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

record locking

Ron

2005-10-27, 8:31 am

Hi,

I have a shared database at work using Access 2000 on Windows 2000 and keep
getting record locking problems.

Each user updates the base table via a query but whenever one user is part
way through a creating a new record everyone else is locked out.

The same database doesn't exhibit this problem using Access 2003 on XP.

I have tried having the base tables on a backend database and setting
everything to 'no locks'.

Any advice appreciated.

Ron.

Sponsored Links