I am trying to set the Connection String of ADODC control. But i am not able to Create a Successfull Test Connection. I am getting an Error. "Test connection failed because of an error in initializing provider. Cannot start your application. The work group file is missing or opened exclusively by another user". I am using Access 2007 and I have password to my Database.
1
-
2Please post the full ADO connection string you are using, as a side note in the meantime check out (connectionstrings.com) as this will give you the correct string for your needs.Matt Donnan– Matt Donnan2012-07-10 14:18:38 +00:00Commented Jul 10, 2012 at 14:18
Add a comment
|
2 Answers
You probably have no sufficient file system rights to open *.mdw file and/or create *.ldb file on the fly. Best is to grant r/w access to *.mdb and *.mdw files AND file create/update/delete right to containing folder.
Note that you either have to use system.mdw file from some windows folder or custom *.mdw file in same folder as *.mdb files reside. The latest approach is recommended; sure you need to set connection properties accordingly.
4 Comments
hemant
I didn't get you can you explain it in details or provide the Steps..? Pls
Arvo
I think you have enough information here - setting file system access rights is covered in thousands internet pages and in windows help files. Not seeing your actual system I can't give more specific hints anyway.
hemant
I have placed .MDW and mdb file together and still i am not able to create connection.
Arvo
You need probably to use connection property "Jet OLEDB:System database" to specify mdw file.
It sounds like that the Access database you're trying to use is already open somewhere else. Verify that the Access database is closed before trying to open it in the Server Explorer. Additionally, make sure that it is closed in the Server Explorer before trying to use it within your application.
Try this syntax to connect Access 2007:
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<your db path>;Jet OLEDB:Database Password=<password>;"
For more details see Connection strings for Access 2007
