Optimum file size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does Access have a maximum size limit?

I have a database that will approach 200mb. Will this affect Access'
performance?
 
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
 
I would reccomend using Access Data Projects if you're gonig to have this
much data

it is a much much simpler architecture
 
additionally-- if you want to use MS Access across a WAN, Wireless, or VPN
you will be REQUIRED to use Access Data Projects
 
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!
 
Back
Top