Access 2000 to Access 2003

[Gregc]

Does anyone know issues or incompatabilities with using an Access 2000 database with Access 2003? Will it work?

Thanks,

Greg

 

[Joe4]

It is usually not a problem using an older database in a newer version. Problems may arise if you go the other way, though (i.e. trying to open a database created in Access 2003 in Access 97).

 

[Mudface]

Problems may arise if you go the other way, though (i.e. trying to open a database created in Access 2003 in Access 97).

The problem being you won't be able to...

 

[SydneyGeek]

If Access 2003 supports the Access 2000 file format (as XP does) there should be no problems. Anyone know if Access 2003 DOES support Access 2000 format?

Denis

 

[dk]

If Access 2003 supports the Access 2000 file format (as XP does) there should be no problems. Anyone know if Access 2003 DOES support Access 2000 format?

Denis

Yes, the default file format used within Access 2003 is the A2K format. The formats available are 97, 2000 and 2003/03 (i.e. there is no A2003 specific format). To be honest, I've noticed even less difference between Access XP and 2003 than I found between the two Excel versions and that's saying something. The only useful enhancement I've found is that you can change the font size in the SQL view of a query.

Anyway, I'm diversing. Gregc will have no problem running his Access 2000 database in Access 2003, other than the stupid new security 'enhancements'.

 

[sws2k42]

Yeah, I am working on a Access 2000 db using 2003 and have not had any problems. In the title bar it will show " (Access 2000 program) " or something to that effect.

 

[Dugantrain]

The only useful enhancement I've found is that you can change the font size in the SQL view of a query.

I do remember reading somewhere that A2003 now supports multiple Undo/Redo's which will be quite a gift to users at any level.