Access won't open

[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

 

[One Handed Man \( OHM - Terry Burns \)]

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 . . .

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).

 

[Guest]

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

 

[One Handed Man \( OHM - Terry Burns \)]

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 . . .

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.