space

[lou sanderson]

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.

 

[Matt]

Try running a compact and repair on your database.

 

[lou sanderson]

Rodger.

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

-Lou

 

[Matt]

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?

 

[jahoobob]

Try increasing the size of you virtual memory. In XP it is Settings,
Control Panel, System, Advanced, Perfomance Settings, Advamnced,
Virtual Memory Change.. Make it a large enough number.
Other OS's will be similar, you'll just have to find it under System
for yours.

 

[lou sanderson]

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]

Try creating a Pass-Trough Query instead of using an Access query to a linked
table.

 

[lou sanderson]

Oy! Pass-Through queries are a real pain. . .

I'll try it though.

Thanks.
-Lou

 

[Vincent Johns]

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?

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.