Problems with data updating following changing machine

[=?Utf-8?B?SnVsaWEgQg==?=]

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

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

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

[=?Utf-8?B?SnVsaWEgQg==?=]

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