ADO-Access Syntax error

[Chriz Yuen]

Private Sub Form_Load()
Adodc1.Recordse t.Close
Adodc1.Recordse t.Source = "select * from user"
Adodc1.Recordse t.Open
Set DataGrid1.DataS ource = Adodc1
DataGrid1.ReBin d
End Sub

When i run the program it show me msgbox
Run-time error '-2147217900 (8004Je14)':
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.

Thanks for help
Chriz

[Veign]

Re: ADO-Access Syntax error

User is a reserved word.

Try
Adodc1.Recordse t.Source = "select * from [user]"

--
Chris Hanscom - Microsoft MVP (VB)

http://www.veign.com

--

"Chriz Yuen" <chrizyuen@unix .cx> wrote in message
news:418edeb1$1 _2@news.tm.net. my...[color=blue]
> Private Sub Form_Load()
> Adodc1.Recordse t.Close
> Adodc1.Recordse t.Source = "select * from user"
> Adodc1.Recordse t.Open
> Set DataGrid1.DataS ource = Adodc1
> DataGrid1.ReBin d
> End Sub
>
> When i run the program it show me msgbox
> Run-time error '-2147217900 (8004Je14)':
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
>
> Thanks for help
> Chriz
>
>[/color]