Log all users off database

[Angie]

Forgive me as I have seen this question before. How do I
log off all users in a database so that I may compact it?
I went to T Toews site but couldn't find it....thanks so
much!

 

[Joseph Meehan]

Well the LDB viewer will at least tell you who is on it.

 

[Angie]

Found a site that helped! Here it is:

http://ourworld.compuserve.com/homepages/attac-
cg/AMulti.htm#LOGOFF

 

[Toan Chau]

What is the LDB viewer?

A thousand thanks in advance.

 

[Jim/Chris]

The first step is to see who is logged on to a db. Try

http://www.mvps.org/access/modules/mdl0055.htm
http://www.mvps.org/access/general/gen0034.htm
http://www.mvps.org/access/api/api0062.htm

Jim

 

[Arvin Meyer]

Forgive me as I have seen this question before. How do I
log off all users in a database so that I may compact it?
I went to T Toews site but couldn't find it....thanks so
much!

Try this code on my website:

http://www.datastrat.com/Code/KickEmOff.txt

and I have a demo database at:

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

 

[Angie]

Wonderful! Thanks to all so much!

-----Original Message-----


Try this code on my website:

http://www.datastrat.com/Code/KickEmOff.txt

and I have a demo database at:

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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.558 / Virus Database: 350 - Release Date: 1/2/2004


.