SQL server vs Access

  • Thread starter Thread starter Hong Luen via AccessMonster.com
  • Start date Start date
H

Hong Luen via AccessMonster.com

I've heard that having the backend database in SQL server is much better
than having the backend in Access, because database will often be corrupted
(in case the backend is in Access).
Is that true?

Another advantage is the size of database can be higher with SQL server.
Is that true?
 
Yes to both....

If your Access database is poorly designed, you have multiple users and/or
are on a network the is not stable, Access MDBs will be corrupted fairly
easily. On the other hand if they are well designed, and on a stable
network, as long as they are compacted and repaired regularly, they should
be very stable.

SQL Server is designed to be a high usage, multi-user DB engine that
basically maintains itself (you need to set up some basic maintenance
routines that run automatically on the server).

Access has a limit of 2Gb file size for the MDB whereas SQL doesn't.

Jim
 
Back
Top