Processing Limits Enquiry

A

Adrian

Hi,

I have 8 tables, each containing 1920 records. I am doing a "join" of all
the tables ... i.e. 1920 ^ 8 records = 184,675,732,219,861,401,600,000,000
records..

Is it ok ? What is the maximum limit on the no. of records in MS Access ?

Thanks..
 
B

Brendan Reynolds

I'm sitting here waiting for the usual horrible Dublin traffic grid-lock to
recede enough so that I can go home, so what the heck, I'll test it ...

Public Sub AddRecords()

Dim lngLoop As Long

For lngLoop = 1 To 1920
CurrentDb.Execute "INSERT INTO tblTest1(TestLong) VALUES(" & lngLoop
& ")", dbFailOnError
Debug.Print lngLoop
Next lngLoop

End Sub

Then I copy the table and paste it 7 times, then write the query ...

SELECT
FROM tblTest1, tblTest2, tblTest3, tblTest4, tblTest5, tblTest6, tblTest7,
tblTest8;

Right, here goes, if I'm never heard from again, you'll know that the PC
blew up when I ran this, OK ...

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
B

Brendan Reynolds

Well, I forgot to add any output fields to that query, didn't I? But after
adding them, the query eventually failed with a 'not enough temporary disk
space' error. There's 34.7 GB free disk space on this PC. I'm not sure
exactly how Windows allocates temporary space, but my feeling is that this
query just isn't a practical proposition. At the very best, you're going to
need some monster hardware, be prepared to leave it running over night, and
there's still no guarantee that it will ever complete.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
B

Brendan Reynolds

Guess our posts must have crossed each other? Do you see my post describing
the result now?

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Top