Access Revert

quezocotl

New Member
Joined
Jul 25, 2007
Messages
4
I have an mdb I created in Access 2003, but needs to be put on a machine that uses Access 97. I have '03 and '97 installed on my machine. But, when I try to open the '03 in Access 97, I get an unrecognized format error. Does anyone have any idea how I can create an Access 97 parallel of my 2003 mdb without recreating it?

Oh, and 'yes,' I have already tried to import the elements into a new 97 mdb.

Thanks!

Chris.
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Hi,

You need to convert the database using Access 2003 to 97 Format. Tools, Database Utilities, Convert Database, To Access 97 Format.

HTH,


Roly
 
Upvote 0
If you're going to do that, and you're sharing with other users who want to use the same data, do this:

1. Split the database into front end and back end if you haven't already done so
2. Convert both the front end and the back end to Access 97
3. Link both front ends to the Access 97 version of the back end. Access 2003 will happily read and write to back end databases in earlier formats, but if you need to make changes to the structure (New tables / fields / field definitions), you will need to directly open the back end in Access 97 and make your changes, then re-link if you have added any tables.

Denis
 
Upvote 0

Forum statistics

Threads
1,222,095
Messages
6,163,900
Members
451,865
Latest member
dunworthc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top