Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Access 97 / Word 2007 Mail Merge Issues


22 Aug 2011   #1

windows 7 64 bit
 
 
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.

My System SpecsSystem Spec
.

22 Aug 2011   #2

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux
 
 

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
My System SpecsSystem Spec
23 Aug 2011   #3

Windows 7 Home Premium 64bit
 
 

Hello kipaqra, welcome to the forum.

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
My System SpecsSystem Spec
.


23 Aug 2011   #4

windows 7 64 bit
 
 

Quote:
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?
My System SpecsSystem Spec
23 Aug 2011   #5

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux
 
 

[QUOTE=kipaqra;1547529]
Quote:
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
My System SpecsSystem Spec
23 Aug 2011   #6

windows 7 64 bit
 
 

unfortunately no, i only have a legit copy of office 2007
My System SpecsSystem Spec
23 Aug 2011   #7

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux
 
 

Quote   Quote: Originally Posted by kipaqra View Post
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
My System SpecsSystem Spec
Reply

 Access 97 / Word 2007 Mail Merge Issues




Thread Tools




Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 08:56 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33