Is there any limitation for queries in Access 2002?

  • Thread starter Thread starter efege2
  • Start date Start date
E

efege2

Hi everyone!

I'm trying to run a query in Access 2002. I had no problems with it i
previous versions of Access, but in Access 2002 it makes database t
crash.

I have:
Query 1: working all right
Query 2: gets fields from query 1 and divides two fields from query 1.
When I add this division, the query works all right once and the
database crashes with this message:
"Microsoft Access has encountered a problem and needs to close. We ar
sorry for the inconvenience."

Does anyone knowns if it is any kind of sintax diference for queries o
reports in Access2002? Or any kind of blocking information that affect
queries or reports?.

I would appreciate any help about this.

Gabriel
 
Queries in A2002 run on the same version of JET as they did in A2000, so
there should not be a difference.

If you do not have Service Pack 2 for Office 2002 and SP8 for JET 4, go to
support.microsoft.com and install these. Hopefully that will stablize your
installation.

If that does not solve the problem, you may need to paste the query
statements so we can see what you are aiming to do and perhaps suggest
alternatives. I have experienced some instabilities with stacked subqueries
in JET that I was not able to solve but was able to work around.
 
HI ALL!

I ran into a limitation in Access 2002, where the SQL command LIMIT is not
supported.

I'm developing a web-based report that retrieves a contiguous range of
records from an Access table, using JDBC in a JSP to access the table via
the Microsoft Access ODBC driver/datasource.

What alternative method can I use to accomplish this?

Any help/info would be much appreciated.

Best regards,

Tze-Chiu Lei
GC Webmaster
NOL Global Campus
APL, Ltd.

Allen Browne said:
Queries in A2002 run on the same version of JET as they did in A2000, so
there should not be a difference.

If you do not have Service Pack 2 for Office 2002 and SP8 for JET 4, go to
support.microsoft.com and install these. Hopefully that will stablize your
installation.

If that does not solve the problem, you may need to paste the query
statements so we can see what you are aiming to do and perhaps suggest
alternatives. I have experienced some instabilities with stacked subqueries
in JET that I was not able to solve but was able to work around.
Click to expand...
 
HI ALL!

I ran into a limitation in Access 2002, where the SQL command LIMIT is not
supported.

I'm developing a web-based report that retrieves a contiguous range of
records from an Access table, using JDBC in a JSP to access the table via
the Microsoft Access ODBC driver/datasource.

What alternative method can I use to accomplish this?
Click to expand...

Would the TOP VALUES property fill the bill?
 
Back
Top