Microsoft Access Performance Issues

[DrewJam71]

I would like to know what kind of performance to expect from Access 2003 in
terms of access speed etc as the size of the database increase. Is there a
maximum size for optimum performance?

Look forward to your help.

Thanks,

 

[John W. Vinson]

I would like to know what kind of performance to expect from Access 2003 in
terms of access speed etc as the size of the database increase. Is there a
maximum size for optimum performance?

Look forward to your help.

Thanks,

See
http://www.granite.ab.ca/access/performancefaq.htm

 

[DrewJam71]

Thanks John. I actually found out somewhere in Access Help that the maximum
capacity of the database is 2GB. The performance tips from the site were
quite useful though.

Thanks again.

 

[John W. Vinson]

Thanks John. I actually found out somewhere in Access Help that the maximum
capacity of the database is 2GB. The performance tips from the site were
quite useful though.

That's a hard limit in a .mdb or .accdb format database; if you're expecting a
larger database (in fact anything over 1.5GByte) you should certainly put the
data into SQL/Server or into some other client/server database. Access will
still make an excellent user interface to the data, though.

 

[DrewJam71]

This is solid advise. Really appreciate it. Thanks again John.