Results 1 to 2 of 2

Thread: Invalid SQL statement

  1. Jul 30th, 2000, 10:09 AM #1
    Mafat
    Mafat is offline

    Thread Starter
    New Member
    Join Date
    Jul 2000
    Posts
    2

    Question

    I have a VB6 program which connects to an Access database using ADO.

    Sometimes when I try to open a Recordset object with one of the tables / queries in the database as a source, I receive the message: "Invalid SQL statement", although the table / query is in the database! When I then terminate the program and execute it again, I receive no errors!

    What can the reason for that be?

    Thanks!



    Reply With Quote Reply With Quote
  2. Jul 31st, 2000, 12:45 PM #2
    parksie
    parksie is offline
    Monday Morning Lunatic parksie's Avatar
    Join Date
    Mar 2000
    Location
    Mashin' on the motorway
    Posts
    8,169
    What query are you using? I normally just use db.OpenRecordSet("SELECT * FROM table").
    I refuse to tie my hands behind my back and hear somebody say "Bend Over, Boy, Because You Have It Coming To You".
    -- Linus Torvalds
    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