Must be an "updateable query"

My ASPX procedure connects to a MS Access 2003 database to update a record.
Everything appears to be in good shape -- and existing record with the same
key
user name (indexed) . But the update does not take and the following error
persists.

## Exceptions: ##System.Data.OleDb.OleDbException: Operation must use an
updateable query. at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandli ng(Int32 hr) at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleRe sult(tagDBPARAMS
dbParams, Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavio r behavior,
Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(Command Behavior
behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at Funding.DBMaintUserUpt.SQL_QUERY(String SQLQuery) in C:\Documents and
Settings\Dave
Fashenpour\VSWebCache\216-136-114-52.gen.twtelecom.net\Fundi ng\DBMaintUserUpt.aspx.vb:line 314

Traping the acual update query:

UPDATE sfnusers_dt SET
sfnPassword='hill',accountNum=1004,firstLogin=1,passwordRese t=0,lockout=0,seller_name='Matrix',seller_code=800400,temp_p w=0,temp_duration=0,Subdirectory='Matrix_800400',Pricing_Gro up='True',User_Title='Mr.',First_Name='William',Middle_Initi al='A.',Last_Name='Herman',Email_Address='wsherman@yahoo.com ',Primary_Phone='912-123-9999',Secondary_Phone='912-123-9999 ',Registration_Date='03/13/2006',sfnDisabled=0,sqlSync=0 WHERE sfnUser='Seller1'

My question is -- what are KIND OF THINGS that cause that error message?
I have checked many things -- but I must be missing something.

Thanks,

Dave.

Re: Must be an "updateable query"

DaveFash wrote:
> My ASPX procedure connects to a MS Access 2003 database to update a

There was no way for you to know it, but this is a classic asp newsgroup.
While you may be lucky enough to find a dotnet-savvy person here who can
answer your question, you can eliminate the luck factor by posting your
question to a newsgroup where the dotnet-savvy people hang out. I suggest
microsoft.public.dotnet.framework.aspnet.

However, read on:

> ## Exceptions: ##System.Data.OleDb.OleDbException: Operation must use
> an
> updateable query. at

This is the same error that occurs in classic asp when the proper filesystem
permissions for the folder containing the database file are not set. See
http://www.aspfaq.com/show.asp?id=2062, but where you see "IUSR" in this
article, substitute "ASPNET"

HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: Must be an "updateable query"

Thanks for the dotnet guidance and many, many
thanks for the answer to my problem... I had dropped
a new version of the Access Database onto the Server
and did not reset the permissions. I think you hit it right
on the head!! Thanks again.

Dave.

"Bob Barrows [MVP]" wrote:

> DaveFash wrote:
> > My ASPX procedure connects to a MS Access 2003 database to update a
>
> There was no way for you to know it, but this is a classic asp newsgroup.
> While you may be lucky enough to find a dotnet-savvy person here who can
> answer your question, you can eliminate the luck factor by posting your
> question to a newsgroup where the dotnet-savvy people hang out. I suggest
> microsoft.public.dotnet.framework.aspnet.
>
> However, read on:
>
> > ## Exceptions: ##System.Data.OleDb.OleDbException: Operation must use
> > an
> > updateable query. at
>
> This is the same error that occurs in classic asp when the proper filesystem
> permissions for the folder containing the database file are not set. See
> http://www.aspfaq.com/show.asp?id=2062, but where you see "IUSR" in this
> article, substitute "ASPNET"
>
> HTH,
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>
>