General discussion

Locked

Why Access vs. SQL?

By dc103034 ·
I have a customer who wants to "sell" their board on moving a MISSION CRITICAL application from ACCESS to SQL. I can't find any supporting WRITTEN documentation as to the benifits although I KNOW SQL is consideralby more robust than ACCESS

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Why Access vs. SQL?

by jeff In reply to Why Access vs. SQL?

MS has a White Paper that talks about that and VFP Data. When to use and so forth. I can't find it right now, but I know it there. Here are a few Good reasons. More secure. Larger files. Faster. More Concurrent users. Down sides include COST$$$$, Admin. If I find the link I'll get it to you.

Jeff

Collapse -

Why Access vs. SQL?

by jeff In reply to Why Access vs. SQL?

Found it. The data is a bit old but I think you can apply it.

http://support.microsoft.com/support/kb/articles/Q168/5/49.asp


Jeff

Collapse -

Why Access vs. SQL?

by dc103034 In reply to Why Access vs. SQL?

The question was auto-closed by TechRepublic

Collapse -

Why Access vs. SQL?

by Blaine Moore In reply to Why Access vs. SQL?

Access is not as secure and is really only appropriate for single-user, single-machine databases.

Collapse -

Why Access vs. SQL?

by dc103034 In reply to Why Access vs. SQL?

The question was auto-closed by TechRepublic

Collapse -

Why Access vs. SQL?

by McKayTech In reply to Why Access vs. SQL?

One source of information I use is the SQL Server page on the Microsoft Web site (www.microsoft.com/sql and click on Case Studies). Obviously, the studies are biased in that you aren't going to see cases where SQL failed to deliver what was expected, but from the case studies you can see some of the reasoning that lead other companies to choose SQL Server.

Access is a great product for desktop use, casual databases and prototyping but the primary reason it's not suitable for mission-critical production applications is it's lack of fault tolerance and inability to rollback a failed attempt to write to the database.

paul

Collapse -

Why Access vs. SQL?

by dc103034 In reply to Why Access vs. SQL?

The question was auto-closed by TechRepublic

Collapse -

Why Access vs. SQL?

by dc103034 In reply to Why Access vs. SQL?

This question was auto closed due to inactivity

Back to Desktop Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums