Eric Barro
ebarro at verizon.net
Fri Aug 17 14:51:36 CDT 2007
Julie, Sharepoint will never go away. Microsoft has made sure of that by integrating MS Office apps tightly with the platform. Eric -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Julie Taylor Sent: Friday, August 17, 2007 11:26 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access Front-End via Web Enabled Hi Steve, Thank you for that suggestions. We are just now setting up one of our customers with Sharepoint, and have developed an initial Intranet site for them. Seems pretty painless. I think that your idea about using Sharepoint is a good one. My only fear is that I will learn to develop in Sharepoint, and then it will go away. It takes some time to develop the right skill set in an application to the point where I can use it in my business. If I spend that time with Sharepoint, and then it is no longer around, it will be lost time. Thank you for the other suggestions as well. We are working with several apps that we have written for pda's and tablet pc's. It just seems that to be able to go to a website via a wireless connection is so much simpler than having to connect to a server and replicate the data. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel Sent: Thursday, August 16, 2007 4:59 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access Front-End via Web Enabled Julie, Just to throw a couple other ideas into the ring. Probably wouldn't attract a lot of support from the mainstreamers, but I think merit serious consideration. 1. Export your database to SharePoint. Would require moving your application to Access 2007, and would require a learning curve, for example replacing Referential Integrity with Workflows and so forth. Of course, this technology is still very much in its infancy, and some limitations at the moment, but it is without doubt the way of the future. If you're talking about needing to invest time and effort into learning new technology anyway, then have a look. And if you're used to the Replication idea, then Access/SharePoint offline data synchronisation is already pretty nice. 2. Depending on the number of concurrent users you are talking about here. But if the goal is to provide the users with remote operation, a solution with the least amount of work could be Terminal Server. You wouldn't need to change your existing application much at all. Or you could look at WinConnect http://www.thinsoftinc.com/product_thin_client_winconnect_server_xp.aspx, which I am using with very good results. Regards Steve Julie Reardon-Taylor wrote: > Looking for some opinions on what people are using for a web-enabled access > database. I have used replication for some applications, but would > now like > to move the front-end to a browser so that the input can be done via a > web > page over a wireless connection. > > Have toyed with data access pages, but not sure if that is a good solution. > > This application has three subform levels and the scripting may be an issue > in DAP. > > Did I read a posting on AccessD at some point that DAP are going to be > out > in the next version of Access? > > What are other people using as forms via the www?