HomeActive Query BuilderQueries (Views) do not appear for Microsoft Jet 4.0 OLE DB Provider

Queries (Views) do not appear for Microsoft Jet 4.0 OLE DB Provider


When trying to connect to an Access 2003 database using "Microsoft Jet 4.0 OLE DB Provider", I do not see any Queries ('Views') and the Query String dialog rejects the SQL string from the Query if I try to plug it in directly. I can see these Queries ('Views') when I use "Microsoft OLE DB Provider for ODBC Drivers". I think the ODBC Driver has a 200000 recordset limit, and our users tend to pick the Jet Provider first and complain they cannot see their queries.

Is there a setting in the Jet Engine that shows/hides these views from Active Query Builder?
Greg D'Unger | email
September 6 2007, 11:16 AM
Dear Greg,

Please, tell me, what Edition (VCL, ActiveX or .NET) and what version (Free, Standard or Trial) you're evaluating now.

The point is that the Free version has no support of MS Access dialect, so you may experience various problems while working with this database. You may request the trial version at the download page: http://www.activequerybuilder.com/download.html
Sergey Smagin | email
3 hours, 42 mins since original post
Our developer for this is out of the office, but I see that we are using an ActiveX : ActiveQueryBuilderXControls.ocx v 1.7.1.9.
I assume this is Standard version, but how can I identify it? (Developer should be back tomorrow.)

Various MS Access dialects are listed, but none will show me the Queries.
Greg D'Unger | email
4 hours, 23 mins since original post
Dear Greg,

Unfortunately, I cannot reproduce this issue with the latest version of Active Query Builder (V1.7.9.48).

Please download the updated build, and check again.
Sergey Smagin | email
16 hours, 40 mins since original post
This topic is closed