Permissions problem

[MikeR]

I'm running IIS on an XP Pro box w/FP extensions. I have an ASP form (no wizzard) that
updates an Access database. It works perfectly on the remotge server, but not on my local
box(reads fine, so the connection is good).
The error is:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

The folder has Full Control by Everyone (which was not in the list to add to permissions).
by admins, and by me as a user. It's not read only.

In IIS, the folder Read/Write, Scripts only, anonymous access, Allow IIS to control
password, andd Integrated Windows authentication.

Clues, hints, suggestions, instructions?
MikeR

 

[Ken Jenkins]

do a goole search on that error
it is not permissions.. it is your cursor type in your code or something
most likely

 

[MikeR]

Ken -
I've googled til I have to wear glasses. <g> One of the hits on MS site says permissions.
As I said in th OP, it works fine on the remote server. The cursor and lock are correct.
Any more suggestions?
MikeR

do a goole search on that error
it is not permissions.. it is your cursor type in your code or something
most likely

I'm running IIS on an XP Pro box w/FP extensions. I have an ASP form (no
wizzard) that updates an Access database. It works perfectly on the
remotge server, but not on my local box(reads fine, so the connection is
good).
The error is:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.

The folder has Full Control by Everyone (which was not in the list to add
to permissions).
by admins, and by me as a user. It's not read only.

In IIS, the folder Read/Write, Scripts only, anonymous access, Allow IIS
to control password, andd Integrated Windows authentication.

Clues, hints, suggestions, instructions?
MikeR

 

[Stefan B Rusynko]

You'll find info on it at http://www.aspfaq.com/show.asp?id=2009




| Ken -
| I've googled til I have to wear glasses. <g> One of the hits on MS site says permissions.
| As I said in th OP, it works fine on the remote server. The cursor and lock are correct.
| Any more suggestions?
| MikeR
|
| Ken Jenkins wrote:
| > do a goole search on that error
| > it is not permissions.. it is your cursor type in your code or something
| > most likely
| >
| >
| >
| > | >
| >>I'm running IIS on an XP Pro box w/FP extensions. I have an ASP form (no
| >>wizzard) that updates an Access database. It works perfectly on the
| >>remotge server, but not on my local box(reads fine, so the connection is
| >>good).
| >>The error is:
| >>
| >>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
| >>[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
| >>query.
| >>
| >>The folder has Full Control by Everyone (which was not in the list to add
| >>to permissions).
| >>by admins, and by me as a user. It's not read only.
| >>
| >>In IIS, the folder Read/Write, Scripts only, anonymous access, Allow IIS
| >>to control password, andd Integrated Windows authentication.
| >>
| >>Clues, hints, suggestions, instructions?
| >>MikeR
| >
| >
| >

 

[MikeR]

Thanks Stefan - That did it.
MikeR