Convert 2003 to 97.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

andersos - 11 Dec 2006 22:53 GMT

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.

Reply to this Message

Douglas J. Steele - 12 Dec 2006 00:14 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> 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
[quoted text clipped - 8 lines]
> option. We have over 1000 users and 20,000 databases. We don't have the
> resources to convert them all at the same time.

Reply to this Message