Results 1 to 4 of 4

Thread: Anyone seen this VB5 error ...

  1. Feb 20th, 2000, 03:10 PM #1
    Lil Dave
    Lil Dave is offline

    Thread Starter
    Junior Member
    Join Date
    Jan 2000
    Location
    Christchurch, New Zealand
    Posts
    19

    Post

    Hi,

    the error reads ...

    3073 : Operation must use an updatable query

    ... what should I be looking ?

    The help didn't

    Cheers Dave
    Reply With Quote Reply With Quote
  2. Feb 20th, 2000, 07:35 PM #2
    VorTechS
    VorTechS is offline
    Lively Member
    Join Date
    Jan 1999
    Location
    Gloucester, UK
    Posts
    78

    Post

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

    Got an example?
    Reply With Quote Reply With Quote
  3. Feb 22nd, 2000, 05:05 AM #3
    Lil Dave
    Lil Dave is offline

    Thread Starter
    Junior Member
    Join Date
    Jan 2000
    Location
    Christchurch, New Zealand
    Posts
    19

    Post

    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
    Reply With Quote Reply With Quote
  4. Feb 22nd, 2000, 12:35 PM #4
    JohnAtWork
    JohnAtWork is offline
    Lively Member
    Join Date
    Jul 1999
    Posts
    78

    Post

    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.


    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width