ADO Syntax error FROM Clause

[sheep]

I followed instructions in setting up an ADO data control (using VB6 Enterprise edition) but when trying to select my datafield for my textbox I encountered an error “Syntax error in FROM clause”. I checked the datasource of my textbox and it was set to Adodc1, data provider was set to MS Jet 4.0 OLE DB, selected my database (Access 2000 format), etc. Did I forget anything else?

P.S. Guys I’m new in VB programming. Actually, I really don’t have any programming experience at all. If possible, please give me some tips where to focus my study on VB6 in preparation for VB programming in the real world. Do you have any resources in the net or any book where I find some real world samples, exercises/practice sets to improve my logic? Lastly, do you have any idea the salary range for entry-level and average experienced programmers in your city and do you think it is still possible that I can be marketable either as an entry-level or average experienced VB programmer at age 37 (I’m turning 34 this March)?

Thanks.

[Zaf Khan]

Post your line of code and maybe someone may spot an error.

DocZaf
{;->

[sheep]

There's no code yet. I only created a ADO Data Control and text box. I just want to see at least the contents of one field of my database in my textbox using the ADO Data Control.

[Zaf Khan]

oh okay then,

:-)

DocZaf
{:->

[substring]

A word of advice... if you want to learn programming VB in the "real" world, use "real" databases like SQL Server or Oracle.