[AccessD] Access Web app question

Arthur Fuller fuller.artful at gmail.com
Sun Apr 10 13:18:35 CDT 2016


Susan,

The obvious answer is, Of course, but...

I'm assuming that the Access app of interest consists of the traditional FE
and BE components, and that the bulk of the work will be done locally; but
that new requirements demand access to the BE using a web-based app whose
capabilities are far fewer than the desktop's app.

The simplest way to do this, I think, would be to define a group of named
queries in Access, some updateable and others read-only, and to use those
and only those in the web app.

The web part will have to deal with security issues on some level --
perhaps logins, or maybe roles if the user-base goes beyond a few, and
changes frequently.

With those issues settled, the only remaining questions revolve around the
choice of development tools. I think we are pretty much all agreed that the
efforts by the MS Access team in this respect are somewhat less than
stellar. Here you have several possible directions. The choice among them
might depend upon the skill-set of the developers within the organization
of interest. Regarding said possible toolsets, I've investigated at least
some of them and settled
upon one. Ask another developer and her choice may well be another toolset.

As Mark Twain so famously phrased it, "If it weren't for differences of
opinion, we wouldn't have horse races."


On Sun, Apr 10, 2016 at 12:21 PM, Susan Harkins <ssharkins at gmail.com> wrote:

> Can you integrate a web app with an existing Access database - sending only
> specific fields to the Web app for viewing and possible updating?
>
>
>
> Susan H.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Arthur


More information about the AccessD mailing list