Hi, Kirk.
I'm getting a run time error 3183 - Not enough space on temporary disk when
running an append query which is linked to a back end Oracle database.
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 very common reason for using excessive 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 far 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 as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
