Jet DataBase Permission Problem

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

Guest

I'm using a Webform which contains a datagrid. The datagrid is being populated from an Access database. When I use the Adaptor Control it allows me to preview the data with no problems. However, when I run the app...I get the following error message:

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.

I'm not using any passwords and the database is not open.

I'm stumped...please help.

Thanks
 
Hi Arne,

Mostly is this a connectionsstring problem

http://www.connectionstrings.com/

http://www.able-consulting.com/ADO_Conn.htm

Otherwise you have to show some code or to tell if you use the designeer to
create the connection or do it by code?

I hope this helps?

Cor
I'm using a Webform which contains a datagrid. The datagrid is being
Click to expand...
populated from an Access database. When I use the Adaptor Control it allows
me to preview the data with no problems. However, when I run the app...I
get the following error message:
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.
 
I'm just using the controls. First the DataAdaptor (OleDb). I select Jet 4...then point to my database. I generate the Dataset. I can preview the dataset...and it fills with the correct data. Everything appears fine...except when I select run (F5).

If I do the same thing on a windows form...it works fine. But this is on a webform.

I'm confused...
 
Hi Arne,

Mostly is this a permission problem, your aspnet user is mostly ASPNET when
it has no permission to that database you get that answer,

(I did not focus on webform in my previous anwer)

I hope this was the answer?

Cor
I'm just using the controls. First the DataAdaptor (OleDb). I select Jet
Click to expand...
4...then point to my database. I generate the Dataset. I can preview the
dataset...and it fills with the correct data. Everything appears
fine...except when I select run (F5).
 
So what do I do to create the 'proper' permission. Is this something in the project setup?

Thanks...
 
Hi Arne,

No go to your Admin (or do it yourself) and give the access file the right
access rights for the ASPNET user.

Cor
 
¤ I'm using a Webform which contains a datagrid. The datagrid is being populated from an Access database. When I use the Adaptor Control it allows me to preview the data with no problems. However, when I run the app...I get the following error message:
¤
¤ 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.
¤
¤ I'm not using any passwords and the database is not open.
¤
¤ I'm stumped...please help.

See the following:

PRB: Cannot connect to Access database from ASP.NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;316675&Product=aspnet


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top