[AccessD] SQL and Access

Kath Pelletti kp at sdsonline.net
Mon Jun 19 01:21:41 CDT 2006


Drew - no, they don't have SQL Server. I thought that since this really should be viewed as a web application that Access wouldn't be the best back end for future growth. This company sells DVD's online - they are getting into selling more and more products which will be available for downloading to mobile phones etc. It sounds to me like I should plan for significant growth, so that put me off Access. 

Kath
  ----- Original Message ----- 
  From: DWUTKA at marlow.com 
  To: accessd at databaseadvisors.com 
  Sent: Sunday, June 18, 2006 7:28 AM
  Subject: Re: [AccessD] SQL and Access


  Do they already have SQL Server?  If not, why not just stick with an Access
  .mdb backend?

  Drew

  -----Original Message-----
  From: Kath Pelletti [mailto:kp at sdsonline.net] 
  Sent: Friday, June 16, 2006 3:14 AM
  To: Access D Normal List
  Subject: [AccessD] SQL and Access

  Hi everyone - 

  Can I pick your brains? I have a client who needs to put some data on the
  web which will connect to a 3rd party shopping cart product, ie. they want
  to display their goods on the web and allow them to be sold on to retail
  clients. They already have the shopping cart side organised, but they have a
  statically typed website - no database to feed it.

  They also need an internal system which will meet administration, management
  and reporting requirements - but fairly simple stuff. They are very strapped
  for cash (smirk) and want a fairly inexpensive solution. Lately I have been
  working on .net with SQL Server 2005 systems which would be a great solution
  - but way too expensive in development costs.

  So what about SQL Server BE with Access front end? I know it's very common
  but can someone tell me:

  - any gotchas
  - cost for client in terms of licences they would need for SQL? I can't seem
  to find a clear answer by googling.


  Thanks.

  ______________________________________
  Kath Pelletti
  Software Design and Solutions Pty Ltd.
  Ph: 9505-6714
  Fax: 9505-6430
  Email: KP at SDSOnline.net
  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com



More information about the AccessD mailing list