AccessDB on a WebServer

  • Thread starter Thread starter Bob Palank
  • Start date Start date
B

Bob Palank

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
 
Bob said:
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
Click to expand...

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;"
 
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;"
===========================================================================
 
Make sure on your webserver that you enable read/write/execute
permissions on the folder and the database file.
 
I checked and was told that the permissions are set to
read/write/execute on both the folder and the database file.
Now, as I see it, the Pubs.mdb database lives in a folder on the webserver
with the appropriate permissions.
Using the connection string previously discussed, I ought to be able to get
access to that database and display records in the GridView on a client
machine.
Is this correct ?
Is there some example of a mdb (perhaps Pubs.mdb) living on some server
that is publically accessible using VB.Net ?
Still Stuck
Bob
 
Bob,
Now, as I see it, the Pubs.mdb database lives in a folder on the webserver
with the appropriate permissions.
Click to expand...

Are you sure of that because the ASPNET user is ASPNET.

Cor
 
Thanks, I got past one error and now have another.

My Assumptions:
1. One can use VB.Net Express 2005 to write a client resident application to
access an .mdb file living on a remote server.
2. No Microsoft Access code elements need to reside on the remote server
except the *.mdb file.
3. On the remote server, permissions need be set so that anyone can have
read access to that Access database.
Are these assumptions true ?

If the assumptions are true, the local error message

Me.AuthorsTableAdapter.Fill(Me.PubsDataSet.authors)==>Could not find
installable ISAM

does not make sense to me.

TIA for any help.

Bob
 
Back
Top