Access 97 - out of temporary disk space
Posted on 1998-11-16
I have a '95 machine with 5 gigs of hard drive. I am trying to run a fairly complicated report. It involves taking fields from about 20 other tables. There's about 70 fields and the only way I could get them all into a report was to create a query to bring them in together. Then I could create a report based on that query. The problem is when I ran the query last time (I had just added one more field that I'd forgotten) it took about 45 minutes and then it said it had run out temporary disk space. Is this normal? One table does have 40,000 records and the others have numerous other sizes, but I thought this 5 gig machine could handle it. Any ideas?