Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sql.request for secured Access Database record retrieval
I am using SQL.request to retrieve records from a secured
Access database into an Excel worksheet. It works great on a non-secured copy of the database. Doesn't work on secured database. This is formula used in an array: =SQL.REQUEST($A$4,,2,$A$5) where A4 = DSN=FM2;DBQ=\\GNAFP1\Anyone\FM\FM-old.mdb A5 = SELECT ({list of fields})FROM {table name}WHERE ({Field Name}='{Criteria}') order by {field Name} desc I set up the DSN (FM2) and it works with the non secured copy but not the secured copy. DSN contains DB Name with ID & password to system file. I'm don't think I need the DBQ info (since DB name & path are part of DSN)? I appreciate any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique Record retrieval. | Excel Discussion (Misc queries) | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
How to open a secured Access db from Excel | Excel Discussion (Misc queries) | |||
Get Data from a secured Access database | Excel Discussion (Misc queries) | |||
Help: pivot chart data in secured Access database wont show fields | Charts and Charting in Excel |