In my vc++ application I am using Access as the database(connected using DAO). The database and tables are created during runtime.
I name the table depending upon the name the user enters. Now the problem is that if he enters a name with spaces, an errors occurs because of the SELECT sql
Say the name is : tara m
SELECT * FROM tara m
causes an error 'Syntax error in FROM clause'
But the table gets created with the correct name.
I tried putting the table name bet ' ', but it says "wrong formating in querry"
Would you be knowing the right way of doing this. Or I must ask the user to type the name without spaces?