If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error on Select Query
I'm trying to do a select query that has 36 fields and 18
comparisons in the WHERE clause. When I run the query I get the message: "The Microsoft Jet Database Engine stopped the process because you and another user are attempting to change the same data at the same time." However, I'm not trying to change data, I'm doing a select query. However, if I delete 4 fields and 2 WHERE clauses from my query it runs OK. I'm I hitting some internal Microsoft SQL limitation? Perhaps max SQL size, or number of columns, or number of comparisons in a WHERE clause? Thanks, Leif |
#2
|
|||
|
|||
Error on Select Query
Hi,
You are limited to 255 fields, and around 2000 characters per record (total of all non-OLE and non-memo fields). Take a look at "Access specifications", in the help file, to know the limits of your version. Hoping it may help, Vanderghast, Access MVP "Leif" wrote in message ... I'm trying to do a select query that has 36 fields and 18 comparisons in the WHERE clause. When I run the query I get the message: "The Microsoft Jet Database Engine stopped the process because you and another user are attempting to change the same data at the same time." However, I'm not trying to change data, I'm doing a select query. However, if I delete 4 fields and 2 WHERE clauses from my query it runs OK. I'm I hitting some internal Microsoft SQL limitation? Perhaps max SQL size, or number of columns, or number of comparisons in a WHERE clause? Thanks, Leif |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Worksheets | Richard | General Discussion | 2 | July 8th, 2004 04:34 AM |
query to select dates from a text field | Dale Walker | Running & Setting Up Queries | 1 | June 10th, 2004 01:56 PM |
query to select one record using report name | Nasos | Running & Setting Up Queries | 5 | June 3rd, 2004 01:20 PM |
Select Query | Pago | Running & Setting Up Queries | 2 | May 28th, 2004 04:56 PM |
Parameter query - select from list possible? | George Avery | New Users | 2 | May 12th, 2004 03:55 PM |