I am using FP03, Server2003, IIS6 and 2002 FPSE. I uploaded an Access db,
created and tested a valid connection and then ran the wizard creating
ASP.Net pages.

I am able to browse the files in the db from the Results and Editor pages,
but I am unable to add, delete or modify the records. I get the generic
error - “The operation failed. If this continues, please contact your server
administrator.�

When I check the server logs its showing me a 401 permissions error. I am
the admin for this server and the RWD permissions are in place. Any help
would be appreciated.

Thanks

The *folder* where the Access database resides needs to allow Change access
to whatever account the Web server is using; typically one of the local
accounts IUSR_<computername> or ASPNET.

This is so access can create and delete its .ldb file.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------Â*-----------------------
|\----------------------------Â*-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------Â*-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------Â*-----------------------
*-----------------------------Â*-----------------------


"lsijax" wrote:

> I am using FP03, Server2003, IIS6 and 2002 FPSE. I uploaded an Access db,
> created and tested a valid connection and then ran the wizard creating
> ASP.Net pages.
>
> I am able to browse the files in the db from the Results and Editor pages,
> but I am unable to add, delete or modify the records. I get the generic
> error - “The operation failed. If this continues, please contact your server
> administrator.�
>
> When I check the server logs its showing me a 401 permissions error. I am
> the admin for this server and the RWD permissions are in place. Any help
> would be appreciated.
>
> Thanks
>

That did it Jim! Thanks

"Jim Buyens" wrote:

> The *folder* where the Access database resides needs to allow Change access
> to whatever account the Web server is using; typically one of the local
> accounts IUSR_<computername> or ASPNET.
>
> This is so access can create and delete its .ldb file.
>
> Jim Buyens
> Microsoft MVP
> http://www.interlacken.com
> Author of:
> *-----------------------------Â*-----------------------
> |\----------------------------Â*-----------------------
> || Microsoft Windows SharePoint Services Inside Out
> || Microsoft Office FrontPage 2003 Inside Out
> ||----------------------------Â*-----------------------
> || Web Database Development Step by Step .NET Edition
> || Microsoft FrontPage Version 2002 Inside Out
> || Faster Smarter Beginning Programming
> || (All from Microsoft Press)
> |/----------------------------Â*-----------------------
> *-----------------------------Â*-----------------------
>
>
> "lsijax" wrote:
>
> > I am using FP03, Server2003, IIS6 and 2002 FPSE. I uploaded an Access db,
> > created and tested a valid connection and then ran the wizard creating
> > ASP.Net pages.
> >
> > I am able to browse the files in the db from the Results and Editor pages,
> > but I am unable to add, delete or modify the records. I get the generic
> > error - “The operation failed. If this continues, please contact your server
> > administrator.�
> >
> > When I check the server logs its showing me a 401 permissions error. I am
> > the admin for this server and the RWD permissions are in place. Any help
> > would be appreciated.
> >
> > Thanks
> >