Conversion to older format....

[Guest]

Please help i have acces database created in office 2003 but now i need
export this database to the format office 97 (acces). Can i do this? Or if
you know how tell me please. Thank so much.

 

[Alex White MCDBA MCSE]

Hi Mike,

the only way I can think of and I have not tried it is, in Access 2003 save
the database as Access 2000 (it may already be in that format), then in
Access 2000 save the database in a previous version.

Hope it helps.

 

[Guest]

Mike -

In theory this should be done via <TOOLS> <DATABASE UTILITIES> <CONVERT
DATABASE> - - - Some advance features may not convert back. Hope this helps.


sean

 

[Rick Brandt]

Just an FYI... If you do get the file converted this will ONLY change the
file format to the older version. This does not necessarily produce a
working application in the older version. For example, there are functions
that exist in Access 2003 that do not exist in Access 97. The file
conversion is not going to replace those with an Access 97 equivelent. You
would have to find all such areas and manually fix them to something that
will work in Access 97 or remove them entirely.

 

[Tony Toews]

the only way I can think of and I have not tried it is, in Access 2003 save
the database as Access 2000 (it may already be in that format), then in
Access 2000 save the database in a previous version.

A2003 can convert a database to A97 format directly.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm