what is the max number of records for access 2000&2003 table?

[Guest]

what is the max number of records for access 2000&2003 table?
we have encountered table corruption above 15000 records in access 2000.

 

[Guest]

Even in 2000, there is no limit to the number of records. The limitation is
in the size of the mdb file. It can't be > 2Gig.
I have tables in my current application with over 30, 000 records with no
problem. You corruption is being caused by something else.

 

[John Spencer]

Klatuu you are a piker. ;-)

I have tables that have many more records than that.

In the db I am working on right now, one table has 2,281,075 records in it.

Randy
If you are getting corruption in your tables, you need to look elsewhere. I
suggest you take a look at Tony Toews site
http://www.granite.ab.ca/access/corruption/causes.htm
for information on possible causes.

Try Allen Browne's article on Recovering from Corruption at:
http://allenbrowne.com/ser-47.html

Also you take a look at Tony Toews site
http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Guest]

Is this one of those "My database is bigger than your database" things?

So, I have 333 tables in my database

Your move

 

[Brendan Reynolds]

Public Sub MoreTablesThanKlatuu()

Dim lngLoop As Long
For lngLoop = 1 To 334
CurrentDb.Execute "CREATE TABLE Table" & CStr(lngLoop) & " (TestText
char)"
Next lngLoop
MsgBox "Sorry, couldn't resist it!"

End Sub

 

[John Spencer]

I surrender to you both.

I do want to ask Klatuu if he has a database to track his database tables.
So do you?

 

[Guest]

Actually, I inherited a mess. I have a hard time not renaming it to
TrashHeap.mdb.
My predecessor is only marginally competent. To make matters worse, my bean
counter boss doesn't know it.

The true idiocy is that since I have been cleaning things up, she is
concerned because we keep getting all these errors in the data. "We didn't
have these problems when A... was doing it. What she doesn't understand is
that the data has been a mess for three years and nobody knew becaue there
was no editing.

The month end process was Import an unedited inaccurate Excel file, populate
an bunch of tables, export it back to Excel so the bean counters can
manipulate and destroy it even further ("we can't do it as fast in Access, we
know Excel"), then import the manual adjustments and populate some more
tables.

The reason there are so many tables....There wass a different table for
every report

 

[Guest]

I have 8 million records in one table and just over 1 million in another
table. Had a user create a cartisian join between them once.

Oh! It's a rather small Oracle database. ;-) Largest Access database I've
worked with had a half million records in one table.