[AccessD] New Approach

Doug Murphy dw-murphy at cox.net
Tue Mar 5 19:18:48 CST 2013


There is a lot on this on the web. Rogers Access blog has quite a bit. MS
has volumes. Look at
http://rogersaccessblog.blogspot.com/2010/05/access-2010-web-databases-how-c
an-i-put.html for a start. This has to do with web databases but the process
is similar. I played with using SP lists on Office365 as a backend for a
client. In Access 2010 the design tools were not intuitive for an Access
user. As with ribbons the function is there, you just have to find it.

I have an extensive list of web sites with this stuff if anyone is
interested. I decided a cheap hosting account with SQL server met our needs
much better.

Doug

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, March 05, 2013 4:37 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] New Approach

I know absolutely nothing about SharePoint. So perhaps it's not surprising
that your comments leave me somewhat mystified. Let's start with a simple
case, an Access app in classic style that consists of an FE and a BE. In
terms of complexity, it's trivial, about 25 tables and about twice that many
forms and queries. So how does this app get into SharePoint? Do we just copy
the BE into SP? And then what about the FE? Do I have to rebuild the FE in
SP? That's the part I don't understand.

The client in question has about 100+ users and also has a license for SP.
The users are in several offices and apparently they all hit a central
server that runs SP. From the little I have seen, their primary focus is on
document storage. I don't understand how database apps fit into this
picture.

Would you please enlighten me? I wrote an Access app for them, but if there
is some way to get this app into SP then their lives would be a lot simpler,
and I guess so would mine. So any wisdom you would care to share about how
this is done would be most welcome. I've heard of SP lists, and even seen
that on the Access ribbon, but I have no idea what it means.

Hoping that you can clear up some of the fog.

Arthur

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list