Rusty Hammond
rusty.hammond at cpiqpc.com
Mon Mar 4 10:56:55 CST 2013
I've read a little about Access 2007/2010 being able to run with linked/cached tables to a Sharepoint site, and can run disconnected from the network/internet, then when reconnected to the network, the tables will synch up with the Sharepoint database. Has anyone else heard of this and are you using it? How well does it work? I've heard it works really well but don't know what the limitations are (if any). Rusty -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Monday, March 04, 2013 9: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 ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. **********************************************************************