space

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm getting an error when I run a query that says "Not enough space on
temporary disk."

Admittedly, I am using a large dataset (~1.3 gigs currently).

Anyone know a way to increase the available temporary disk space or
otherwise work around such an error?

Thanks,
Lou Sanderson.
 
Rodger.

I have the "compact/repair on close" option engaged, so the db is regularly
compacted. . .

-Lou
 
Access can only support about 2 GB of data. Because you are running a query
on such a larger set of data (1.3 gigs), you are probably exceeding the limit
in Access. There is no way to increase the max size of an Access Database.
Where is your data – in separate Access database?
 
I have tried to run the query several times with the data in different
locations.

1) Data stored in Oracle, linked into my access file
2) Data stored in a seperate access file, linked into the origional access
file
3) imported into the db.

same error every time. . .
 
Matt said:
Access can only support about 2 GB of data. Because you are running a query
on such a larger set of data (1.3 gigs), you are probably exceeding the limit
in Access. There is no way to increase the max size of an Access Database.
Where is your data – in separate Access database?
Click to expand...

Sorry, this comment won't help answer your question, but FYI, here is
what Access 2000 Help says:

"Maximum Microsoft Access database (.mdb) file size: 2 gigabytes.
However, because your database can include linked tables in other files,
its total size is limited only by available storage capacity."

Sometimes Queries fail because they generate lots of intermediate
results -- I've taken care of that when necessary by simlifying the
Queries, sometimes writing temporary results to a new, temporary Table
(though I dislike having to do that).

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Back
Top