[AccessD] From a reader -- about migrating Access data to SQL Server on the Web

1: Using DTS or similar this should be pretty painless for just the data tables.  The work will be in writing the sprocs and views you need I would think

2: I would be very tempted to build something browser based rather than using Access

3: out of my league....


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Wednesday, 22 April 2009 11:27 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] From a reader -- about migrating Access data to SQL Server on the Web

I received this from a reader. Any thoughts?

Susan H.

are feeling wonderfully benevolent, here goes.


I volunteer for a charity which uses Access for the membership system and we 
want to make it multi-user over the web. I believe I can achieve it by:

  1.. Migrating the data to SQL server
  2.. Installing the Access Runtime on the remote users' PCs
  3.. Serving the database over Citrix


Do you think this is:

  1.. a good idea
  2.. insane


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

This email and any attachments may contain privileged and confidential information
and are intended for the named addressee only. If you have received this e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this e-mail
has been sent to you in error. It is your responsibility to check this e-mail and
any attachments for viruses.  No warranty is made that this material is free from
computer virus or any other defect or error.  Any loss/damage incurred by using this
material is not the sender's responsibility.  The sender's entire liability will be
limited to resupplying the material.