Error Updating

[Dave U]

Hi All,

I am getting the following error when I try to update/edit records. I am using Pro on a MSIIS5.0 server with an Access database.

Error # = 80004005
Description = [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = S1000
NativeError = -3035

Same error comes up with the ASPpro asp-test-pro.asp page that comes with our download.

Any and all suggestions would help.

DaveU

[Mark]

Access says: "Operation must use an updateable query" when the Update Now button is clicked.

PROBABLE CAUSE:
User does not have "write" privileges.

SOLUTION:

Using MTS, when you create a Package, the Account it uses is:
'Interactive user - the current logged on user'. That's all well
and good until you log off from the server! The solution to having
your ASPdb DLL run while your server is logged is simple:

1) Open MTS (Internet Service Manager)
2) Click on Computers / My Computer / Packages Installed /
name_of_aspdb_package
3) Right click on that package and choose Properties
4) Choose the IDENTITY tab and click on "This user:"
5) Enter the user id and password for an ID with read and execute
and WRITE privileges for that DLL.
As a test only, you can just use an Admin id & password.
6) Click OK to apply the changes.






------------
Dave U at 7/14/00 9:08:23 PM

Hi All,

I am getting the following error when I try to update/edit records. I am using Pro on a MSIIS5.0 server with an Access database.

Error # = 80004005
Description = [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = S1000
NativeError = -3035

Same error comes up with the ASPpro asp-test-pro.asp page that comes with our download.

Any and all suggestions would help.

DaveU

[dave]

Thanks. Works great now!!

DaveU


------------
Mark at 7/14/00 9:23:45 PM

Access says: "Operation must use an updateable query" when the Update Now button is clicked.

PROBABLE CAUSE:
User does not have "write" privileges.

SOLUTION:

Using MTS, when you create a Package, the Account it uses is:
'Interactive user - the current logged on user'. That's all well
and good until you log off from the server! The solution to having
your ASPdb DLL run while your server is logged is simple:

1) Open MTS (Internet Service Manager)
2) Click on Computers / My Computer / Packages Installed /
name_of_aspdb_package
3) Right click on that package and choose Properties
4) Choose the IDENTITY tab and click on "This user:"
5) Enter the user id and password for an ID with read and execute
and WRITE privileges for that DLL.
As a test only, you can just use an Admin id & password.
6) Click OK to apply the changes.






------------
Dave U at 7/14/00 9:08:23 PM

Hi All,

I am getting the following error when I try to update/edit records. I am using Pro on a MSIIS5.0 server with an Access database.

Error # = 80004005
Description = [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = S1000
NativeError = -3035

Same error comes up with the ASPpro asp-test-pro.asp page that comes with our download.

Any and all suggestions would help.

DaveU