C
Chris E.
How do I rectify this? Would increasing the size of my pagefile work?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
6
'69 Camaro
Hi, Chris.
Perhaps. Jet 4.0 can only handle up to 2 GB of data at a time. It's
possible
that the space needed to work with the records exceeds the amount Jet can
handle and place in the temporary file.
Make sure of the following: the amount of RAM and the pagefile size added
together are big enough to handle the whole transaction, enough disk space
quota is available in the system's Temp directory (you may want to clean out
the Temp directory before beginning the session so you have the entire quota
available), and increasing the MaxLocksPerFile value in the Windows Registry.
For this last item, please see the following Web page:
http://support.microsoft.com/?id=286153
One common reason for using so much space in the temp file is a query that
uses a Cartesian join instead of ANSI SQL-92 syntax for a table join. For
example, it's valid in Oracle SQL to use the following:
SELECT *
FROM EMPS, DEPT
WHERE EMPS.DEPTNO = DEPT.DEPTNO;
and Oracle will return only the matching records. However, this same syntax
in a query will result in a Cartesian join in Access, whereas:
SELECT *
FROM EMPS INNER JOIN DEPT ON EMPS.DEPTNO = DEPT.DEPTNO;
uses ANSI SQL-92 syntax and will return only the matching records -- which
can be _immensely_ fewer records -- depending upon how many records are in
each table. Check to ensure that the database application isn't needlessly
trying to handle way too many records than it should.
If none of these suggestions helps, then you may need to cut down on the
number of records that Jet handles at one time to avoid the 2 GB ceiling.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts, so that all
may benefit by filtering on "Answered questions" and quickly finding the
right answers to similar questions. Remember that the best answers are often
given to those who have a history of rewarding the contributors who have
taken the time to answer questions correctly.
How do I rectify this? Would increasing the size of my pagefile work?
Perhaps. Jet 4.0 can only handle up to 2 GB of data at a time. It's
possible
that the space needed to work with the records exceeds the amount Jet can
handle and place in the temporary file.
Make sure of the following: the amount of RAM and the pagefile size added
together are big enough to handle the whole transaction, enough disk space
quota is available in the system's Temp directory (you may want to clean out
the Temp directory before beginning the session so you have the entire quota
available), and increasing the MaxLocksPerFile value in the Windows Registry.
For this last item, please see the following Web page:
http://support.microsoft.com/?id=286153
One common reason for using so much space in the temp file is a query that
uses a Cartesian join instead of ANSI SQL-92 syntax for a table join. For
example, it's valid in Oracle SQL to use the following:
SELECT *
FROM EMPS, DEPT
WHERE EMPS.DEPTNO = DEPT.DEPTNO;
and Oracle will return only the matching records. However, this same syntax
in a query will result in a Cartesian join in Access, whereas:
SELECT *
FROM EMPS INNER JOIN DEPT ON EMPS.DEPTNO = DEPT.DEPTNO;
uses ANSI SQL-92 syntax and will return only the matching records -- which
can be _immensely_ fewer records -- depending upon how many records are in
each table. Check to ensure that the database application isn't needlessly
trying to handle way too many records than it should.
If none of these suggestions helps, then you may need to cut down on the
number of records that Jet handles at one time to avoid the 2 GB ceiling.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts, so that all
may benefit by filtering on "Answered questions" and quickly finding the
right answers to similar questions. Remember that the best answers are often
given to those who have a history of rewarding the contributors who have
taken the time to answer questions correctly.