Creating an archive database

[LaBelette]

I have a big problem on my hands right now!

I'm working on a database (like I always do!), with multiple tables (about 10), forms (about 7) and a load of queries.

My client wants to have a way to know when a user makes a change in the database. This means keeping track of every changes in every records ever made by any user.

He want to know when it has been done, by who, what was the data before and what is the new data.

The only thing I can think of is creating a duplicate of the database when a user log on, and compare the two database when he log off, and write the modifications in a third database.

Is there some built-in way to do it, or anything simpler than this?

I work with Access 2003 (2000 file format) and I am more than comfortable with VBA.

 

[trucktime]

Archive

Check this link, there is a sample mdb called Audit Trail,
it may be what you are looking for.

http://www.candace-tripp.com/_pages/access_downloads.asp

 

[LaBelette]

Thanks!

Thanks a lot!

It gives me a good hint about what to do, but a problem remains: I have to do it in a lot of form. But I think I'll find a way.

 

[trucktime]

Database

You're welcome and Good Luck.

You can also search this forum on this topic,
I'm sure you'll find some useful information.