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

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

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

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

[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

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

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
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
How can I mail merge with a locked Access DataBase?
Hi guys We have a help desk inquiry at the moment that I have no idea about. I have attempted several things over the last hour and cannot for the life of me get it working. Am I able to mail merge a letter in word with fields in a LOCKED Access DataBase? Your friend -Iroro
Microsoft Office
Cannot access the Ribbon functions in Excel 2007 or Word 2007
I have Office 2007 on Windows 7. When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen). If, I switch to another open sheet/doc and then switch back the ribbon is accessible again! I have...
Microsoft Office
send email in live mail direct from word 2007 doc
I am trying to send email direct or as attachment direct from Windows Live Mail direct from a Word 2007 home and student document. I Šm using Windows 7 home premium 64 bit with Office 2007 home and student Word I am not techy - does the word MAPI (not IMAP) mean anything in this...
Browsers & Mail


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:19.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App