Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Access 2.0 and Word 7

Posted on 1998-03-31
Medium Priority
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}

I did that plus one other slight change and it worked thanks
Lock it and it's yours
Question by:sye
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2

Expert Comment

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

Author Comment

ID: 1611963
Edited text of question

Author Comment

ID: 1611964
Edited text of question

Expert Comment

ID: 1611965
You might want to upgrade access too.


Accepted Solution

siabod earned 400 total points
ID: 1611966
Sorry for late reply

Thank you, siabod

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

618 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