Jet DataBase Permission Problem

[Arne Beruldsen]

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\OnlineTesti ng\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...pleas e help.

Thanks

[Cor Ligthert]

Re: Jet DataBase Permission Problem

Hi Arne,

Mostly is this a connectionsstri ng 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
[color=blue]
> I'm using a Webform which contains a datagrid. The datagrid is being[/color]
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:[color=blue]
>
> The Microsoft Jet database engine cannot open the file 'C:\Arne's[/color]
Stuff\Visual Basic Net\OnlineTesti ng\Tests.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.[color=blue]
>
> I'm not using any passwords and the database is not open.
>
> I'm stumped...pleas e help.
>
> Thanks[/color]

[Arne Beruldsen]

Re: Jet DataBase Permission Problem

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

"Cor Ligthert" wrote:
[color=blue]
> Hi Arne,
>
> Mostly is this a connectionsstri ng 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
>[color=green]
> > I'm using a Webform which contains a datagrid. The datagrid is being[/color]
> 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:[color=green]
> >
> > The Microsoft Jet database engine cannot open the file 'C:\Arne's[/color]
> Stuff\Visual Basic Net\OnlineTesti ng\Tests.mdb'. It is already opened
> exclusively by another user, or you need permission to view its data.[color=green]
> >
> > I'm not using any passwords and the database is not open.
> >
> > I'm stumped...pleas e help.
> >
> > Thanks[/color]
>
>
>[/color]

[Cor Ligthert]

Re: Jet DataBase Permission Problem

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
[color=blue]
> I'm just using the controls. First the DataAdaptor (OleDb). I select Jet[/color]
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).[color=blue]
>
> If I do the same thing on a windows form...it works fine. But this is on[/color]
a webform.[color=blue]
>
> I'm confused...
>[/color]

[Arne Beruldsen]

Re: Jet DataBase Permission Problem

So what do I do to create the 'proper' permission. Is this something in the project setup?

Thanks...

"Cor Ligthert" wrote:
[color=blue]
> 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
>[color=green]
> > I'm just using the controls. First the DataAdaptor (OleDb). I select Jet[/color]
> 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).[color=green]
> >
> > If I do the same thing on a windows form...it works fine. But this is on[/color]
> a webform.[color=green]
> >
> > I'm confused...
> >[/color]
>
>
>[/color]

[Cor Ligthert]

Re: Jet DataBase Permission Problem

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
[color=blue]
> So what do I do to create the 'proper' permission. Is this something in[/color]
the project setup?[color=blue]
>
> Thanks...
>
> "Cor Ligthert" wrote:
>[color=green]
> > Hi Arne,
> >
> > Mostly is this a permission problem, your aspnet user is mostly ASPNET[/color][/color]
when[color=blue][color=green]
> > 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
> >[color=darkred]
> > > I'm just using the controls. First the DataAdaptor (OleDb). I select[/color][/color][/color]
Jet[color=blue][color=green]
> > 4...then point to my database. I generate the Dataset. I can preview[/color][/color]
the[color=blue][color=green]
> > dataset...and it fills with the correct data. Everything appears
> > fine...except when I select run (F5).[color=darkred]
> > >
> > > If I do the same thing on a windows form...it works fine. But this is[/color][/color][/color]
on[color=blue][color=green]
> > a webform.[color=darkred]
> > >
> > > I'm confused...
> > >[/color]
> >
> >
> >[/color][/color]

[Paul Clement]

Re: Jet DataBase Permission Problem

On Sat, 19 Jun 2004 19:51:01 -0700, "Arne Beruldsen" <ArneBeruldsen@ discussions.mic rosoft.com>
wrote:

¤ 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\OnlineTesti ng\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...pleas e 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 ~~~ pclement@amerit ech.net
Microsoft MVP (Visual Basic)