Update Query in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have written an update query in the Query designer that works just fine
when run in the designer. It does require a date parameter. I tried copying
the SQL from the designer and created an ADO version of the query in VBA. It
does not work, I get the error Operation must use an updateable query. Why
would it work in the designer but not in VBA? All I'm trying to do is update
a field in table A from a field in Table B based on the date parameter.
 
Hi,


I suspect your cut and paste then modification produces a somehow
un-expected SQL statement. What is your VBA code?


Vanderghast, Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access update query 2
Parameter Query Won't Run 0
Update Table Field Value with SQL Query 2
Dcount returning no results!!! 0
Selecting correct records for parameter update query 2
Creating an update query that uses multiple parameters 2
Autoinsert of variable data into update query 6
update query vs make query 5

Back
Top