ADO connection to MSAccess 2000

[DingDong]

Hello,
Register to MS 11. Running it from XP SP2.
I want to connect with ADO to a pw protected MSAccess DB located on the C:\ drive.

I run the following script without success.

Code: Select all

//Connect to Datasource
//
Let>str=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Desjardins\Suvriq\Repres.mdb;User Id=admin;Password=XGVDLX; 
DBConnect>str,dbRep
//
//Perform SELECT query
//
DBQuery>dbRep,SQL,CLIENTS,NumRecs,NumFields 
Message>records %NumRecs% 
Message>records %NumFields%
//
//Close database connection
DBClose>dbRep

Could you help me on this one please?

Thank you!

[adroege]

//
//Perform SELECT query
//
DBQuery>dbRep,SQL,CLIENTS,NumRecs,NumFields
Message>records %NumRecs%
Message>records %NumFields%

First thing I notice is that there is no SQL query defined to run.
Like the following:

Code: Select all

Let>SQL=select * from your_table

[DingDong]

Thank you adroege for your answer. I have adjust the code.

Code: Select all

//Connect to Datasource
//
Let>str=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Desjardins\Suvriq\Repres.mdb;User Id=admin;Password=XGVDLX; 
DBConnect>str,dbRep
//
//Perform SELECT query
//
Let>SQL=select * from CLIENTS
DBQuery>dbRep,SQL,CLIENTS,NumRecs,NumFields 
Message>records %NumRecs% 
Message>records %NumFields%
//
//Close database connection
DBClose>dbRep

MS is issuing an error message:



As you can see it's french.

If I tried to translate:

Impossible to start your application. The working group file informations is absent or open in exclusive mode by another user.

Any idea how to solve this issue?

Thank you!

[JRL]

I don't really know but to make a guess.

The error message indicates the file is in use and locked.

Your connection string indicates the file is on the C: drive. Perhaps the file location is shared and someone on the network has the file open. Or, do you have the file open in Access at the same time you're trying to open it from Macro Scheduler?

[DingDong]

Thank you JRL for your answer.

I have edit the script with another DB and the script worked.

This post should be edit as solved.

Again, thank you all.