Office 2003 - Acceess Not enough space on temporary disk

J

Jai_Friday

I have an ODBC report that has been created in Microsoft Access 2002
(10.6771.6825) Service Pack 3

This report Uses 5 Tables (Of which the size of data amounts to over 60
meg). The report works fine no problems at all.

When runnning the same Access database report on Microsoft Access 2003 it
errors with

[Microsoft] [ODBC Microsoft Accesss Driver] Not enough space on temporary disk

Is there any setting that can be applied via Access of Windows Registry to
allow the temp disk space to be expanded. It appears to be an issue with
Office 2003

Regards

Jai
 
D

Douglas J. Steele

How much free space do you have on your temporary disk? To find out where
your temporary disk is, open a DOS box and type set t. You should see at
least two environment variables defined: TEMP and TMP. Look where they
point.
 
J

Jai_Friday

Both point to c:\docum~1\User\LOCALS~1\temp

where can you enlarge the space (I would of though it was related the size
of hard disk either way)

Douglas J. Steele said:
How much free space do you have on your temporary disk? To find out where
your temporary disk is, open a DOS box and type set t. You should see at
least two environment variables defined: TEMP and TMP. Look where they
point.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Jai_Friday said:
I have an ODBC report that has been created in Microsoft Access 2002
(10.6771.6825) Service Pack 3

This report Uses 5 Tables (Of which the size of data amounts to over 60
meg). The report works fine no problems at all.

When runnning the same Access database report on Microsoft Access 2003 it
errors with

[Microsoft] [ODBC Microsoft Accesss Driver] Not enough space on temporary
disk

Is there any setting that can be applied via Access of Windows Registry to
allow the temp disk space to be expanded. It appears to be an issue with
Office 2003

Regards

Jai
 
D

Douglas J. Steele

It is related to the size of the hard drive. Many people partition their
hard drive partitioned, and forget to point the TEMP (and TMP) variables to
point to the largest drive.

How large is your back-end?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Jai_Friday said:
Both point to c:\docum~1\User\LOCALS~1\temp

where can you enlarge the space (I would of though it was related the size
of hard disk either way)

Douglas J. Steele said:
How much free space do you have on your temporary disk? To find out where
your temporary disk is, open a DOS box and type set t. You should see at
least two environment variables defined: TEMP and TMP. Look where they
point.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Jai_Friday said:
I have an ODBC report that has been created in Microsoft Access 2002
(10.6771.6825) Service Pack 3

This report Uses 5 Tables (Of which the size of data amounts to over 60
meg). The report works fine no problems at all.

When runnning the same Access database report on Microsoft Access 2003
it
errors with

[Microsoft] [ODBC Microsoft Accesss Driver] Not enough space on
temporary
disk

Is there any setting that can be applied via Access of Windows Registry
to
allow the temp disk space to be expanded. It appears to be an issue
with
Office 2003

Regards

Jai
 
J

Jai_Friday

The Hard disk is a 200gig IDE unpartitioned.....

However the problem to arise with a mapped network drive the report was
running from when I got the inital problem, I then move the access database
local to the machine and still the same problem (That even when I did a
compress/repair on the database)

Douglas J. Steele said:
It is related to the size of the hard drive. Many people partition their
hard drive partitioned, and forget to point the TEMP (and TMP) variables to
point to the largest drive.

How large is your back-end?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Jai_Friday said:
Both point to c:\docum~1\User\LOCALS~1\temp

where can you enlarge the space (I would of though it was related the size
of hard disk either way)

Douglas J. Steele said:
How much free space do you have on your temporary disk? To find out where
your temporary disk is, open a DOS box and type set t. You should see at
least two environment variables defined: TEMP and TMP. Look where they
point.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have an ODBC report that has been created in Microsoft Access 2002
(10.6771.6825) Service Pack 3

This report Uses 5 Tables (Of which the size of data amounts to over 60
meg). The report works fine no problems at all.

When runnning the same Access database report on Microsoft Access 2003
it
errors with

[Microsoft] [ODBC Microsoft Accesss Driver] Not enough space on
temporary
disk

Is there any setting that can be applied via Access of Windows Registry
to
allow the temp disk space to be expanded. It appears to be an issue
with
Office 2003

Regards

Jai
 
D

Douglas J. Steele

It doesn't matter where the MDB file resides: you're running it on your hard
drive. That's why we always recommend that you split your application into a
front-end (containing the queries, forms, reports, macros and modules),
linked to a back-end (containing the tables and relationships). Only the
back-end should be on the server: each user should have his/her own copy of
the front-end, ideally on his/her hard drive. (Having the front-end on your
hard drive will reduce network traffic.)

Assuming you've got plenty of space left on your hard drive (I'd say at
least 2 or 3 times the size of the back-end MDB file), and that your
back-end MDB file isn't close to the size limit (2 Gb), I'm afraid I have no
suggestions.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Jai_Friday said:
The Hard disk is a 200gig IDE unpartitioned.....

However the problem to arise with a mapped network drive the report was
running from when I got the inital problem, I then move the access
database
local to the machine and still the same problem (That even when I did a
compress/repair on the database)

Douglas J. Steele said:
It is related to the size of the hard drive. Many people partition their
hard drive partitioned, and forget to point the TEMP (and TMP) variables
to
point to the largest drive.

How large is your back-end?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Jai_Friday said:
Both point to c:\docum~1\User\LOCALS~1\temp

where can you enlarge the space (I would of though it was related the
size
of hard disk either way)

:

How much free space do you have on your temporary disk? To find out
where
your temporary disk is, open a DOS box and type set t. You should see
at
least two environment variables defined: TEMP and TMP. Look where they
point.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have an ODBC report that has been created in Microsoft Access 2002
(10.6771.6825) Service Pack 3

This report Uses 5 Tables (Of which the size of data amounts to over
60
meg). The report works fine no problems at all.

When runnning the same Access database report on Microsoft Access
2003
it
errors with

[Microsoft] [ODBC Microsoft Accesss Driver] Not enough space on
temporary
disk

Is there any setting that can be applied via Access of Windows
Registry
to
allow the temp disk space to be expanded. It appears to be an issue
with
Office 2003

Regards

Jai
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top