So if a database is to be placed on a shared drive, what procedures can be put in place to identify which individual made what changes? Is that possible?
So if a database is to be placed on a shared drive, what procedures can be put in place to identify which individual made what changes? Is that possible?
You want to elaborate a little. Do you have a specific application with real tables and real users in mind?
You might wish to research AUDIT Log Audit changes to a database.
http://www.4guysfromrolla.com/webtech/041807-1.shtml
http://www.techrepublic.com/article/...s-data/6166807
Google is your friend try "Audit Log changes to a ms access database"
Also, if more that one person will use it concurrently, it should (must?) be split:
http://www.granite.ab.ca/access/splitapp/index.htm