Archiving in Access

[NetNodeMan]

I have a program which writes to an Access 2003 database. From time to time I need to compact & repair this is my program will spit out a run time error if the database gets too big. Is there any way of auto archiving the database once it reaches say 100MB in size? it already does get archived but I'm looking for something that will archive it by size.

 

[fneily]

You'll get more responses if you post in the Access forums such as "Microsoft: Access Other topics