Not Enough Space on Temp Disk - Error 3183 (1 Viewer)

nshah1013

Registered User.
Local time
Today, 08:32
Joined
Aug 24, 2005
Messages
13
Guys, I need some help really Urgent..I have report thats about 800 to 900 pages long which is created from a query. When i run the code to create the report, it keeps on giving me Not enough Space on Temporary Disk error.

I tried Different ways..I tried to Output it to my C drive which has about 50 Gb Space. I tried to do DoCmd.OpenReport "Flagstar_Report", acViewNormal and print it but still gives me the same error. I tried Repair and Compact the database. :(

Private Sub BtnCreateReport_Click()

DoCmd.OutputTo acOutputReport, "Flagstar_Report"

Exit_BtnCreateReport_Click:
Exit Sub

Any help will be greatly appritiated. I need to have this done before tomorrow.Please Please any suggetions are welcome.
 

RuralGuy

AWF VIP
Local time
Today, 09:32
Joined
Jul 2, 2005
Messages
13,826
Have you tried deleting everything in the temp folders?
C:\Windows\Temp\*.*
C:\documents and settings\username\local settings\Temp\*.*

This is just a guess shot at the problem. Wheww, 900 pages?
 

ghudson

Registered User.
Local time
Today, 11:32
Joined
Jun 8, 2002
Messages
6,195
You might have to increase the amount of your temp files settings. Windows XP has the settings hidden in the Control Panel under the Systems option in the Advanced option under the performance section.
 

nshah1013

Registered User.
Local time
Today, 08:32
Joined
Aug 24, 2005
Messages
13
My temp folder is empty.
About changing the size on Temp folder thorugh Control panel..I did as you say but in performance there is no temp folder
Drive C: paging File size 756 to 1512 mb
paging file size for selected drive
dirve: c
Space Available: 59951mb
Customer Size
Initial Size :756
Max size: 1512mb
Total Paging file size for all folder
minimam allowed 2MB
Recomanded 756mb
allocated 754 mb

Please help on what to do
 

RuralGuy

AWF VIP
Local time
Today, 09:32
Joined
Jul 2, 2005
Messages
13,826
navigate to %systemroot%\system32\spool\printers\ and delete any files there. By default, this is where the print spooler stores print files. I haven't been able to google up any additional information.
 

ghudson

Registered User.
Local time
Today, 11:32
Joined
Jun 8, 2002
Messages
6,195
Access does have a file size limit. I have to wonder if your report is causing Access to temporarily bloat beyond the file size limitation for your version of Access.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 11:32
Joined
Feb 19, 2002
Messages
42,987
It is most likely complaining about lack of space on the drive where the access .mdb lives rather than lack of space on your c: drive.
 

WindSailor

Registered User.
Local time
Today, 08:32
Joined
Oct 29, 2003
Messages
239
OK... Googling and taking a 'shotgun' approach...

I take it the query works fine, its just the reporting issue that has problems...

Make sure you haven't locked your virtual memory in your version of windows, let windows handle it automatically, check it and reallocate it if necessary.

fatal system errors in Access 2002

Recordset size issue?

-----------Edit-------------

Someone else suggested if the table / database is on SQL server to use a pass through query to minimize traffic, if that was the reason why you were recieving the error.
 
Last edited:

WindSailor

Registered User.
Local time
Today, 08:32
Joined
Oct 29, 2003
Messages
239
Found this in case you were wondering...

Limitations in a Query

Attribute - Maximum
Number of enforced relationships 32 per table minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships
Number of tables in a query - 32
Number of fields in a recordset - 255
Recordset size - 1 gigabyte
Sort limit - 255 characters in one or more fields
Number of levels of nested queries - 50
Number of characters in a cell in the query design grid - 1024
Number of characters for a parameter in a parameter query - 255
Number of ANDs in a WHERE or HAVING clause - 99
Number of characters in an SQL statement - Approximately 64,000

Limitations in a Form, Report

Attribute - Maximum
Number of characters in a label - 2048
Number of characters in a text box - 65,535
Form or report width - 22 in. (55.87 cm)
Section height - 22 in. (55.87 cm)
Height of all sections plus section headers (in Design View) - 200 in. (508 cm)
Number of levels of nested forms or reports

* 7 - Acc 2003
* 7 - Acc XP
* 3 - Acc 2000

Number of fields or expressions you can sort or group on in a report - 10
Number of headers and footers in a report 1 report header/footer; 1 page header/footer; 10 group headers/footers
Number of printed pages in a report - 65,536
Number of controls and sections you can add over the lifetime of the form or report - 754
Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .mdb and .adp) - 32,750
 

Users who are viewing this thread

Top Bottom