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?

[Lauren Wilson]

On Thu, 16 Mar 2006 15:44:13 -0600, "David W. Fenton"
<XX*******@dfen ton.com.invalid > wrote:

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

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!

Oh it DEFINITELY helps! Thanks David. You are SUCH a good guy!
This is the kind of answer I was looking for -- high level view of the
issue.

Now, what about that blog you mentioned above. Can we have a link?

[Lyle Fairfield]

rkc wrote:

Your down right contempt for 90% of the people that post here is
becoming more apparent every day.

Should I run for President?

[Terry Kreft]

I've got my bumper sticker already ...

Get a Fair Deal with Fairfield for President
I think it will get the intellectual voter myself.
--

Terry Kreft
"Lyle Fairfield" <ly***********@ aim.com> wrote in message
news:11******** **************@ i40g2000cwc.goo glegroups.com.. .

rkc wrote:

Your down right contempt for 90% of the people that post here is
becoming more apparent every day.

Should I run for President?

[Lyle Fairfield]

You asked for an example? This is it.

Access CAN retrieve data over HTTP with ADO.

Try this:
Sub temp()
Dim r As ADODB.Recordset
Set r = New ADODB.Recordset
With r
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockBatchOpti mistic
.Open "http://ffdba.com/ffdbaAccounts.x ml"
While Not .EOF
Debug.Print Trim(.Fields(1) .Value)
.MoveNext
Wend
End With
End Sub

Is it data?
Did it come "over" http?
Was it "with" ADO?

Could we write something to modify or add to this to this data and save
our updates? Yes, we could.

[Rick Brandt]

Lyle Fairfield wrote:

You asked for an example? This is it.

Access CAN retrieve data over HTTP with ADO.

Try this:
Sub temp()
Dim r As ADODB.Recordset
Set r = New ADODB.Recordset
With r
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockBatchOpti mistic
.Open "http://ffdba.com/ffdbaAccounts.x ml"
While Not .EOF
Debug.Print Trim(.Fields(1) .Value)
.MoveNext
Wend
End With
End Sub

Is it data?
Did it come "over" http?
Was it "with" ADO?

Could we write something to modify or add to this to this data and
save our updates? Yes, we could.

<nit>
But the OP did specify data from an MDB file.
<pick>

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Lyle Fairfield]

The quote ti which I referred is:

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

The answer is NO."

[rkc]

Lyle Fairfield wrote:

rkc wrote:

Your down right contempt for 90% of the people that post here is
becoming more apparent every day.

Should I run for President?

I thought Canada had a Queen.

[David W. Fenton]

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

Now, what about that blog you mentioned above. Can we have a
link?

http://blogs.msdn.com/access/

I would think everyone interested in the future of Access should be
reading it.

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

[Lauren Wilson]

Interesting. If this works, it's exactly what I had in mind. However,
SOME people in this group are claiming this is not possible.
Hmmmm. Oh darn! Guess I'll have to just try it.

Thanks Lyle

-- LW

On 17 Mar 2006 09:49:08 -0800, "Lyle Fairfield"
<ly***********@ aim.com> wrote:

You asked for an example? This is it.

Access CAN retrieve data over HTTP with ADO.

Try this:
Sub temp()
Dim r As ADODB.Recordset
Set r = New ADODB.Recordset
With r
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockBatchOpti mistic
.Open "http://ffdba.com/ffdbaAccounts.x ml"
While Not .EOF
Debug.Print Trim(.Fields(1) .Value)
.MoveNext
Wend
End With
End Sub

Is it data?
Did it come "over" http?
Was it "with" ADO?

Could we write something to modify or add to this to this data and save
our updates? Yes, we could.

[Lauren Wilson]

On Fri, 17 Mar 2006 19:12:26 GMT, "Rick Brandt"
<ri*********@ho tmail.com> wrote:

Lyle Fairfield wrote:

You asked for an example? This is it.

Access CAN retrieve data over HTTP with ADO.

Try this:
Sub temp()
Dim r As ADODB.Recordset
Set r = New ADODB.Recordset
With r
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockBatchOpti mistic
.Open "http://ffdba.com/ffdbaAccounts.x ml"
While Not .EOF
Debug.Print Trim(.Fields(1) .Value)
.MoveNext
Wend
End With
End Sub

Is it data?
Did it come "over" http?
Was it "with" ADO?

Could we write something to modify or add to this to this data and
save our updates? Yes, we could.

<nit>
But the OP did specify data from an MDB file.

True, however, I see no reason why we could not use XML.