Space in filename of DB

[betheball]

I know I have read that you should not use spaces in the names of the fields in a DB. What about in the name of the DB itself? For example: Local Employees.mdb as opposed to Local_Employees.mdb. Our office currently has such a DB and I am trying to convince the "owner" to change the name because I am going to be creating some ASP pages that will use the DB and don't want problems. Can someone tell me whether the space is OK and if not, why not?

 

[Pat Hartman]

I can't remember what I was trying to do but I couldn't get past a directory name that had a space in it. I NEVER use spaces in the names of ANY objects. But, that's just the programmer in me. I know that Windows still has trouble with embedded spaces under certain conditions so rather than run into them, I practice defensive programming techniques.

BTW, the network people finally agreed to rename the network directory for me so I could get past the problem Access was having with it.