Software

Ask something
Discussion Locked

Compacting MS Access Databases

0 helpful
5 replies

by potato4931

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When I compact a database, the created and modified dates for forms, reports, etc. changes to the date and time that the database was compacted. Is this something new for Access 2000? Can I turn this feature off so that I can maintain the originaldate created? In some of the databases, the dates were not changed for tables and queries. In other databases, everything changed. Thank you.

5 replies

by tjc

Sorry to say but that is a feature/function of the compact routine. You see since it actually re-creates the database removing and checking any and all the information.

You may want to develope a program that you use to copy the data from one mdbto another. of course what this means is that you would have to start out with an empty database that just has all your tables, reports, and queries in it already that you would do a file copy of and then copy from your existing database into this new database, perserving your creating date and time.

by shmaltz

As TJC said this is by design since compacting means recreate.
If you are trying to have the original dates because you have a program that checks on so it knows if it needs update; you can work around this by creating a new property for the foms and reports in question and assign it a version number.

This discussion is closed to new replies.