Database Invalid Format

[SagyB]

Hi all,

I have a wierd problem..
Some general info.. I use Access 2002 with SP2.
Whenever my database file reaches a size of a little over
30MB, i get the message "Database Invalid Format".
If i run the compress and repair when my DB is smaller
than 30M, and it doesnt reach that size, I don't have this
problem, but i don't think this is the right way to work...

Did anyone encounter this problem before? I couldn't find
any data about it..

Thanks..

 

[Brendan Reynolds]

If this happens during development, in my experience, in every version of
Access from Access 2000 up, during intensive development of large
application MDBs, you need to compact frequently. Even then, corruption will
occasionally happen, which is usually resolved by importing all objects from
the corrupted MDB into a new, empty MDB.

Fortunately, it does not appear to happen in production MDBs, where frequent
design/code changes are not being made.

 

[Tony Toews]

Some general info.. I use Access 2002 with SP2.
Whenever my database file reaches a size of a little over
30MB, i get the message "Database Invalid Format".
If i run the compress and repair when my DB is smaller
than 30M, and it doesnt reach that size, I don't have this
problem, but i don't think this is the right way to work...

There's nothing special about 30 Mb. There are lots of MDBs out there
much larger. I'd suggest looking at some alternative causes. See the
Access Corruptions FAQ at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm