Error in From Cluase

[Dubya007]

i have an error in this from clause, i'm not really sure why it is. but here is the code.

'****************************************************
'the form loads with a connection the Test Query in
'access
Private Sub Form_Load()
If sgrs.State = adStateClosed Then
    Debug.Print "sgrs is closed"
    sgrs.Open "SELECT * FROM Test", DBConn, adOpenDynamic, adLockOptimistic
    Call Display(0)
    sgrs.MoveFirst
Else
    Debug.Print "Sgrs is open"
    Call Display(0)
End If
If Trs.State = adStateClosed Then
    Debug.Print "trs is closed"
    Trs.Open "SELECT * FROM Check", DBConn, adOpenDynamic, adLockOptimistic
End If
End Sub

Trs and sgrs are both declared in the heading as global variables. i need to access both of the tables in order to get info from both of them. the tables are in Access97

[Ecniv]

Originally posted by Dubya007
i have an error in this from clause, i'm not really sure why it is. but here is the code.

'****************************************************
'the form loads with a connection the Test Query in
'access
Private Sub Form_Load()
If sgrs.State = adStateClosed Then
    Debug.Print "sgrs is closed"
    sgrs.Open "SELECT * FROM Test", DBConn, adOpenDynamic, adLockOptimistic[color=red], adCmdText[/color]
    Call Display(0)
    sgrs.MoveFirst
Else
    Debug.Print "Sgrs is open"
    Call Display(0)
End If
If Trs.State = adStateClosed Then
    Debug.Print "trs is closed"
    Trs.Open "SELECT * FROM Check", DBConn, adOpenDynamic, adLockOptimistic[color=red], adCmdText[/color]
End If
End Sub

Trs and sgrs are both declared in the heading as global variables. i need to access both of the tables in order to get info from both of them. the tables are in Access97

Not sure.
Whats the exact error?
Add in the parts in red, if the objects are recordsets.


Vince

[Dubya007]

i get an error that says: "Syntax error in FROM clause"
then the debugger highlights the from clause where this statement is:

Trs.Open "SELECT * FROM Check", DBConn, adOpenDynamic, adLockOptimistic

yes they are supposed to be recordsets but can i ask what the parts in red are? i am new to all of this. but thanx for the help

[brucevde]

Check may be a reserved/key word. Surround it with square brackets or change the table name.

Select * From [Check]