Problems with data updating following changing machine

Hi all

I'm using .NET 1.1 and connecting to an Access database.

I've recently got a new pc and am having terrible problems getting my web
applications to work properly on my localhost. Although I can run my
application and connect to my datasource for reading, any time I try and
edit/add a record I get the OLEDB error that the operation must use an
updateable query.

I've googled and this seems to be a permissions problem. I believe I have
set everything up as on my old machine. I've given my machine ASPNET account
rights to my localhost directory and checked the IIS settings, but it just
won't work.

Is there anything else I need to do in Visual Studio or anywhere else for
that matter?

Thanks

Julia

RE: Problems with data updating following changing machine

This is the exception you'll get when the ASPNET account (or whatever account
your apps are running under) cannot write to the folder where the MDB file
resides.
Right - click the folder, choose the Security Tab from Properties, and grant
ASPNET "Full" rights.
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
MetaFinder: http://www.blogmetafinder.com


"Julia B" wrote:

> Hi all
>
> I'm using .NET 1.1 and connecting to an Access database.
>
> I've recently got a new pc and am having terrible problems getting my web
> applications to work properly on my localhost. Although I can run my
> application and connect to my datasource for reading, any time I try and
> edit/add a record I get the OLEDB error that the operation must use an
> updateable query.
>
> I've googled and this seems to be a permissions problem. I believe I have
> set everything up as on my old machine. I've given my machine ASPNET account
> rights to my localhost directory and checked the IIS settings, but it just
> won't work.
>
> Is there anything else I need to do in Visual Studio or anywhere else for
> that matter?
>
> Thanks
>
> Julia

RE: Problems with data updating following changing machine

Thanks Peter

I've now done that and all is OK.

Julia

"Peter Bromberg [C# MVP]" wrote:

> This is the exception you'll get when the ASPNET account (or whatever account
> your apps are running under) cannot write to the folder where the MDB file
> resides.
> Right - click the folder, choose the Security Tab from Properties, and grant
> ASPNET "Full" rights.
> -- Peter
> Site: http://www.eggheadcafe.com
> UnBlog: http://petesbloggerama.blogspot.com
> MetaFinder: http://www.blogmetafinder.com
>
>
> "Julia B" wrote:
>
> > Hi all
> >
> > I'm using .NET 1.1 and connecting to an Access database.
> >
> > I've recently got a new pc and am having terrible problems getting my web
> > applications to work properly on my localhost. Although I can run my
> > application and connect to my datasource for reading, any time I try and
> > edit/add a record I get the OLEDB error that the operation must use an
> > updateable query.
> >
> > I've googled and this seems to be a permissions problem. I believe I have
> > set everything up as on my old machine. I've given my machine ASPNET account
> > rights to my localhost directory and checked the IIS settings, but it just
> > won't work.
> >
> > Is there anything else I need to do in Visual Studio or anywhere else for
> > that matter?
> >
> > Thanks
> >
> > Julia