Making an Access 97 friendly .mdb from Access XP

[RichardBott]

I have an Access XP application that I split into 2 to separate the application tables from the application forms etc for maintenance purposes. Is there any way I can convert this to Access 97?

Can I combine these 2 XP .mdb's into one? If I can, is a subsequent conversion to Access 97 fairly easy?

Thanks for any help you can give.

RjB

 

[hymn]

You could import them into 1 db
File
Get External Data
Import

to convert into 97
Tools
Database utilities
Convert Database

Hope this helps
Hymn

 

[RichardBott]

Hi Hymn,

In my split application - database, I have links to the application tables. Do I need to 'unlink' the tables before importing them? If I import while the links are there, each database table is imported and named with a '1' appended to the name. I presume my application will still access the linked tables. How do I do the 'un-link'

I could delete the linked tables through the application before doing the import and then do the import but am not convinced that the application will reference the imported tables.

I am also having a really hard time with the linked table manager. I do not seem to have any way of pointing the application to a different database .mdb when the linked database exists. Do you know any way this can be done?

Thanks for your help...

RjB

 

[hymn]

you could create a new db and import all tables, queries, forms,macro's and modules, you then have a new db with the old ones still there in case of any problems


Hope this helps
Hymn

 

[Hap007]

Dear RichardBott,

Can do, no problem, but there are several steps necessary.
1) AccessXP knows about Access 97
2) Access97 knows nothing about AccessXP
3) When you split your programs into a db, that is called a frontend (Program) and the db that holds the tables is called a backend.

So, to convert your app, first open your backend and convert that to Access97. I would call it xyzData97.mdb

Then convert your frontend into and Access97 mdb. Call it something like MyApp97.mdb

Now, you must open your Your MyApp97 Frontend and select
Tools > Addins > Linked Table manager.

Select all tables
Now you need to be prompted, so make sure that you check 'Always Prompt for new location'
When asked, then select xyzData97.mdb and press ok

Note:
AccessXP Frontend can link to AccessXP or Access97 backend
but...
Access97 Frontend can only link to Access97 backend.

Note:
If you want to select a new backend location or file in link table manager, you must always check true 'Always Prompt for new location'.

Good Luck,
Hap...



Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[RichardBott]

Hi Hymn,

I deleted all the links (only the links were removed, the database remained in the other .mdb so this was OK).

I imported the tables and that seemed to work fine so I have resolved that issue.

Now I have another; following the consolidation of applicatioon and database, I converted from an XP database to a '97 database. The conversion seemed to work fine but when I tried to run the resulting converted .mdb on a Win 98 platform with Access 97, it died! Didn't have a chance to investigate further since I figured it was likely an incompatibility between XP & '97. The problem occurred when I was trying to connect using "set conDB = CurrentProject.Connection". I am using ADODB in XP, maybe that's not available in '97 or maybe it's not the default and I need to include the ADODB-specific prefix on all the calls.

Could that be it?

Thanks for your help...
RjB