Avery Wizard in MS Access forces exclusive use

[jrbarnett]

I finally solved a long term problem in a DB I support quite by chance yesterday.

One database opened fine on two or more PCs, but if it opened on a third PC, or the third PC opened it ahead of other PCs then multi user access was prohibited.
They all had the same network permissions on the file, so it wasn't that.

I finally tracked it down: With the Access component of the Avery Wizard installed, any database is opened in exclusive mode regardless of the Default Open Mode set in the Access options. This particular database was being opened in Access XP with Service Pack 3, but it is likely to affect other version and service pack combinations.

Use Add/Remove programs to remove the Access component, or uninstall the toolbar altogether and the problems vanished completely.

I hope that this ends up being useful to somebody else.

John

 

[boblarson]

One OTHER potential solution would be to create a second Access db that is linked to the first and have all Avery use go to that second db. That SHOULD keep it from opening it exclusive as it will be going through a different path.


Bob Larson
A2K,A2K3,A2K7,SQL Server 2000/2005,Crystal Reports 10/XI,VB6, WinXP, and Vista
Free Quick Tutorials and Samples:

http://www.btabdevelopment.com