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

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Roly Reefer

Board Regular
Joined
Jun 27, 2005
Messages
58
Hi,

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

HTH,


Roly
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
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
 

Forum statistics

Threads
1,181,658
Messages
5,931,271
Members
436,785
Latest member
KingGideon

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
Top