Optimum file size

[Guest]

Does Access have a maximum size limit?

I have a database that will approach 200mb. Will this affect Access'
performance?

 

[Douglas J. Steele]

The maximum size is 2 Gb. 200 Mb shouldn't be an issue.

 

[Jeff Boyce]

In addition to the maximum file size (.mdb) Douglas points out, there are
other specifications you may want to consider.

* maximum possible row length in each table
* number of fields/columns in each table (?relational design vs.
"spreadsheet" design)
* use of db - data entry (how many users) vs. data lookup (again, how many
users)
* if database is split, speed of the LAN
* use of indexing
* "horsepower" of PC

These are a few other topics to look into.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Aaron Kempf]

I would reccomend using Access Data Projects if you're gonig to have this
much data

it is a much much simpler architecture

 

[Aaron Kempf]

additionally-- if you want to use MS Access across a WAN, Wireless, or VPN
you will be REQUIRED to use Access Data Projects

 

[missinglinq via AccessMonster.com]

Since you're new here you'd be well advised to ignore any posting by our
resident troll, Mein Kempf! His only response, no matter what question is
posted, is that you should be using Access Data Projects rather than mdb!