Access vs SQL

I an trying to create a policy for when to use Access as to using SQL. I
feel that in the proper environment it is adequate to use Access as to using
SQL. I may be wrong, I just have a problem with creating a 10mb SQL
database that will not be used that much. I have looked at the comparison
chart and understand the system differences.
TIA
CDAccess is a wonderful product and is useful in many cases. Do you have a
specific question? Also, have you considered using the MSDE option within
Access?
One large reason to consider SQL over Access even in cases that Access may
be appropriate is upgrades. Will a reasonable percentage of the applications
ever become large enough to move to SQL Server? It's MUCH easier to move an
Access app based on MSDE (rather than Jet) to SQL Server.
I find that most companies in a mixed Access/SQL environment often end up
needing to move some of the Access DB's to SQL over time...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"CD" <mcdye1@.hotmail.nospam.com> wrote in message
news:%23y5edRKdEHA.3380@.TK2MSFTNGP12.phx.gbl...
> I an trying to create a policy for when to use Access as to using SQL. I
> feel that in the proper environment it is adequate to use Access as to
using
> SQL. I may be wrong, I just have a problem with creating a 10mb SQL
> database that will not be used that much. I have looked at the comparison
> chart and understand the system differences.
> TIA
> CD
>|||CD,
If it is a single-user database to be used by someone on their own
machine, then recommend Access. If it is a multi-user database that
could potentially grow over time, then use SQL Server. A database server
set up for all the little databases in your organisation should be easy
for you to administer. Administering several Access files is just a huge
headache to me.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
CD wrote:
> I an trying to create a policy for when to use Access as to using SQL. I
> feel that in the proper environment it is adequate to use Access as to usi
ng
> SQL. I may be wrong, I just have a problem with creating a 10mb SQL
> database that will not be used that much. I have looked at the comparison
> chart and understand the system differences.
> TIA
> CD
>|||and..
Access (JET) can't be backed up whilst other people are using it, SQL can.
So if you need to take reliable backups without kicking users off (eg a web
app) Access isn't the right tool for the job.
Access (JET) also doesn't have any write-ahead logging, so corruption is far
more likely than in SQL.
Access with MSDE (instead of JET) is a great idea as you get the best of
both worlds.
Regards,
Greg Linwood
SQL Server MVP
"CD" <mcdye1@.hotmail.nospam.com> wrote in message
news:%23y5edRKdEHA.3380@.TK2MSFTNGP12.phx.gbl...
> I an trying to create a policy for when to use Access as to using SQL. I
> feel that in the proper environment it is adequate to use Access as to
using
> SQL. I may be wrong, I just have a problem with creating a 10mb SQL
> database that will not be used that much. I have looked at the comparison
> chart and understand the system differences.
> TIA
> CD
>