Dan Waters
df.waters at comcast.net
Mon Mar 4 09:37:01 CST 2013
Hi Brad, Access should be around for a long time, but because people want to open the system on their laptops when they are away from the office, Access may not be the best platform for an application that everyone uses. You have sort of 3 choices (by increasing complexity): 1) Convert your Access tables to SQL Server and rewrite the Access application to connect to SQL server w/o using table links. IOW, write your connection code within the app. External users will connect via VPN to your network. 2) Convert your access tables to SQL Server and rewrite the application in VB.Net or C#. This is a good choice but a significant learning curve. External users will connect via VPN to your network. 3) Rewrite everything and create a web site. Users will connect directly to that site. Hope this helps! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Monday, March 04, 2013 8:36 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] New Approach All, This is probably a really dumb question. If a small firm has existing desktop-based applications (including applications built with Access) AND there is no need to have these "internal" applications visible on the internet, is there a need to look at software products such as Alpha-5? Won't Access be around for a long time for such internal applications? Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav Sent: Sunday, March 03, 2013 4:54 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] New Approach Hey All Thank you all kindly for your suggestions on venues I should be researching. Just to let you know (some may say who cares), I have gone with and purchased Alpha Five11. It looks like it will take me forward. I will still be an ACCESS supporter and remain with this list (some may say "Hey get lost"). Wish me luck on my new venture, and hopefully an old dog can learn some new tricks. Thanks for all your wonderful support Tony Septav Nanaimo, BC Canada -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com