User is a reserved word.
Try
Adodc1.Recordset.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.Recordset.Close
> Adodc1.Recordset.Source = "select * from user"
> Adodc1.Recordset.Open
> Set DataGrid1.DataSource = Adodc1
> DataGrid1.ReBind
> 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]
