Access 2003 and Access 2000

[Stephen Glynn]

If someone emails me an Access 2003 database containing tables, queries
and forms, will I be able to open it in Access 2000?

Steve

 

[Douglas J. Steele]

Depends. The default file format for Access 2003 is the Access 2000 format.
If they haven't changed that, you shouldn't have a problem. However, if they
have converted it to the new format, you won't be able to open it.

Have them check (it'll say at the top of the database window). They can
convert back to the Access 2000 format, if necessary, under Tools | Database
Utilities.

 

[Vincent Johns]

If someone emails me an Access 2003 database containing tables, queries
and forms, will I be able to open it in Access 2000?

Steve

Yes, iff he saved it in Access 2000 format. Otherwise, you should
probably ask him to send it to you again, after converting it to Access
2000 format.

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

 

[Van T. Dinh]

It depends on which Access *file format* the other person created the
database in. Access 2003 software can use A2000 file format natively or
A2002-A2003 file format (same format for 2 versions of Access software). In
fact, the default file format for a new database file created in A2002 or
A2003 software is actually A2000 file format but this could be changed or
the file has been converted to A2002-A2003 file format.

If the file is in A2002-A2203 format, you can't open it. If it is in A2000
file format, you can open it but features that were introduced in
A2002/A2003 software and used in the database won't work with A2000
software.

Simpler to ask the sender to make sure he / she sends you a copy in A2000
file format.

 

[Stephen Glynn]

It depends on which Access *file format* the other person created the
database in. Access 2003 software can use A2000 file format natively or
A2002-A2003 file format (same format for 2 versions of Access software). In
fact, the default file format for a new database file created in A2002 or
A2003 software is actually A2000 file format but this could be changed or
the file has been converted to A2002-A2003 file format.

If the file is in A2002-A2203 format, you can't open it. If it is in A2000
file format, you can open it but features that were introduced in
A2002/A2003 software and used in the database won't work with A2000
software.

Simpler to ask the sender to make sure he / she sends you a copy in A2000
file format.

Thanks, all.

Steve