Kick users off for maintenance

E

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.
 
R

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
 
A

Arvin Meyer

Rosco said:
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.
Click to expand...

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
 
E

Emma Hope

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
 
E

Emma Hope

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
 
D

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.
 
Top