Sunday, 15 May 2011

sql - Prevent Access from Changing Queries -


Microsoft Access wants to be helpful and changes my query when the underlying object (either form or query) is not present.

For example, if I had a query in which the following was done ... < / P>

  choose first name from individuals  

If the person table is not yet present, and I import the query, enter an "expr:" in front of FirstName Will give place so that it does not find this column The issuer.

Thanks

Change the query to specify aliases

  Select FirstName First name before the first name  

This MS Access I will stop making nicknames for you. I (fool I know, but it works.)


No comments:

Post a Comment