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

what is the limit to record size in access

P: n/a
I have one person who uses an access database for his billing info, and now
he is way up there, maybe 20 thousand records..

1. is there a limit to the size of an access database?

2. this is off topic.
this is an access database being used in vb6, is there vb code I could use
in vb6 app that will let them compact the database automatically?

thanks in advance
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Thu, 20 May 2004 12:50:18 GMT, "Danny" <da********@hotmail.com>
wrote:

The absolute max size of an Access db is 1 GB in older versions, 2 GB
in newer (Access 2000 and up). The practical size depends on your
database design and coding skills. If they are very good, a million
rows is not a problem.

Re 2: Look up CompactDatabase in the help file.

-Tom.
I have one person who uses an access database for his billing info, and now
he is way up there, maybe 20 thousand records..

1. is there a limit to the size of an access database?

2. this is off topic.
this is an access database being used in vb6, is there vb code I could use
in vb6 app that will let them compact the database automatically?

thanks in advance


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.