spacebaby
asked on
Access thinks I'm logged in!
Greetings:
I am trying to open an access database and make changes, but I keep getting messages about not having exclusive access. The default open mode in the database *is* exclusive.
I got a utilty to see who was logged in and I'm listed twice as a suspsect connection. How do I fix the problem and get access to realize I'm not logged into the database? There is an acccess.lockfile.9 in the folder witht he database, but I can't delete it or do anything with it.
I am trying to open an access database and make changes, but I keep getting messages about not having exclusive access. The default open mode in the database *is* exclusive.
I got a utilty to see who was logged in and I'm listed twice as a suspsect connection. How do I fix the problem and get access to realize I'm not logged into the database? There is an acccess.lockfile.9 in the folder witht he database, but I can't delete it or do anything with it.
Spacebaby,
Use te utility located at the following links to compact the database.
Access 97 http://www.utteraccess.com/candace/candace/backup/autobkup.zip
OR
Access 2000
http://www.candace-tripp.com/download/autobkup2k.zip
That should solve your problem.
Hope this helps
syntnx
Use te utility located at the following links to compact the database.
Access 97 http://www.utteraccess.com/candace/candace/backup/autobkup.zip
OR
Access 2000
http://www.candace-tripp.com/download/autobkup2k.zip
That should solve your problem.
Hope this helps
syntnx
Spacebaby,
Use te utility located at the following links to compact the database.
Access 97 http://www.utteraccess.com/candace/candace/backup/autobkup.zip
OR
Access 2000
http://www.candace-tripp.com/download/autobkup2k.zip
That should solve your problem.
Hope this helps
syntnx
Use te utility located at the following links to compact the database.
Access 97 http://www.utteraccess.com/candace/candace/backup/autobkup.zip
OR
Access 2000
http://www.candace-tripp.com/download/autobkup2k.zip
That should solve your problem.
Hope this helps
syntnx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That should have been "lock" not "log"
Jim.
Jim.
Is the database in a shared folder? Maybe it's a session logged in from another machine.
In Win2K or XP, you can check for this by right-clicking on "My Computer", select Manage and under Shared Folders, select Open Files. There you can see if someone's using the database and under Sessions, you can see from which computer.
In Win2K or XP, you can check for this by right-clicking on "My Computer", select Manage and under Shared Folders, select Open Files. There you can see if someone's using the database and under Sessions, you can see from which computer.
When I get this with users, they just don't close down properly, then I get hte Network Administrators to close the aborted connection.
Cheers, Andrew
Cheers, Andrew
ASKER
We rebooted the machine containing the database and it fixed this problem.
Thanks all....
Thanks all....
If the database is on your local hard disk, try reboot the system and do it again. If it is on a network device, the network admin can kill users of each individual file who use them.
Andy