SQL SERVER AND MICROSOFT ACCESS comparison

[Pioneer]

hi,
can access db store images? for sql server, I sure know that.

what all are plus points for sql server against access db?

TIA

 

[Göran Andersson]

hi,
can access db store images? for sql server, I sure know that.

Yes. However an Access database is limited to 4 GB so you can't have a
lot of images.

what all are plus points for sql server against access db?

More concurrent connections (Access drivers are limited to 64).

You can connect to SQL Server from a different computer. Access can only
be used from the same computer.

Being a real database server SQL Server has a lot of features, like:
- Stored procedures and user defined functions
- User accounts and rights management
- A scheduler (for jobs and backups)
- Data transformation services
- Incremental backups

 

[Ignacio Machin ( .NET/ C# MVP )]

hi,
can access db store images? for sql server, I sure know that.
YES

what all are plus points for sql server against access db?

TIA

you can use stored procedures, it's more efficient to have concurrent
users accesing the DB.
IMO you should use SQL Express (it's a FREE version) from the
beginning I have seen several occasion where the program was suppose
to be "small" and start using access or even foxpro and then having to
scale up to SQL server

 

[Ignacio Machin ( .NET/ C# MVP )]

Yes. However an Access database is limited to 4 GB so you can't have a
lot of images.


More concurrent connections (Access drivers are limited to 64).

You can connect to SQL Server from a different computer. Access can only
be used from the same computer.

Being a real database server SQL Server has a lot of features, like:
- Stored procedures and user defined functions
- User accounts and rights management
- A scheduler (for jobs and backups)
- Data transformation services
- Incremental backups

Please note that several of those services (A scheduler (for jobs and
backups), Data transformation services) are only available with the
full version, the express version does not include them

 

[Göran Andersson]

you can use stored procedures, it's more efficient to have concurrent
users accesing the DB.
IMO you should use SQL Express (it's a FREE version) from the
beginning I have seen several occasion where the program was suppose
to be "small" and start using access or even foxpro and then having to
scale up to SQL server

Note that the SQL Express version is also limited to 4 GB, just like Access.

 

[Jeff Johnson]

Note that the SQL Express version is also limited to 4 GB, just like
Access.

What version of Access, 2007? Because older versions are limited to 2GB, not
4.

 

[Göran Andersson]

What version of Access, 2007? Because older versions are limited to 2GB, not
4.

You are most likely right. There are so many limits around 2 and 4 GB
that I probably mixed them up.