Connection string problem

[Barry Rainbird]

I have an Excel.xlsx spreadsheet which draws down information from my Access 2007 database via many links. Try as I might I cannot find how to replicate the type of linkage to accommodate ACCDB where they were all originally set up to accommodate MDB. Each link is part of a table in Access. Now when I setup a link to the ACCDB table all I seem to be able to do is draw down the whole table's data-set and not part as used to be the case. This has worked fine for several years and to try and remake it to accommodate the different dataset setup would be difficult.

As an example of the connection strings:

DBQ=C:\MSOffice\Access\New Park Nursery\Management System.mdb;DefaultDir=C:\MSOffice\Access\New Park Nursery;Driver={Microsoft Access Driver (*.mdb)};DriverId=281;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UserCommitSync= Yes;

And an example of the same string's Command Text:

SELECT `Booking Database`.`Wednesday PM`, `Booking Database`.`Date of birth`, `Booking Database`.Surname, `Booking Database`.`Child Leaving Date`
FROM `C:\MSOffice\Access\New Park Nursery\Management System`.`Booking Database` `Booking Database`
WHERE (`Booking Database`.`Wednesday PM`=1)
ORDER BY `Booking Database`.`Date of birth` DESC

I have tried altering the existing details of all the connection strings an example as follows:

DBQ=C:\MSOffice\Access\New Park Nursery\Management System.accdb;DefaultDir=C:\MSOffice\Access\New Park Nursery;Driver={Microsoft Access Driver (*.mdb)(*.accdb)};DriverId=281;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UserCommitSync= Yes;

but to no avail. Can anyone suggest a way forward which doesn't require me to re-write the whole spreadsheet connection calculation sheet?
Many thanks
Barry R

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/micros...tion-string-problem-excel-access-linkage.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).