[AccessD] ACCESS2003 Function is not Expression

Hey All

 

I have run into another interesting problem. On the client's machine when I
try to populate a ListBox from a query referencing a table in the backend
MDB called "KeyWord" the ListBox comes up empty. If I set it to a recordset
I can easily manipulate it using code. What I did was rename the table to
"KeyWordTbl" and all my queries work fine. I know some of you will be saying
"always designate a table with "Tbl"". But this was a revision of a many
years old application that has been running fine with no problems. I follow
"If it is not broke don't fix it".  As I mentioned before the only
difference between my machine and the client's is he has ACCESS2010
installed. What I do not understand is why the queries for the table
"KeyWord" work fine on my machine and on a friend's machine who has
ACCESS2007 installed. I figure the client's machine has a reserved word
"KeyWord" and ours don't. This whole thing has been baffling. I know some of
the gurus will be saying "Hey you twit the simple answer is.........".
Anyway got to finish revising my code and get the application out to the
client.  Oh to be an Oscar Meyer wienie.

 

Thanks

Tony Septav

Nanaimo, BC

Canada