Solved

Access 2.0 and Word 7

Posted on 1998-03-31
5
256 Views
Last Modified: 2008-03-03
I have a document that reads data from an access 2.0 file
when this document was in word 6 the process worked fine
Now in word 7 (the machines were upgrades to Win 95) I get an error that states the information could not be found.
Something about no Data Source There is data in the record
I checked and the file exist where stated.

 The exact error is

Microsoft Word- ODBC Error:[Microdoft][ODBC Driver Manager]
Data Source name not found and no default driver specified
Sql State: IM002
Return Code: SQL_ERROR

The Code for the Field is

{DATABASE \d "c:\\quickstart\\quickstart.mdb" \c "DSN=MS Access 2.0 Databases, DBQ=c:\\quickstart\\quickstart.mdb, FILE=RedISAM" \s "select Study_Number from \"QS_Temp\"" \f "1" \t "1"  \* MERGEFORMAT}


NO
I did that plus one other slight change and it worked thanks
Lock it and it's yours
0
Comment
Question by:sye
  • 2
  • 2
5 Comments
 
LVL 4

Expert Comment

by:siabod
ID: 1611962
Hi Sye,
I presume you installed the ODBC drivers for MS Acces 2.0 ?
0
 

Author Comment

by:sye
ID: 1611963
Edited text of question
0
 

Author Comment

by:sye
ID: 1611964
Edited text of question
0
 
LVL 3

Expert Comment

by:altena
ID: 1611965
You might want to upgrade access too.


0
 
LVL 4

Accepted Solution

by:
siabod earned 100 total points
ID: 1611966
Sorry for late reply

Thank you, siabod
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
Introduction It seems that at least a couple of times per month, I answer a question that requires automating Outlook from another Microsoft Office application, usually (although not always) to send one or more email messages.  For example: …
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question