473,326 Members | 2,588 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Access ADP's

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?
Nov 13 '05 #1
4 1878
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
Nov 13 '05 #2
"Lyle Fairfield" <ly******@yahoo.ca> wrote in message
news:31*************@uni-berlin.de...

So that's a 'no' then Lyle?

Actually I daresay you've saved me much hubble bubble toil and trouble. I've
got a pro bono (which I believe is Latin for 'not getting paid for it') SQL
Server database that I need a George W Bush interface for. In light of your
comments at least I'll know to bail out quickly if the ADP becomes too much
of a PITA.

It is useful to have somebody like you express opinions. Cause I know that
you have put some work into ADPs and gave them a far better chance than most
people. So your disillusion speaks volumes.

Are they being developed any further by MS? I've kinda stopped installing
every version of Office in the world so don't know what happened after
Access 2000.

Cheers, Mike
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

Nov 13 '05 #3
Mike MacSween previously wrote:
Are they being developed any further by MS? I've kinda stopped
installing every version of Office in the world so don't know what
happened after Access 2000.


At the UK Access user group MS said that the future was MDB-shaped.
Technology involving the letters a, d and p in any order would not be
developed further in any significant way.

Peter Russell
Nov 13 '05 #4
Lyle Fairfield <ly******@yahoo.ca> wrote in message news:<31*************@uni-berlin.de>...
<snip>

Too funny.

I am nowhere near as disenchanted with ADP's as Lyle is, but it does
have strange quirks, most of which you have to learn about the hard
way. IMO, if you are on the clock billing a client, the hard way is
not the best time to learn.

For small, non-critical projects, it's very quick and easy -- once you
have figured out the wierd bits.
Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: kackson | last post by:
Hi. I would like to access my database outside of my company. I read many documents but they are all pertaining to accessing the database via ASP or some form of web application. Is there no...
3
by: *no spam* | last post by:
I want to move my Access 2K database into MSDE. The Access Upsizing Wizard crashes (a known bug wi A2K), so I'm using the following suggested method: Access --> New --> Project (Existing...
28
by: Neil Ginsberg | last post by:
I have a client who is using Access 2002/2000 (the database itself is written in 2000), and is considering migrating to Access 2003. Any recommendations on whether Access 2003 is worth the migrate,...
1
by: Matt Alanzo | last post by:
On another newsgroup an Access knowledgable party posted: >You should be able to connect an Access ADP to an existing SQLExpress >database running in SQLS 2000 compatibility mode. The only thing...
5
by: John | last post by:
I need to upsize my Access 2002 "database" to a larger database. I would like to use Access projects to manage the database. With this preference, it would seem MS SQL Server 2000 is the ideal way...
1
by: Erica Dunn | last post by:
Hi all. I'm trying to launch a .adp file from my web page. The application is residing on the intranet, and the .adp file would be located on a shared drive that everyone would have rights to. ...
4
by: Supa Hoopsa | last post by:
I am in the process of rewriting an MS Access application (access front end with SQL 2k database) in VB.NET and one of the things I would like to do is link in to the compiled Access ADE so that I...
6
by: Donald Grove | last post by:
I do programming in Access 2000 and 2003. I don't have a copy of 2003 myself, though. I have read about the adp software that comes with Access 2003, that converts an application to an access...
2
by: JA | last post by:
Is it possible to connect to Sql Server 2005 using an Access 2000 adp? I keep trying, but it doesn't want to accept my id, even though it is right.
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.