Wildcard in Select Problem using TUniQuery MSAccess Provider

johnbitner · Post by **johnbitner** » Mon 14 Sep 2009 19:29

SELECT Users.*, UserSecurity.* FROM Users INNER JOIN UserSecurity ON Users.ID = UserSecurity.ID;

This query does not work on UniQuery connected to MSAccess MDB file database. I does work inside the MSAccess program using the sql query editor. When I call myquery.execute there is no error message but the query never completes and locks my app. also tried in try/except/end to trap error but it does not error out. Just locks program and i have to reset to get out of it.

I also tested this against MSSQL server with a database with the same schema as the MSAccess database and it works ok there with the server.

Seems to be an issue with uniDAC and the Access provider.

Was able to work around but wanted to report as other might have similar issues using uniDAC to create MSAccess/MSSQL applications.

If anyone knows why this does not work please reply.

Plash · Post by **Plash** » Tue 15 Sep 2009 08:54

We have fixed this problem. The fix will be included in the next build of UniDAC.

As a workaround set the ExtendedFieldsInfo specific option of Access provider to False.