Accepted Table Name

[maqmaq]

I have problem using SQL to retrieve data from a table if it's name consist of two word like "My employee", Visual basic will give error that table name "My" is not exist.
Any idea how to solve this error with out changing the table name to one word.

Appreciated

[J Staniforth]

Try using [My employee] when you refer to the table in SQL
e.g.

SELECT * FROM [My employee]

Also in VB code.

Cheers,
John.

[maqmaq]

Thank you, I tried it out and it worked excellent
Best Regards
Maq