Access Db Left open

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a retail P.O.S. system that uses an access database to store transaction data. We have about 12 clients that connect to it. Occasionally an error will cause me to have to repair the database. Even after I have asked all retail stations to log off and verified that no one is still on, the database still cannot be repaired because it seays that it is opened exclusively by another user. The only solution to this has been to reboot the server so Windows SBS 2000 will close all the network connections. Is there a utility that will allow me to close all open connections to the database without having to reboot the server?
 
Total Access Admin, from FMS, might help
http://www.fmsinc.com/products/Admin/index.asp

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


Scott F said:
I have a retail P.O.S. system that uses an access database to store
Click to expand...
transaction data. We have about 12 clients that connect to it. Occasionally
an error will cause me to have to repair the database. Even after I have
asked all retail stations to log off and verified that no one is still on,
the database still cannot be repaired because it seays that it is opened
exclusively by another user. The only solution to this has been to reboot
the server so Windows SBS 2000 will close all the network connections. Is
there a utility that will allow me to close all open connections to the
database without having to reboot the server?
 
The W2Server (SBS) Administrator can close an open file without rebooting
the server.

With Access, it is more likely that you need to look out for the LDB file
(locking file) rather than the MDB file. The Administrator can close and
delete the LDB file and then you should be able to repair the database.

--
HTH
Van T. Dinh
MVP (Access)



Scott F said:
I have a retail P.O.S. system that uses an access database to store
Click to expand...
transaction data. We have about 12 clients that connect to it. Occasionally
an error will cause me to have to repair the database. Even after I have
asked all retail stations to log off and verified that no one is still on,
the database still cannot be repaired because it seays that it is opened
exclusively by another user. The only solution to this has been to reboot
the server so Windows SBS 2000 will close all the network connections. Is
there a utility that will allow me to close all open connections to the
database without having to reboot the server?
 
Scott F said:
I have a retail P.O.S. system that uses an access database to store
Click to expand...
transaction data. We have about 12 clients that connect to it. Occasionally
an error will cause me to have to repair the database. Even after I have
asked all retail stations to log off and verified that no one is still on,
the database still cannot be repaired because it seays that it is opened
exclusively by another user. The only solution to this has been to reboot
the server so Windows SBS 2000 will close all the network connections. Is
there a utility that will allow me to close all open connections to the
database without having to reboot the server?

I don't know _nix servers, but all the other ones NT4, W2K, SBS, 2003,
Novell (all flavors) allow an admin to close open files. You can also boot
them from Access with the kickem routines:

http://www.datastrat.com/Download/KickEm.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top