F. Scott Barker's Microsoft® Access 2000 Power Programming

FACTORING FOR MIGRATION TO CLIENT/SERVER

You should consider a number of factors when deciding whether to migrate to client/server applications from the file-server world, such as the amount of data that you have, the number of people using the database, and security.

Amount of Data

A common misconception is that the size of the database is the only factor to consider in deciding whether to migrate to client/server. The size of the database does play a role, certainly, especially when you consider network traffic. Keep in mind that knowing your database will eventually grow to upward of 100MB doesn't necessarily mean you must move to client/server. However, as the complexity of your database increases, the size factor becomes more and more important. ...