Last Clean Version Used (Language VB.Net Express 2005) :
As per Paul
Code below lives in the app.confi file
<connectionStrings>
<add name="CRUD.My.MySettings.PubsConnectionString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0 ; Data
Source=stlcc.org\SLF\Pubs.mdb; JetOLEDB:Database; User ID=someUser;
Password=somePassword;"
providerName="System.Data.OleDb"
/>
<add name="CRUD.My.MySettings.PubsConnectionString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0 ; Data
Source=stlcc.org\SLF\Pubs.mdb; User ID=someUser; Password=aGoodPassword;"
providerName="System.Data.OleDb"
/>
</connectionStrings>
I created a windows application, added a Grid Control and connected to the
Pubs.mdb Access database locally with no trouble. Next I copied Pubs to a
WebServer, changed the connection string by providing the IP address of the
web server but the error below occurs. I tried the domain name ( like
ibm.com\Folder) for the server and that failed also. I don't think I'm even
attempting to hit on the server! The error is shown below
An OleDBException was unhandled ==>
Me.AuthorsTableAdapter.Fill(Me.PubsDataSet.authors )
Error : Cannot start your application. The workgroup information file is
missing or opened exclusively by another user.
------------------------------------------------------------------------------------------
I did not create a Workgroup information file so it probably does not exist
on the server!
Is this a step I missed ???
------------------------------------------------------------------------------------------
Paul Clement MVP Suggests : : :
I tried and it still fails with the same error
Workgroup (system database):
"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=www.test.com\somepath\mydb.mdb;
Jet OLEDB:System Database=system.mdw;"
With password:
"Provider=Microsoft.Jet.OLEDB.4.0;
DataSource=www.test.com\somepath\mydb.mdb;
Jet OLEDB:Database
Password=MyDbPassword;"
================================================== =========================
"Charlie Brown" <cb****@duclaw.com> wrote in message
news:11*********************@j33g2000cwa.googlegro ups.com...
Bob Palank wrote: I created a windows application, added a Grid Control and connected to
the
Pubs.mdb Access database locally with no trouble. Next I copied Pubs to a
WebServer, changed the connection string by providing the IP address of
the
web server but the error below occurs. I tried the domain name ( like
ibm.com\Folder) for the server and that failed also. I don't think I'm
even
attempting to hit on the server! The error is shown below
An OleDBException was unhandled ==>
Me.AuthorsTableAdapter.Fill(Me.PubsDataSet.authors )
Error : Cannot start your application. The workgroup information file is
missing or opened exclusively by another user.
TIA
Bob
Try using the full URL path to the file. Here are three different
connection string options depending on your situation. If you post your
current connection string (masked for security of course) we can help
better.
Standard security:
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=www.test.com\somepath\mydb.mdb;User Id=admin;Password=;"
Workgroup (system database):
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=www.test.com\somepath\mydb.mdb;Jet OLEDB:System
Database=system.mdw;"
With password:
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=www.test.com\somepath\mydb.mdb;Jet OLEDB:Database
Password=MyDbPassword;"