>>Here is the code with the exact path I'm using to test...
>>
>>
>>constring = "DBQ=C:\Progs\ccad07\files\AMW.mdb; Driver={Driver do Microsoft Access (*.mdb)}; DriverId=25; FIL=MS Access; MaxBufferSize=2048; MaxScanRows=8"
>>sqlHandler = SQLSTRINGCONNECT(constring)
>>select * from data1!MsAccess1
>>
>
>Kevin,
>even if you are connected to some other DataBase (in your case Access) you can't query it directly. You must use so called SPT (SQL-Pass through) or RemoteViews. Check all topics in HELP thats start with SQL* and all for RemoteViews.
I already have a Remote View set up -this is called MsAccess1. It points to the .mdb file.
I've tried USEing it and/or SELECTing from it. But I always get that 'find file/path' window.
I know my problem probably sounds very basic and it would help me understand it all if I spent some time reading up on how it all works, etc., but I need to do that another time -separately from this one small job.
For now, I only want to automate the selection of all records from this one (MSACCESS) file. Nothing is being written back to it.