Jim Dettman
jimdettman at verizon.net
Mon Mar 4 10:22:29 CST 2013
Dan, There are more choices then that... 1. Use terminal services to run the apps. 2. Use a service like www.eqldata.com for remote users. And there's no reason you can't use linked tables and ODCB over the internet. You do need to write things differently, but you can live with ODBC. On Brad's question, while desktop databases are not going away anytime soon, it does seem like Microsoft has no intention of improving them. I think you'll see some improvements, but I believe they will be minor in nature. Microsoft has one focus at the moment, and that's the web. Anything they can do in that area will have priority. One only needs to look at Access 2013 to see this; everything was on the web side and nothing was done on the desktop side. That's a trend I believe you will see continue. If your not un-happy with desktop databases as is in 2013, then your good. But if your looking for improvements, I don't think you'll see them unless they happen to be related to a web feature. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Monday, March 04, 2013 10:37 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] New Approach 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com