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!!