Results 1 to 4 of 4

Thread: Syntax Error

  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: Syntax Error

    I get a message saying

    Run-Time Error '3131':
    Sytax Error in From clause.

    Error in code line : Set rscustomer = dbcustomer.OpenRecordset("select ID, Username, Rank, Greeting from DB-Access", dbOpenDynaset)

    Is this means my DB must be lower, because the lowest my goes is Access 97, and i think this one needs Access 95 can some one help me.

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    [DB-Access]

  3. #3
    Join Date
    Feb 2004
    Posts
    2
    Hmmm, that what it was, damn im newbie with this staff.

    Edited
    I changed the DB-ACESS TO DB, but i still get un Error

    Run-time '3343'
    Unreconized database format 'C:\path_name\data.mdb'.

    Is there anythign wrong with this code,

    Sub main()
    If Len(App.Path) <= 3 Then
    Set dbcustomer = OpenDatabase(App.Path & "Clan_DB.mdb")
    Else
    Set dbcustomer = OpenDatabase(App.Path & "\Clan_DB.mdb")
    End If
    Set frmmain = New frmtxtarr
    Load frmmain
    frmmain.Show
    End Sub
    Last edited by Killer[RTG]; 02-03-04 at 01:55.

  4. #4
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440

Posting Permissions

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