Access won't open

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On a web form I'm trying to populate a grid using data in an mdb database. I've used the controls to setup the connection string, adaptor, dataset. The grid appears to be seeing the data (column heading etc...). But when I go to run...I get an error message on this line:
OleDbDataAdapter1.Fill(DataSet11)
The error states the database is either open (it's not) or I don't have permission to open it (no password necessary).

Any ideas????

Thanks
 
Well, you should be able to test the DataAdapter connection by right
clicking on it and testing the connection. If this is OK, you may have the
database open in another window ?

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .


Arne Beruldsen said:
On a web form I'm trying to populate a grid using data in an mdb database.
Click to expand...
I've used the controls to setup the connection string, adaptor, dataset.
The grid appears to be seeing the data (column heading etc...). But when I
go to run...I get an error message on this line:
OleDbDataAdapter1.Fill(DataSet11)
The error states the database is either open (it's not) or I don't have
Click to expand...
permission to open it (no password necessary).
 
I'm confused. Via the DataAdaptor...I can view the contents of the table. The error occurs when I run it...it refers to this line:

OleDbDataAdapter1.Fill(DataSet11)

The exact error message is:

The Microsoft Jet database engine cannot open the file 'C:\Arne's Stuff\Visual Basic Net\OnlineTesting\Tests.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Any ideas?

Arne
 
Sorry, I meant OledbConnection ( Not Adapter ). You can test the
connection/access to this. Otherwise, you have it open somewhere else,
either on your machine or from someon elses.

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .


Arne Beruldsen said:
I'm confused. Via the DataAdaptor...I can view the contents of the table.
Click to expand...
The error occurs when I run it...it refers to this line:
OleDbDataAdapter1.Fill(DataSet11)

The exact error message is:

The Microsoft Jet database engine cannot open the file 'C:\Arne's
Click to expand...
Stuff\Visual Basic Net\OnlineTesting\Tests.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.
 
Back
Top