Access.Lockfile.9 in a multi-user environment.

[DMainland]

I use a database on a 4 user peer-to-peer network on XP machines. I have
been being locked out of the application from just about all stations of the
network. Shortcuts have been rendered inoperable, requiring a re-boot of all
machines to regain access to the program. It is driving me crazy. Any help
would be greatly appreciated.

 

['69 Camaro]

Hi.

I have
been being locked out of the application from just about all stations of
the
network.

Locked out in what way? Is there an error message? "The database is opened
exclusively by UserA"? "The file is already in use"? "You do not have
permission to open . . ."? "Database has been placed in a state by 'Admin'
on ComputerX . . ."? "The database is located outside . . ."?

Or perhaps one of the other dozens of reasons you can't open the database?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[DMainland]

One message I remember is 'the database has been placed in a state by Admin
on computer X. I have also seen ' the database has been opened exclusively
by another user.' Basically a lockfile has been generated by different users
at different times over the network. Do you have any suggestions.