Updating Access DB in ASP

[jcfrykland]

I am trying to resolve the following error message when
trying to update an Access 2000 database in ASP:

Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.

The environment is XP Professional, IIS 5.0, and Access
2000 all running on the same processor. Eventually, I
want to move this application to my website. All
information and suggestions will be welcomed.

John

[Chris Leonard]

Have you tried doing this using SQL ?

I had loads of problems doing something similar, I now use straight SQL,
i.e.

Update mytable set myfield = 'mydate' where x = 1

or inserts:

Insert into mytable (field1, field2) values (value1, value2)

Maybe this won't solver your problem, but it solved mine, hope it helps you.

Chris

[Bob Barrows]

[url]http://www.aspfaq.com/show.asp?id=2326[/url]
jcfrykland wrote:

> I am trying to resolve the following error message when
> trying to update an Access 2000 database in ASP:
>
> Microsoft JET Database Engine (0x80040E09)
> Cannot update. Database or object is read-only.
>
> The environment is XP Professional, IIS 5.0, and Access
> 2000 all running on the same processor. Eventually, I
> want to move this application to my website. All
> information and suggestions will be welcomed.
>
> John