Andrew Chanter wrote:
I am creating an Access client to a SQL db and decided to go with an ADP
instead of an MDB. But I'm having some issues. My previous post regarding
ADP's went unanswered. Is there anyone out there who knows about ADP's?
Yes, there is. I've used them since Access 2K. They are full of promise.
The promise has not been fulfilled. There are many idiosyncrasies.
Send me an ADP connected to an Internet enabled MS-SQL database and
using bound forms. I believe that I will be able to gain direct access
to the db unless you use application roles. And if the application is
large and complex, you will go crazy trying to cope with the bizarre
anomalies of Access ADPs and application roles; there are a multitude of
these.
And if I can do it for an Internet DB, others can for any db.
Use it as an unbound interface? Why? For its clumsy VBA? For its limited
and ugly GUI manifestation? Because every dolt who has learned where the
on-off switch is fancies himself/herself to have "medium" access skills
and experience and will try to mess with it?
Use it for its reports? Maybe. But certainly ADP reports are not as
sweet and simple as MDB reports. And MS's inability or unwillingness to
standardize forms and reports are, for me, a constant thorn. Be prepared
to wrestle with input parameters.
Want to stay up all night for a few nights trying to figure out how to
do something that must be done, after you are a thousand hours into the
project? Want to find out after posting to several newsgroups that no
one has a suitable solution? Use an ADP.
Want to feel that thrill after those several nights are rewarded by your
finding the true solution? Wait until you try that solution in exactly
the same circumstances and it doesn't work. Such joy. If you are
experienced you will think of the years you spent with DBaseIII,
FoxBase, FoxPro, Clipper, Delphi etc and realize that all their
frustrations were nothing compared with trying to cope with this latest
marvel.
Am I exaggerating? A bit. I still use ADPS for things that are small,
quick and dirty, George Bush types of applications. But would I embark
again on a major ADP? Only if the money were plentiful and mine and the
responsibility all someone else's. And I needed to feed my masochistic
needs.
With apologies to the English language ....
Lyle