Advertisement

10.24.2007 at 09:38AM PDT, ID: 22915139
[x]
Attachment Details

Not enough space on temporary disk - New problem - Old program

Asked by wmckinney in Microsoft Access Database, Visual Basic Programming, Access Coding/Macros

Tags: , ,

I have a Microsoft Access program that I run each quarter. It ran in June just fine and now it gets the above referenced message. I have confirmed that the Jet*.tmp file has reached the 2,092,996 size and that the actual database files are all less than 1 GB. I'm concerned that some "update" has come across that has changed the operating characteristics of Access but, aside from the cause, is there some technique that I can include in the program to cause the Jet*.tmp to reset? I am compacting the secondary MDB's during the process but have no idea how to get the tmp files to reset. Based on the number of EE questions that reference this problem I am guessing that this has a myriad of solutions but I have tried all that make sense. I have already increased all the PAGEFILE's.Start Free Trial
 
Keywords: Not enough space on temporary disk …
Title
1 Create a temporary table
2 Can't synchronize access database
3 Compact and Repair
4 Temporary Disk
5 Compact not compacting
6 Compact a table-attached MDB
 
Loading Advertisement...
 
[+][-]10.24.2007 at 12:29PM PDT, ID: 20142150

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.24.2007 at 01:00PM PDT, ID: 20142398

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.24.2007 at 01:55PM PDT, ID: 20142835

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.24.2007 at 02:44PM PDT, ID: 20143140

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.24.2007 at 02:49PM PDT, ID: 20143180

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Access Database, Visual Basic Programming, Access Coding/Macros
Tags: space, enough, access
Sign Up Now!
Solution Provided By: puppydogbuddy
Participating Experts: 2
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628