Article ID: 245343 - View products that this article applies to.
This article was previously published under Q245343
This article has been archived. It is offered "as is" and will no longer be updated.
In Access the asterisk(*) is the normal wildcard character. However, in Visual Basic with MDAC 2.1 SP1 (version 18.104.22.16811.11(GA)) installed, when calling an Access query using this wildcard character through ADO and the Access ODBC driver, it fails to return any records.
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. This bug is corrected in MDAC 2.1 SP2 (22.214.171.12402.3 (GA)), which can be downloaded from here:
Steps to Reproduce Behavior
Create the Access QueryIn Access 97 or Access 2000, create a query, Query1, with the following SQL statement in the Nwind.mdb or NorthWind.mdb database:
This should return all of the customer records (4 in all) with a Customer ID that starts with "A".
Visual Basic Test Application
Article ID: 245343 - Last Review: February 28, 2014 - Revision: 2.3
Contact us for more help
Connect with Answer Desk for expert help.