3 replies
by samanthaw1225 Accepted solution
by mwhipple Accepted solution
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.
by cpremo Accepted solution
I've implemented what you're asking in a couple of databases. Unfortunately, it's impossible to answer in this type of forum. YOu might want to check out this Access forum:
This discussion is closed to new replies.
Trending Software posts
Sort by Trending