<div>
Hi Sye,<br />
I presume you installed the ODBC drivers for MS Acces 2.0 ?<br />

</div>


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


<div>
Edited text of question<br />

</div>


<div>
You might want to upgrade access too. <br />
<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
I have a document that reads data from an access 2.0 file<br />
when this document was in word 6 the process worked fine<br />
Now in word 7 (the machines were upgrades to Win 95) I get an error that states the information could not be found.<br />
Something about no Data Source There is data in the record <br />
I checked and the file exist where stated. <br />
<br />
&nbsp;The exact error is <br />
<br />
Microsoft Word- ODBC Error:[Microdoft][ODBC Driver Manager]<br />
Data Source name not found and no default driver specified<br />
Sql State: IM002<br />
Return Code: SQL_ERROR<br />
<br />
The Code for the Field is<br />
<br />
{DATABASE \d &quot;c:\\quickstart\\quickstar<wbr />t.mdb&quot; \c &quot;DSN=MS Access 2.0 Databases, DBQ=c:\\quickstart\\quicks<wbr />tart.mdb, FILE=RedISAM&quot; \s &quot;select Study_Number from \&quot;QS_Temp\&quot;&quot; \f &quot;1&quot; \t &quot;1&quot; &nbsp;\* MERGEFORMAT}<br />
<br />
<br />
NO <br />
I did that plus one other slight change and it worked thanks<br />
Lock it and it's yours
</div>
</div>


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

Access 2.0 and Word 7

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.