How can I access a query in a database when the query's name has a space in it? Doing it this way gives me errors:<BR> objRec.Open "My Query"<BR>Thanks!
I know this probably doesn't sound very helpful, but spaces in fieldnames, tablenames, queries, etc.. is very bad programming practice, I would suggest you change your naming convention.
Yes you're right but unfortunately, this particular database is absolutely huge with table links all over the place and I'm too lazy to go through the whole thing and change the query name where ever it's referenced...
Oh nevermind, I surrounded the thing with brackets and it worked. Thanks for nothing everybody!! woohoo!! Just kidding, I love you all.<BR>