SQL SERVER AND MICROSOFT ACCESS comparison

  • Thread starter Thread starter Pioneer
  • Start date Start date
P

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
 
Pioneer said:
hi,
can access db store images? for sql server, I sure know that.
Click to expand...

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?
Click to expand...

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
 
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
Click to expand...

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
 
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
Click to expand...

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
 
Ignacio said:
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
Click to expand...

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

What version of Access, 2007? Because older versions are limited to 2GB, not
4.
 
Jeff said:
What version of Access, 2007? Because older versions are limited to 2GB, not
4.
Click to expand...

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