[AccessD] SQL vs Access

I guess the first question would be why you care?  SQL Server is just a data
store like any other.  If they can assist you in getting the dbf and log
file working on your system at home, and seamlessly moving to the final
resting place then it is pretty much a wash.  I would be happy that they
weren't insisting that it be done in C++.  8-) 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Friday, February 01, 2008 11:50 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] SQL vs Access

Dear List:
 
I am looking at doing a job which is ideal for an Access back end (IMO) but
IT would prefer a SQL back end for the reasons below.  I expressed the
opinion that SQL would be overkill.  But they are concerned about stability
and backup.
 
How do I respond to this? Does he have a valid point?  The database will
have a relatively small amount of data and 4 initially and eventually up to
10 users.  Light entry and update.  
 
**********************************************************

I think his response about it being overkill is from the perspective that it
is a small application which normally wouldn't warrant a MS SQL license and
overhead.  Because we already have several servers, we would not require any
additional licenses.  The real reason we would like the MS SQL backend is
for stability and backup purposes.  We cannot backup an Access database the
same way we can MS SQL because it is simply a flat file and can sometimes
not properly backup if the file is currently in use (which will be the
majority of the time).  Additionally, in the past we have had problems with
corrupt MS Access databases when multiple people are accessing it
simultaneously.  I think it would be valuable to have him quote the project
if it were done only in MS Access and the side-by-side comparison of the
same project with the MS SQL backend.  Please let me know if you need
further assistance in talking to Rocky about this.

******************************************

 
MTIA
 
Rocky'
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com