By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,067 Members | 1,818 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,067 IT Pros & Developers. It's quick & easy.

Maximum rows in an access table

100+
P: 116
Does anyone know if there is a maximum number of rows you can have in on access table? I've been trying to run and append but it errors out every time it tries to append the rows from the query it just finished. I'm wondering if its failing because the append is around 23,000,000 rows. any ideas or suggestions?

Thanks,
Eric
May 8 '07 #1
Share this Question
Share on Google+
6 Replies


P: 1
A MS Access database can not be larger than 2GB. I am assuming that your 23 million records causes the mdb to exceed this size.
May 8 '07 #2

JConsulting
Expert 100+
P: 603
You MIGHT want to consider moving that data into a Database like SQL or Oracle and linking to it. I hesitate to ask...what in the world are you storing? Seems a recordset that large would be entirely too cumbersome to be of any value.
J
May 8 '07 #3

100+
P: 116
Thanks for the help. I think you right about needing to link to the tables in oracle. To ease your curiosity...the table consist of all the table names and column names in the Peoplesoft ERP tables. My program is and access program to create sourcing documents used in the creatation of a data warehouse. Its a daunting task considering i'm having to teach myself access as i go.

In short i'm going to be bald from all the hair i'm pulling out =

Eric
May 8 '07 #4

JConsulting
Expert 100+
P: 603
Thanks for the help. I think you right about needing to link to the tables in oracle. To ease your curiosity...the table consist of all the table names and column names in the Peoplesoft ERP tables. My program is and access program to create sourcing documents used in the creatation of a data warehouse. Its a daunting task considering i'm having to teach myself access as i go.

In short i'm going to be bald from all the hair i'm pulling out =

Eric
Sounds like you have your hands full.

You can also consider categorizing your entries into separate DB backends. Would take some effort but you can still use your front end and link to them. You bring that data together in queries anyway right?
Just a thought.

By the way...is the DB 2G?
J
May 8 '07 #5

100+
P: 116
I think breaking them into seperate DB's might be the way to go but like you said that would mean extra work so i'm hoping i can get away with linking the table.

Eric
May 8 '07 #6

ADezii
Expert 5K+
P: 8,627
Does anyone know if there is a maximum number of rows you can have in on access table? I've been trying to run and append but it errors out every time it tries to append the rows from the query it just finished. I'm wondering if its failing because the append is around 23,000,000 rows. any ideas or suggestions?

Thanks,
Eric
With 23,000,000 Rows, you should not be using Access. You should go with the Big Boys, Basically SQL Server or Oracle. Of course, there will literally be a steep price to pay!
May 8 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.