Anyone seen this VB5 error ...

[Lil Dave]

Hi,

the error reads ...

3073 : Operation must use an updatable query

... what should I be looking ?

The help didn't

Cheers Dave

[VorTechS]

Looks like you are trying to run an SQL statement on a database and the syntax isn't quite right.

Got an example?

[Lil Dave]

Will do ... my code computer is memory less at the moment ... shoul dbe able to post the offending SQL in about 24 hours.

Cheers Dave

[JohnAtWork]

More specifically, you're trying to run an Update or a Delete query, and you have a join.

Updates/Deletes can't join to a query; under certain circumstances you can join two tables together.

Give some of the SQL and we can go from there.