Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    2

    Unanswered: Help needed with VB6 Access 2000 Query

    I get a run time error for the following line of code:

    'grsTitles is a global Recordset that has been defined and declared.

    grsTitles.Open "SELECT Titles.Title FROM Publishers INNER JOIN Titles ON (Publishers.PubID = ""3"") WHERE (((Publishers.Name)=""SAMS""))", gcnAP, adOpenStatic, adLockOptimistic, adCmdText

    Run-time error '-2147217900 (80040e14)

    Join expression not supported.


    What am I doing incorrectly?


    Thanks,

    MiniMe

  2. #2
    Join Date
    Sep 2002
    Posts
    2

    Correction to code

    grsTitles.Open "SELECT Titles.Title FROM Publishers INNER JOIN Titles ON (Publishers.PubID = 3) WHERE (((Publishers.Name)=""SAMS""))", gcnAP, adOpenStatic, adLockOptimistic, adCmdText


    NOTE: PubID is a number, not a character.

Posting Permissions

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