SQL Server 2005 Express and MS Access

[eimroda]

i have worked with sql express for more than a month now, and actually we use it in our latest POS project as backend (with 4 terminals) and its really doing fine. in our our old projects with a sql server 2000 backend, we use it (express) as our local storage, replacing access.

as of now, we see access to be out of our backyard. with our experience, as access user then shifted to sql exress, i am wondering if M$ people is going nuts. they're killing MS Access, aren't they?

[d3gerald]

well theyre not actually killing access. its just that it is said that an access database has a limitation on the maximum records it can contain. access is mainly used in school for teaching the principles of relationships, database design and the like. yet for large scale applications which require tremendous speed of broadcast, it is advisable to use a proper server or shall we say for example sql server or mysql as your back end.

[eimroda]

sql express is FREE, it can handle up to 4gb of data, so im thinking, with the architecture of SQL server in it, it could replace access. if im the owner of the school, i'm going to use express, if im a developer, i'll select express over access. so i am seeing express to really replace access.

[si_the_geek]

Both products have their advantages and disadvantages.

Access for example has the built-in forms etc, which allows you to make a self-contained database & application. It is also simpler to understand for newcomers than SQL Server Express (or MSDE before it).


MSDE didn't eliminate Access, and I would be surprised if Express does. It is obviously a great product for people like us who understand databases (and want to distribute data along with programs), but for DB beginners Access is a useful learning aid.

Many of us have been recommending MSDE (to developers) as an alternative to Access for years, and will presumably be doing the same with Express. Access will not suddenly dissapear tho, but if MS push SQL Server Express enough then I guess they will ditch Access at some point.

[eimroda]

Many of us have been recommending MSDE (to developers) as an alternative to Access for years, and will presumably be doing the same with Express.

SPREAD THE WORD!!!!!

[RobDog888]

Moved

Having more then one db too choose from to do the job is better then having only one. You use what is best for your type of app so its not killing Access only enhancing their database product line.