Convert 2003 to 97.

[andersos]

We are in the process of converting from Access 97 to Access 2003.
Occassionally, I need to convert a database from Access 2003 to Access 97 so
a user can access a database. This worked fine when I initially loaded
Access 2003, but now I always get this error.

"Database has reached maximum size."

I would love to convert all our users to Access 2003 now, but that is not an
option. We have over 1000 users and 20,000 databases. We don't have the
resources to convert them all at the same time.

 

[Douglas J. Steele]

Access 2003 MDB files can be as large as 2 Gb. Access 97 MDB files cannot
exceed 1 Gb.

Your applications should all be split into a front-end (containing the
queries, forms, reports, macros and modules), linked to a back-end
(containing the tables and relationships). Only the back-end should be on
the server: each user should have his/her own copy of the front-end, ideally
on his/her hard drive.

Leave the back-end in Access 97 format, and only convert the front-end,
distributing the appropriate version of the front-end to each person.

 

[Douglas J. Steele]

There may be some form of corruption present.

It might be a good idea to do a Decompile, and then Compact it a couple of
times.

MichKa explains what Decompile does, and how to do it, at
http://www.trigeminal.com/usenet/usenet004.asp

 

[Douglas J. Steele]

Sorry, I have no more ideas. I've never seen this problem before.