Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

asp UPDATE Query to MS Access DB

Posted on 2012-04-01
2
278 Views
Last Modified: 2012-04-05
I have an asp page that generates an error when attempting to update a table in an Access database.  If I copy and paste the SQL query directly into Access it works just fine.  Error generated on the "adoCmd.Execute"  command is:

 "-2147467259 [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. "


Dim adoCon, rsDatabase, strSQL                           

strSQL = "UPDATE 201204 SET AM='R', PM='R' WHERE D1='01';"

Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("charter.mdb")
Set rsdatabase = Server.CreateObject("ADODB.Recordset")
Set adoCmd = Server.CreateObject("ADODB.Command")
adoCmd.ActiveConnection = adoCon
adoCmd.CommandText = strSQL
adoCmd.Execute
0
Comment
Question by:MERCOMMS
2 Comments
 
LVL 10

Accepted Solution

by:
plummet earned 150 total points
ID: 37793676
Hi

Check out this MS support article: http://support.microsoft.com/kb/175168

It may well be one of the issues listed in there. I hope so!
0
 

Author Closing Comment

by:MERCOMMS
ID: 37812209
It was a permissions issue.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ejb example issues 3 19
Set WorkSheet  not Working 9 38
Select question from MySQL 1 10
learn programming 8 30
A short article about a problem I had getting the GPS LocationListener working.
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question