Word was unable to open data source

N

Nick Fritzler

I was asked to paste my code back to the newsgroup. I am
getting an "Word was unable to open data source" error
when I try to use this code.

{DATABASE \d "C:\\warranty\\Warranty.mdb" \c "DSN=MS
Access;DBQ=C:\\warranty\\Warranty.mdb;DriverId=25;FIL=MS
Access;MaxBufferSize=512;PageTimeout=5;" \s "SELECT
CustomerID, SerialNumber, ModelNumber, PurchaseDate,
PurchasePrice FROM MasterCustDetail WHERE CustomerID
= '{MERGEFIELD CustomerID}'" \l "4" \b "447" \h}

Once again, this code came off of an MVP's web site, and I
got it to work with the Northwind database. When I
referenced my database and changed the fields I got the
error. The table "MasterCustDetail" has 8 fields.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GREAT NEWS 0
Mail Merge Functionality 0
Database Field SQL Statement 9
Database Field Switch 1
Unpaid Invoices to customers 5
Unable to open data source 2
Merge a list in a document 2
Word Database Field 3

Top