Calculating data size limits

[Digger442]

I am trying to project how long it will take to reach the 2GB Access limit in a specific project.

My client downloads approx 250,000 records on a monthly basis. I've been provided w/ a sample Excel spreadsheet. I filled a spreadsheet w/ the max number of rows (65536 rows w/ 10 columns of data), and imported that into a new table in a new .mdb file. I copied the table 4 times, so I now have 4 tables of 65536 records each. Compacted before closing. Size was about 52MB. Assuming consistency, I calculate that the size limit would be reached in about 36 months.

262,000 records = 52 MB. 52 MB a month x 36 months = 1,872,000 MB.

Does my projection appear sound?

Thanks!

 

[Moniker]

That calculation is fine. However, why not just make a monthly or yearly DB, like this:

YourDBName_2006-01.mdb
YourDBName_2006-02.mdb
.
.
.
YourDBName_2006-xx.mdb

Then just link the data in as needed using links in a "Master" DB. If you follow a standard naming style, you could automate that structure further by using something like this:

LinkTableFromDB = YoureDBName_[YEAR]_[MONTH].mdb\[table_name]

And finally, since each table in each monthly DB would presumably have the same structure, you could pull multiple months using a UNION SELECT.

Using a structure like this one means you won't hit the 2GB limit.

~Moniker

 

[Digger442]

Thanks for the reply. Greatly appreciated.

Your suggestions are definitely worth considering.