ERROR: Test connection failed because of an error in initializing provider.

[abiola]

Hi all,
I need your help on how to resolve this issue. Details:

i am using Microsoft ADO Data Control, version 6.0(OLEDB) on my form.

when i try to build the connection by selecting properties of ADO control
an Activex Comtrol Propertoies dialog box appears.

there is a field for "Use connection String". When i press Build Button, which is in front of this text box a Data Link Properties dialogue box appears. On it i choose,Microsoft Jet 4.0 OLEDB DB Provider and press Next.
Now the "Connection tab" appears. it asks to select or enter a database name, so i browse and select my databse file and the following error occurs.

ERROR: Test connection failed because of an error in initializing provider. The database has been placed in a state by user 'Admin' on machine 'myservermachinename' that prevents it from being opened or locked.

I feel this error is due to some security setting. But i don't know how to resolve it. Any help will be well appreciated.
Thank you.

 

[Guus2005]

I do not have a solution to yor problem. However i do have a workaround: Don't use the data control. Use a recordset to populate the fields and release it. This way you are working stateless. There is never a permanent connection to your database. I think that's where the problem is...

Enjoy!

 

[Banana]

I'd bet the problem was that you had a self-reference and there were locks in place so you couldn't query that.

Guus is correct- you should be able to get to do what you need using recordset object, and if you have Access 2003, you can even set the recordset to a listbox or combobox or if you have Access 2000, to form itself instead of using recordsource.

HTH.

 

[abiola]

Thanks Guus2005 for the advise. I used your workaround.