Tony Septav
TSeptav at Uniserve.com
Mon Mar 4 17:01:27 CST 2013
Hey Rusty Alpha Five and Filemaker each have a web component and they require additional paid for components installed on a server too. Not true if you buy the package. Tony Septav Nanaimo, BC Canada -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rusty Hammond Sent: March-04-13 4:19 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] New Approach Nice. I can envision a Surface Pro tablet, loaded with Access 2010 (or the free runtime), workers in the field adding/editing data on the tablet. If they have an internet connection, great the data syncs, if they are somewhere they don't have a connection, fine, it syncs when they do have a connection. For management, they have a copy of the app back at the office for reporting - OR - setup reports in Report Server pulling from the Sharepoint site. Nice portable application, uses existing MS Access front end, no learning curve for us Access developers, except how to attach to a Sharepoint site or Office 365 account. Then there's the Access Web database. Used to create an application using Sharepoint with Access Web Services installed. No VBA but uses the new macro's. End user doesn't need Access installed, just a web browser. May not be the solution for all database apps, but for simple data entry and reporting, may work very well for a mobile application. Alpha Five and Filemaker each have a web component and they require additional paid for components installed on a server too. I'm just not sure I buy the idea that MS has given up on Access just yet. Just my 2 cents. Rusty -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Monday, March 04, 2013 3:24 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] New Approach On 4 Mar 2013 at 10:56, Rusty Hammond wrote: > 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 A recent post on LinkedIn's PMADN by Albert Kaplan: <quote> A configuration that is working well for me is to use Access 2010 with office 365. So you purchase one office 365 p1 (small business plan). Total cost = $6 per month. You then take your application. Assuming split, you place the back end tables on office 365. You then link your desktop front end to that application. You are done. The application will now automatic run off line. And when you get back to any internet connection. You can sync. All data from all other users will appear on your system, and any changes you made will appear for everyone else. The beauty of this setup? You write and use Access - regular VBA etc. You don't have to write or setup a bunch of sync code - it is automatic and built into Access. Even better? If you have Access 2010, the whole thing can be setup in less time than it took me to make this post. No server has to be setup. No learning + setup or install of SQL server. No purchase of new software. No writing of a whole bunch of sync software. I explain in the following video how you upload related tables to SharePoint or office 365: http://www.youtube.com/playlist?list=PL27E956A1537FE1C5&feature=plcp </quote> -- 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. ********************************************************************** -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.2899 / Virus Database: 2641/6144 - Release Date: 03/03/13