Forums before death by AOL, social media and spammers... "We can't have nice things"
| comp.lang.visual.basic | MS Visual Basic discussions, NOT dot-net | 10,840 messages |
[ << oldest | < older | list | newer > | newest >> ]
| Message 8,989 of 10,840 |
| Veign to Chriz Yuen |
| Re: ADO-Access Syntax error |
| 20 Nov 04 04:49:45 |
From: me@home.com
User is a reserved word.
Try
Adodc1.Recordset.Source = "select * from [user]"
--
Chris Hanscom - Microsoft MVP (VB)
http://www.veign.com
--
"Chriz Yuen" wrote in message
news:418edeb1$1_2@news.tm.net.my...
> 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
>
>
--- SoupGate-Win32 v1.05
* Origin: you cannot sedate... all the things you hate (1:229/2)
|
[ << oldest | < older | list | newer > | newest >> ]
(c) 1994, bbs@darkrealms.ca
