Access 97 / Word 2007 Mail Merge Issues

At present I am running Windows 7 64 bit with Microsoft Office 2007.

I also use a bespoke piece of software that uses access 97 databases. I am not able to port over to access 2007 due to the bespoke software needing access 97.

A major part of the bespoke software uses mail merge functionality into word. Due to hard drive issues I have had to re install the software on a new pc (windows 7 64 bit running ms office 2007.)

When ever I try to do a mail merge, there is an SQL error for linking to the access 97 database.

I am unsure how to correct this issue since I only have access 2007 on my computer. I suspect it has to do with the datasource or odbc driver.

Any help would be mutchly appreciated.

You will need to install Access 2.0 however, I'm not sure if Access/bespoke will integrate with Office 2007, especially if it is the 64bit version.

Regards,
GEWB

This topic is really outside my knowledge base. However, I wondered if the following Microsoft Articles might help:
How to convert an Access database to SQL Server

Irene, I appreciate the reply but the database has to stay in access 97.

GWEB
Lets make the assumption that Access 2.0 is installed and working on the PC.

How would Access 2.0 help with my problem?

[QUOTE=kipaqra;1547529]

Lets make the assumption that Access 2.0 is installed and working on the PC.

How would Access 2.0 help with my problem?

I did more research and Access 2.0 will not solve your problem - it looks like version 8.0 is what Access 97 used. Now I'm not sure how to help but I'll keep searching. Do you have Office 97 Professional vailable to install?

Regards,
GEWB

unfortunately no, i only have a legit copy of office 2007

kipaqra said:

unfortunately no, i only have a legit copy of office 2007

Bummer. As a side note, the MSDN site doesn't have Office 97 available any more - strange, as Office 95 is there!

I'll keep researching...

Regards,
GEWB