Access Scalability

The last thing you want is a database platform that cannot cope with the performance demands placed on it, and yet it has no upgrade path. A dead-end disaster. Fortunately, Access can be upsized to SQL Server.

Microsoft Access --- SQL Server

What happens when I migrate to SQL Server?

You would use Access as the Client (Front-end) and SQL Server as the Server (Back-end). This means that SQL Server will hold your data.

What do I do with the existing Access database?

SQL Server has no attractive visual interface for the end user, so you will use Access for that. You will need to modify some parts of your Access database when you upsize. Microsoft provides a wizard to assist but some areas will require manual intervention. Designing your Access application at outset with migration in mind will reduce the number of changes required.

Is SQL Server as easy to maintain as Access?

No! SQL Server requires more maintenance than Access. And a different skill set. Be prepared! However, SQL Server 7.0 has much less maintenance demands than SQL Server 6.5.

Which Database Engine should I use?

1. Why Choose Access?

2. Performance: Is Access up to the job?

3. Scalability: What are the upgrade options?

4. Which Database Engine should I use? Jet (that comes with Access) or SQL Server?