Is there any way to 'downversion' an Access database?

I have a database which is in Access 2000 format, and I need to transfer it to a system which has only Access 97 installed. It is not possible to upgrade the target system (due to an intransigent IT department :().

The database contains a few tables, forms, reports, and queries, so it will be annoying to export these one at a time. Is there any other way to do it?

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

__________________
-- Jeff

You can do it in Access 2000. Open the database you want to convert. Chose the option "To Prior Access Database Version" In the menu Tools\Database Utilities\Convert Database. I should to the trick.

Stéphane Lajoie

That was exactly what I was looking for. Thank you!

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

The only problem will be if there is any code at all in the forms, reports, etc. Also if the tables have cascade updates and cascade deletes, 97 does not support them.

If anything was created with ADO in 2000 will have to be referenced in 97. Make sure to test all objects to make sure they work after the downgrade. Do a decompile of the code to make sure that there is nothing outthere that could come back and get you.

Actually, do a compile in 2000 and make sure it compiles, then after downgrading it, compile the 97 version. it should show any code that could cause any problems.



Sal

Yeah, I had considered that.

Actually, it turns out that the database was originally written for Access97. It was converted without incident to Access2000 a while ago. We just recently uncovered a need to convert it back for somebody's laptop. Fortunately, the code is straightforward and compiled in both versions just fine.

Thanks for the heads up, though.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com