mwmosu

mwmosu

  • NA
  • 10
  • 0

Access 2002 issues??

May 19 2004 11:33 AM
I have written and deployed a program that will update, delete, and add data to tables in microsoft access 2002. The problem that remains (and didn't before the switch to Access 2002 was made) is that the mdb file grows at enormous rates as the program runs, and gets to the point where the program can't connect to it. Then, if you try to open the database, Access tells you that your .mdb file is either corrupted or isn't a .mdb file. "You or another user may have exited microsoft access while the database was still open" is another line on the warning. It then asks if you want to repair; if yes, the size of the file is reduced, and it works fine. If no, nothing happens. The src files were constructed in a way that combatted unnormalization of the database. Since all the tables had 4 fields in common, all records were combined into a master table with only these fields represented. This master table (7000 records) is used to draw info on what table to go to to make database changes in the program. (hope that made sense) I thought this piece of information may be part of the problem. The file size will grow (usually up to about 75~ MB from 7~ MB after repair) until it decides not to work. We probably add around 50 records in a day. Has anyone had any experience close to this? Thanks

Answers (1)