Use of Previous Version Access Databases in Access 2003

[patm]

I read the following in an MS support page:

"If you want to save the Access file as an MDE (MDE file: Microsoft Access database (.mdb) file with all modules compiled and all editable source code removed.) or ADE (ADE file: A Microsoft Access project (.adp) file with all modules compiled and all editable source code removed.) in Access 2002 or later, you must convert the file to Access 2002 - 2003 file format. Otherwise, you don't necessarily need to convert a Microsoft Access 2000 file to the Access 2002 - 2003 file format."

I need to support a few databases (almost always in Access 2000), but only have Access 2003 on my machine. This comment above from MS leads me to believe that I can support these other database applications with my Access 2003.

From your experiences, is that true? e.g., Can I modify and/or create forms, reports, macros, etc without any problems to Access 2000 databases using my Access 2003 program?

Any and all feedback will be greatly appreciated.

Thanks.

patm

 

[Mark Hyland]

Hi Pat,

You should be able to create new forms etc in your Access 2000 database
using Access 2003, By default, Access 2003 creates an Access 2000 format
database, this is true for Access 2000, Access 2002 (XP) and Access 2003,
all by default use Access 2000 database formats.

If you convert to Access 2003, then you create 2003 objects. So as long as
you dont convert, you should be fine.

hth

Mark

This information is provided "as is" and confers no rights, or expresses no
warranties.

 

[¹Ú¹®¼ö]

Hi Pat,

You should be able to create new forms etc in your Access 2000 database
using Access 2003, By default, Access 2003 creates an Access 2000 format
database, this is true for Access 2000, Access 2002 (XP) and Access 2003,
all by default use Access 2000 database formats.

If you convert to Access 2003, then you create 2003 objects. So as long as
you dont convert, you should be fine.

hth

Mark

This information is provided "as is" and confers no rights, or expresses no
warranties.