Question A97 to A2003

[Rockape]

Hi all,

Just a quick question. Does anyone know if its possible to convert an Access 2002/03 database to Access 97.

Do I need any specific software? Advice greatly appreciated.

Kind regards

 

[WayPay]

In Access 2003: Tools | Database Utilities | Convert Database | To Access 97 File Format

 

[gemma-the-husky]

note that

a) you will lose any specific functionality in A2003
eg replace, split, instrrev functions
eg conditional formatting

b) i had a large app, that just would not convert proerly, despite many attempts (100+forms, 100+queries) one or two forms just would not run after converting. some crashed access immediately - others could be opened but not amended - but generally the downconvert will work