Login and backup for access 2007

[Pusher]

How to make multiple user accounts with logs of logins and different administration rights for my access 2007 db.
Also how to make an automatic backup of a db.

 

[GinaWhipp]

1. For the Log on are you looking for security? (Cause that's going to be an issue)
2. In a split database scenario the Server gets backed up so no worries there. Keep a copy of the front end in the backend folder and you'll always have a copy of the front end. Now if the database is not split then automatic, well, copy/paste when you are sure no one is in it because you do not want automtic and someone might be in it as it would cause corruption.

 

[Pusher]

Security is what i am looking for with logs of usage by the users.
And i want an automatic backup when someone closes the db.
How can i make users and and administrator account for my db. I want to be the only administrator and i want users that can use specific forms that i chose.

 

[GinaWhipp]

Security is available in .MDB from Access, after that yo can use Active Directory or SQL Server.

The problem with backing up when one User exits is it can't until all Users have exited OR you will corrupt the database. Is the database split?