Question Locked

Make login for Database in Access 2007

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to make it so that my employees must login first before they can access the information on our database in Access. I would like it to be that any information changed from their login will show their name since we are having a problem with blame. Can anyone help? I know very little about Access 2007 and was just asked to create a database with these specifications.

3 replies

by mwhipple

What you're asking may be a bit much for Access by itself. Access is insecure, though that doesn't appear to be a concern. More importantly adding a logging system to a database that doesn't already have one would be time consuming to say the least. Being able to retrieve who changed which field to what and when for each record would require handlers for every update or the changes to be made as batch transactions or synchronizations.
Creating a separate front-end or finding an existing one that will work and migrating to a client/server architecture would probably be a better use of your time. Any database updates I'd imagine there are some tools that can generate ASP pages for you which you could serve and have act as a gateway to the Access back-end. These would provide a more scalable and efficient solution and the difference in invested time may be negligible.

This discussion is closed to new replies.