bretts
Registered User.
- Local time
- Today, 18:27
- Joined
- Feb 25, 2005
- Messages
- 13
All,
I apologise if this has already been covered in another thread, but I searched and searched and still didn't find the answer.
We are converting our databases from Access 97 to Access 2003 and we have found that if we have used the "Like" in the criteria in a query in 97, 2003 does not like it.
For example:
Access 97 : Like "|[Temp_Holding_Tbl].[Cust_No]|*"
Access 03 : Like [Temp_Holding_Tbl].[Cust_No] & "*"
Is there a way of searching the SQL inside every query in access for this string?
At the moment we have to open each query to check it, which is rubbish.
Any help will be much appreciated
Brett
I apologise if this has already been covered in another thread, but I searched and searched and still didn't find the answer.
We are converting our databases from Access 97 to Access 2003 and we have found that if we have used the "Like" in the criteria in a query in 97, 2003 does not like it.
For example:
Access 97 : Like "|[Temp_Holding_Tbl].[Cust_No]|*"
Access 03 : Like [Temp_Holding_Tbl].[Cust_No] & "*"
Is there a way of searching the SQL inside every query in access for this string?
At the moment we have to open each query to check it, which is rubbish.
Any help will be much appreciated
Brett
