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
kipaqra

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
GEWB

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM
 
 

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
Irene

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
kipaqra

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
GEWB

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM
 
 

[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
kipaqra

windows 7 64 bit
 
 

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

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM
 
 

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




Similar help and support threads
Thread Forum
Need help with Word 2007 mail merge. Hard to explain.
This may or may not be a word problem. It may be something that can be accomplish in Access. I am doing a mail merge in word. The mail merge may produce 1 sheet or it may produce 10 sheets, depending on the amount of fields it needs to print. Example: I need to print coupons. One person may...
Microsoft Office
Mail merge with Word 2010
Hi I am just trying to learn how to mail merge with word 2010 I start Word then click on Mailings, then click on start mail merge, then click on envelopes, then select the size of envelope, then select recipients, and all works ok except the address block is almost at the bottom of the envelope...
Microsoft Office
Excel-Word 2007 Label Merge
Hello I need to label 600 Minidv boxes with titles ranging from Tape #1 through Tape #600 Is there a way to do a label merge from Excel into Word 2007 (Label Avery 5167) ? Within Excel in column A I created a text range from Tape #1 down to Tape #600 I donít know how to export into Word that...
Microsoft Office
Problem printing envelope addresses in Word Mail Merge
I'm trying to print out a christmas card list using mail merge in Word. I've entered the names and addresses and the list is fine but when I try to print the addresses on the envelopes, they don't align properly on the envelopes. I've tried different size envelopes from the list provided by Word...
Microsoft Office
Lotus Notes and Word 2007 mail merge problem
Hi, There is a problem with Lotus Notes and Word 2007. Mail merge is not working with Word 2007 and Lotus Notes 8.5. It is working well in Windows XP, but it is not working in Windows 7. It says that you donít have mail program installed, although Lotus Notes is a default mail client.
Microsoft Office


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 09:35.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App