Kick users off for maintenance

[E P]

How do I kick users off of my Access database. I need to
make changes wt night but sometimes users leave the
application open on their machine and they are no longer at
work. Also, is there a way to make the application
inaccessible during certain hours?

Thanks in advance.

 

[Arvin Meyer]

A sample database that demonstrates that:

http://www.datastrat.com/Download/KickEm.zip

and a code example:

http://www.datastrat.com/Code/KickEmOff.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Rosco]

Arvin,
I've got several back ends that need periodic data updates.
I have code in the FEs that will prevent a user from
opening the app if an update is in progress. How can I
have the Back end scan for open front ends and systmically
close any it finds before starting the update process.

Thanks for the help.
Rosco

 

[Arvin Meyer]

Arvin,
I've got several back ends that need periodic data updates.
I have code in the FEs that will prevent a user from
opening the app if an update is in progress. How can I
have the Back end scan for open front ends and systmically
close any it finds before starting the update process.

If you are working from a front-end code database, check for the presence of
an LDB file on the back-end in question. When a front-end is actively
connected to data, there will be an LDB. If that exists, you can add the
record to the table and have all the connected front-ends close with the
Kick-em off database.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Arvin. I have tried using the stuff from 'kickem' but an told the dim db as
dao.database is not defined....any advice?

Thanks
Emma

 

[Guest]

Arvin. I have tried using the stuff from 'kickem' but an told the dim db as
dao.database is not defined....any advice?

Thanks
Emma

 

[Douglas J. Steele]

You must be using Access 2000 or 2002, and you haven't set a reference to
Microsoft DAO 3.6 Object Library.

With any code module open, select Tools | References from the menu bar and
scroll through the list until you find that reference. Check it, and you
should be fine.

 

[gokhan gundem]

Arvin. I have tried using the stuff from 'kickem' but an told the dim db as
dao.database is not defined....any advice?

Thanks
Emma