Limiting User Access by Time

[Guest]

I have a networked database that is used by my department (about 20 users).
Each user has a copy of the front-end on their local machines that is linked
to the data of the back-end on the network.

The problem is that I need to backup the back-end every day. This is
usually not a problem but if one user forgets to exit Access the day before,
I am locked out of the back-end for updates or backups.

Is there a way to specify a time limit for the front-end? If the front-end
automatically closed after six hours of inactivity, I would have access to do
what I need to each morning but would prevent users from losing data.

Also, is there a way to automate the backup process? I do not mind doing
this manually each morning but would like to have it done for me each night
before our shift starts. Any help or advice that you can give would be
greatly appreciated. Thanks in advance.

 

[Guest]

i believe the following sample database has the code you need to log off your
users

http://www.rogersaccesslibrary.com/download3.asp?SampleName=LogUsersOff.mdb

Daniel

 

['69 Camaro]

Hi, Jim.

Is there a way to specify a time limit for the front-end?

Please see Access MVP Tom Wickerath's tip, "How to kick users out of the
database when they've been idle too long" on the following Web page:

http://www.Access.QBuilt.com/html/fix_its.html

Also, is there a way to automate the backup process?

Use the Windows Task Manager to set up a task/time for either a VB Script to
run the backup or a VBA procedure in an Access database to run the backup,
and then leave this workstation booted all night.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Guest]

Hi Daniel,

Thanks for the info. That was very helpful.

 

[Guest]

Hi Gunny,

Thanks for the info. That was very helpful.

 

['69 Camaro]

You're welcome. Glad to help.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.