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
 
Back
Top