"Access 2000 File Format" question.

[Frank Martin]

Recently I upgraded from Access2000 to Access2003.

I did this by creating a new blank database in Access2003 and then imported
all the objects from the old Access2000.

But now the new database has a "Access2000 File Format" next to its name.

Did I do something wrong, and how can I convert to a "Access2003 File
Format" if this is possible or necessary?

Please help, Frank

 

[tina]

well, unless you want to use some functionality that is new to A2003 - in
other words, not available for an A2000 db - AFAIK there's no advantage to
converting an A2000 db to A2003 file format. on the other hand, it probably
won't hurt anything, unless you have users who are still using Access 2000;
they won't be able to open an A2003 database.

at any rate, to convert an A2000 db to A2003: open the database in Access
2003. from the database window, on the menu bar, click Tools | Database
Utilities | Convert Database | To Access 2002 - 2003 File Format...

hth

 

[Vincent Johns]

Recently I upgraded from Access2000 to Access2003.

I did this by creating a new blank database in Access2003 and then imported
all the objects from the old Access2000.

But now the new database has a "Access2000 File Format" next to its name.

Did I do something wrong, and how can I convert to a "Access2003 File
Format" if this is possible or necessary?

Please help, Frank

It's possible (and easy) to convert it -- just choose Tools --> Database
Utilities --> Convert Database --> To Current Access Database Version.

But the newer version may have some compatibility problems with other
software; the file format is different. For example, anyone using
Access 2000 will likely have great difficulty reading the Access 2003
version of the file. Check the Access Help for more details.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Randy Harris]

well, unless you want to use some functionality that is new to A2003 - in
other words, not available for an A2000 db - AFAIK there's no advantage to
converting an A2000 db to A2003 file format. on the other hand, it probably
won't hurt anything, unless you have users who are still using Access 2000;
they won't be able to open an A2003 database.

at any rate, to convert an A2000 db to A2003: open the database in Access
2003. from the database window, on the menu bar, click Tools | Database
Utilities | Convert Database | To Access 2002 - 2003 File Format...

hth

The one problem, that I'm aware of, developing your project in A2K3, but
keeping the file format in A2K, is that you won't be able to build an mde
from it in A2K3. If the OP still has A2K loaded somewhere, he can use that
to create the mde.

Randy

 

[Frank Martin]

Thank you for the replies; I'll hold off for the moment.

 

[tina]

The one problem, that I'm aware of, developing your project in A2K3, but

keeping the file format in A2K, is that you won't be able to build an mde
from it in A2K3. If the OP still has A2K loaded somewhere, he can use that
to create the mde.

you're right, Randy, that is an obvious drawback - and quite a pain in the
neck when you *don't* have access to A2K!

 

[Tom Wickerath]

You are probably better off to do all of your development work using the
Access 2000 file format, unless you need functionality that is only available
using the later version. Convert the database to the Access 2002-2003 file
format just prior to creating a .mde file. The reason I say this is that
Microsoft actually advises this for preventing bloat in Access 2002 (see
workaround 2):

Database bloat is not stopped by compacting database with Access 2002 format
http://support.microsoft.com/?id=810415

While this article is shown as applying to Access 2002, it likely applies to
Access 2003 as well, since the 2002-2003 file format is shared by both
versions.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________


:

The one problem, that I'm aware of, developing your project in A2K3, but
keeping the file format in A2K, is that you won't be able to build an mde
from it in A2K3. If the OP still has A2K loaded somewhere, he can use that
to create the mde.

Randy