Access /SQL Server Express

[acss]

I have already created a working Access DB (2003) with a FE/BE design
currently being utilized over the corporate network using active directory.
Is there a benefit in upgrading to SQL Server Express 2005 and can it be done
by using the FE of Access?

 

[Chris O'C via AccessMonster.com]

The benefits of upgrading to SQL Server Express are that you have a more
reliable db, security, capability of more connections and an easy upgrade
path to SQL Server if 4GB isn't enough to hold your data. It might be faster
than Access, but usually not - unless the developer who upgrades to SQL
Server is more skilled than the original Access developer. That's rare.

You can use the same Access front end for SQL Server Express as you use for a
Jet back end. Some of the queries may need to be replaced with sql pass
through queries for better performance or to bypass incompatiblilites with
Jet.

Chris
Microsoft MVP