Can it be that NO ONE HERE knows this answer?

[Lauren Wilson]

One more try.

After ransacking the Desktop AND Enterprise edition of Ken Getz Dev
Handbooks on Access 2002, I STILL don't know if it is or is not
possible to link a client side MDE with a WEB server MDB table using
ADO.

Does ANYONE know the correct answer to that question?

[John Mishefske]

Lauren Wilson wrote:

One more try.

After ransacking the Desktop AND Enterprise edition of Ken Getz Dev
Handbooks on Access 2002, I STILL don't know if it is or is not
possible to link a client side MDE with a WEB server MDB table using
ADO.

Does ANYONE know the correct answer to that question?

No. There may be technologies available to handle the TCP/IP communication
between a client and server but its not built-in to Access.

One such technology:

http://www.unix.org.ua/orelly/linux/dbi/ch08_02.htm

--
'---------------
'John Mishefske
'---------------

[planetthoughtful]

Not to be obtuse, but perhaps a lack of an answer is an answer in
itself?

One possible solution would be to write a transaction handling page on
your web server, so that your client side MDE interrogates the page,
which in turn interrogates your web server MDB. It's a little kludgy,
but I've seen it used in other apps.

Do a Google search on "Microsoft.XMLH TTP" if this is a path you'd like
to pursue further, and here's a link to an older thread in this
newsgroup that covers a similar topic.

http://groups.google.com/group/comp....570a3045e766c8

Much warmth,

planetthoughtfu l

---
"Lost in thought"
http://www.planetthoughtful.org

[rkc]

Lauren Wilson wrote:

One more try.

After ransacking the Desktop AND Enterprise edition of Ken Getz Dev
Handbooks on Access 2002, I STILL don't know if it is or is not
possible to link a client side MDE with a WEB server MDB table using
ADO.

Does ANYONE know the correct answer to that question?

You can send requests to a web server using VBA and methods of
Microsoft.XMLHT TP which is part of the Microsoft.MSXML library.
There are examples to be found using Google, but since it is
technology meant to be used via a web browser the examples are
mostly in ASP. Perl, PHP, etc.

You don't talk directly to the .mdb file. You send requests or
Post data to 'web pages' that communicate with the .mdb file via
the scripting language of your choice.

[Lyle Fairfield]

I don't know the correct answer.
I do know that I have never done it and that I know of no example if
its being done and that I know of no instructions on how to do it.
It is my opinion that you often decide on solutions by yourself and
then seek in CDMA the "how to" of the solution without discussion of
the problem and which solution might be appropriate. It is also my
opinion that this strategy sometimes leads you to accept and to note
your support for ideas, strategies and code which are suspect, if not
down-right nonsense.

[Lauren Wilson]

On 16 Mar 2006 03:29:35 -0800, "Lyle Fairfield"
<ly***********@ aim.com> wrote:

I don't know the correct answer.
I do know that I have never done it and that I know of no example if
its being done and that I know of no instructions on how to do it.
It is my opinion that you often decide on solutions by yourself and
then seek in CDMA the "how to" of the solution without discussion of
the problem and which solution might be appropriate.
Interesting -- my posting pattern has drawn your attention!
I don't know whether to be concerned or pleased.

You are correct that I often decide on the solution and then seek
advice on how to implement it. If I fail to post complete context, it
is due to time restrictions and, to some degree, non-disclosure
agreements and other legal obligations to which I am a party. My
personal inclination is to include MORE detail than needed to address
the problem. People often accuse me of telling them how to build a
clock, when the time of day was all they wanted to know.
It is also my opinion that this strategy sometimes leads you to accept and to note
your support for ideas, strategies and code which are suspect, if not down-right nonsense.

I assure you, I have never IMPLEMENTED nonsense coding advice. If I
have appeared to approve of or recommend nonsense, then thanks for
your insight and effort. Would you be so kind as to describe an
example from this group where I have demonstrated such behavior?
If you succeed, I will GLADLY admit it and thank you publicly for
identifying my error.

In any case, I'm not a big fan of re-inventing the wheel. If I can
get a quick answer here from kind folks who do me the honor of
sharing, why should I (or anyone) waste time doing original research
on issues that thousands of others have already competently done?
Is that not one of the intended results of this group?

I believe this group is a significant force for good in support of the
human economic engine -- and YOUR contributions are much appreciated.

[David W. Fenton]

Lauren Wilson <no****@nospam. com> wrote in
news:sd******** *************** *********@4ax.c om:

One more try.

After ransacking the Desktop AND Enterprise edition of Ken Getz
Dev Handbooks on Access 2002, I STILL don't know if it is or is
not possible to link a client side MDE with a WEB server MDB
table using ADO.

Does ANYONE know the correct answer to that question?

You're asking if Access can retrieve data over HTTP with ADO?

The answer is NO.

But there are ways to get HTML data into Access retrieved over HTTP,
but it doesn't involve ADO between the local and remote Access
databases.

Access 12 may actually change this. I note in yesterday's Access 12
blog entry and example of linking to a schema on a SharePoint
server, and it uses HTTP as its protocol for defining the remote
server, which suggests that Access 12 communicates with SharePoint
Server via HTTP.

I don't know if that helps or confuses things!

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[rkc]

Lyle Fairfield wrote:

I don't know the correct answer.
I do know that I have never done it and that I know of no example if
its being done and that I know of no instructions on how to do it.
It is my opinion that you often decide on solutions by yourself and
then seek in CDMA the "how to" of the solution without discussion of
the problem and which solution might be appropriate. It is also my
opinion that this strategy sometimes leads you to accept and to note
your support for ideas, strategies and code which are suspect, if not
down-right nonsense.

Your down right contempt for 90% of the people that post here is
becoming more apparent every day. Must be a burden that accompanies
a genius IQ.

[Jerry Boone]

Do you know what you are asking? More detail of what you are trying to
accomplish would certainly help...

Sounds like you want MDE code (which I presume you control the source code
of, otherwise you may want to forget it) to insert/update/delete an MDB
stored in a web folder on your website?

If that is true, then the only way I could see you making progress is by
building a web service in .net with 3 methods (insert/update/delete). You
then would need to build a .net client side application to talk to the web
service (or locate some kind of com based webservice dll) to have your mde
code talk to. This would simply be a translator, working over port 80 in a
very savvy way. It basically automates all the xml document
creation/transmission/consumption (and vice versa) for you. Once this is
all in place, theoretically your in business.

Of course there are probably other ways to do this, it's one way I know of -
others may provide them or they may not.

If you were willing to talk to something other than an MDB then I would
probably put Sql server to work on the web server, open up port 1433 to a
fixed client IP with tight security credentials and talk to sql directly
with ADO - easy solution.

--
Jerry Boone
"Lauren Wilson" <no****@nospam. com> wrote in message
news:sd******** *************** *********@4ax.c om...

One more try.

After ransacking the Desktop AND Enterprise edition of Ken Getz Dev
Handbooks on Access 2002, I STILL don't know if it is or is not
possible to link a client side MDE with a WEB server MDB table using
ADO.

Does ANYONE know the correct answer to that question?

[david epsom dot com dot au]

From the A97 help:

"You cannot import or link a Microsoft Access database or an ODBC data
source on an FTP or HTTP server."

(david)
"Lauren Wilson" <no****@nospam. com> wrote in message
news:sd******** *************** *********@4ax.c om...

One more try.

After ransacking the Desktop AND Enterprise edition of Ken Getz Dev
Handbooks on Access 2002, I STILL don't know if it is or is not
possible to link a client side MDE with a WEB server MDB table using
ADO.

Does ANYONE know the correct answer to that question?