-
I am trying to delete a table form an Access database but I am getting a sntax error in my drop table statement. The problem is arising because the table's name is one of the user's names so therefore it has a space in it.
ex.
John Doe ---- where that is the person's name which also makes it their table's name. The space between the first name and last name is giving me the error, i think. I had this working before but the table names at that time were the user's ID numbers. Now that i switched to their names, it will not work. Any ideas on what i can do to fix this??
thanx alot!!
-
Well I think that what you may need to do is place brackets around the name if it contains a space; so your John Doe would be [John Doe]. I'm not sure if this is what you need to know but try it and see if it works.
-
Thank you Edward.
I placed brackets around the TableName and it is now functional. Thanks once again.
