Access 2000 & 2003 compatibility?

[Chips]

I have Access 2000, and will need to make databases for people that have
2000.

If I upgrade to Office 2003, will this create problems with the databases
being used by Access 2000?

Thanks,

GC

 

[Larry Linson]

I have Access 2000, and will need to make
databases for people that have 2000.

If I upgrade to Office 2003, will this create
problems with the databases being used
by Access 2000?

By default, Access 2003 creates databases in Access 2000 file format. You
really should maintain a machine with Access 2000 installed, and thoroughly
test those databases. You assume they will work correctly, but it's best to
test in the same environment in which they will run.

Larry Linson
Microsoft Access MVP

 

[Rick Brandt]

I have Access 2000, and will need to make databases for people that
have 2000.

If I upgrade to Office 2003, will this create problems with the
databases being used by Access 2000?

Thanks,

GC

In addition to what Larry stated you cannnot create a 2000 MDE with Access 2003.
So if you normally distribute MDEs to your users you will need a copy of Access
2000 for MDE creation. You also will need to avoid using any features that were
added in 2002 or 2003 because they will not work in Access 2000.

 

[Chips]

Thanks for the answers, I think I'll just not upgrade Access unless the
users do as well.

GC

 

[John Vinson]

I have Access 2000, and will need to make databases for people that have
2000.

If I upgrade to Office 2003, will this create problems with the databases
being used by Access 2000?

Generally, no. In fact A2003 defaults to using the A2000 format for
databases. Just don't use any A2002/3 specific features (see the
Help... What's New) and don't convert the database to 2002/3 format.

John W. Vinson[MVP]