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?
47  1898 
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
'---------------
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.XMLHTTP" 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,
planetthoughtful
---
"Lost in thought" http://www.planetthoughtful.org
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.XMLHTTP 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.
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.
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.
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!
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
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.
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.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?
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.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?
On Thu, 16 Mar 2006 15:44:13 -0600, "David W. Fenton"
<XX*******@dfenton.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?
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'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.googlegr oups.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?
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 = adLockBatchOptimistic
.Open "http://ffdba.com/ffdbaAccounts.xml"
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.
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 = adLockBatchOptimistic
.Open "http://ffdba.com/ffdbaAccounts.xml"
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
The quote ti which I referred is:
"You're asking if Access can retrieve data over HTTP with ADO?
The answer is NO."
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.
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 = adLockBatchOptimistic
.Open "http://ffdba.com/ffdbaAccounts.xml"
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.
On Fri, 17 Mar 2006 19:12:26 GMT, "Rick Brandt"
<ri*********@hotmail.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 = adLockBatchOptimistic
.Open "http://ffdba.com/ffdbaAccounts.xml"
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.
On 17 Mar 2006 11:29:44 -0800, "Lyle Fairfield"
<ly***********@aim.com> wrote: The quote ti which I referred is:
"You're asking if Access can retrieve data over HTTP with ADO?
The answer is NO."
Lyle, have you actually used the code you posted and succeeded in
reading and writing data to/from an MDB file on a web server?
Is this true of Access 2003?
On Fri, 17 Mar 2006 10:46:48 +1100, "david epsom dot com dot au"
<david@epsomdotcomdotau> wrote: 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.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?
I can think of no reason you can't run the ""exact"" code. The file is
there.
Writing Data will take a little longer. Maybe tomorrow.
Lauren Wilson <no****@nospam.com> wrote in
news:a4********************************@4ax.com: 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.
What Lyle is suggesting requires some intermediate tech between the
MDB and the ADO connection to create the XML stream. You asked about
ADO -> MDB, but Lyle is giving you a different answer.
It's basically no different than the XHTML answers others gave,
since it requires a server-side component to produce the XML.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Lauren Wilson <no****@nospam.com> wrote in
news:u9********************************@4ax.com: On 17 Mar 2006 11:29:44 -0800, "Lyle Fairfield"
<ly***********@aim.com> wrote:
The quote ti which I referred is:
"You're asking if Access can retrieve data over HTTP with ADO?
The answer is NO."
Lyle, have you actually used the code you posted and succeeded in
reading and writing data to/from an MDB file on a web server?
What is running on the server to produce the XML? That's the part
Lyle has left out of the equation.
His answer leaves out the "from an MDB" part that is so crucial to
your original question.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
"Lyle Fairfield" <ly***********@aim.com> wrote in
news:11**********************@i39g2000cwa.googlegr oups.com: I can think of no reason you can't run the ""exact"" code. The file is
there.
Writing Data will take a little longer. Maybe tomorrow.
We can write the data to a local file and upload it all with ADO only.
Sub RecordsetOnHttp()
Dim r As ADODB.Recordset
Set r = New ADODB.Recordset
With r
.Open "http://ffdba.com/ffdbaAccounts.xml", , adOpenKeyset,
adLockBatchOptimistic
While Not .EOF
Debug.Print .Collect(1)
.MoveNext
Wend
.AddNew Array(1, 2, 3), Array(Format(Now, "yyyymmddhhnnss"), Null,
False)
If DoesFileExist1997("ffdbaAccounts.xml") Then Kill
"ffdbaAccounts.xml"
.Save "ffdbaAccounts.xml", adPersistXML
End With
UploadFile "ffdbaAccounts.xml", "ffdbaAccounts.xml", "http://ffdba.com",
"UserName", "PassWord"
End Sub
Public Sub UploadFile( _
ByVal FromPath As String, _
ByVal ToFile As String, _
ByVal Server As String, _
Optional ByVal UserName As String, _
Optional ByVal PassWord As String)
Dim r As ADODB.Record
Dim s As ADODB.Stream
Set r = New ADODB.Record
Set s = New ADODB.Stream
r.Open Server & "/" & ToFile, , adModeWrite, adCreateOverwrite, ,
UserName, PassWord
With s
.Open r, , adOpenStreamFromRecord
.Type = adTypeBinary
.LoadFromFile FromPath
.Close
End With
r.Close
End Sub
Public Function DoesFileExist1997(ByVal FilePath As String) As Boolean
Const FileNotFoundErrNumber As Long = 53
On Error GoTo DoesFileExist1997Err
GetAttr FilePath
DoesFileExist1997 = True
DoesFileExist1997Exit:
Exit Function
DoesFileExist1997Err:
With Err
If .Number <> FileNotFoundErrNumber Then
MsgBox .Description, vbCritical, "Error Number: " & .Number
End If
End With
Resume DoesFileExist1997Exit
End Function
I have added 3 records to the Recordset. It is quite interesting to see
how these are saved in the xml.
<snips>
<z:row AccountID='19' CommonName='Income Tax' FormalDescription=''/>
<z:row AccountID='20' CommonName='Terraware' FormalDescription=''
IncludeInSummary='True'/>
<z:row AccountID='21' CommonName='Temp'
FormalDescription='Temporary' IncludeInSummary='True'/>
<rs:insert>
<z:row CommonName='NewName' IncludeInSummary='False'
rs:forcenull='FormalDescription'/>
<z:row CommonName='20060317211431' IncludeInSummary='False'
rs:forcenull='FormalDescription'/>
<z:row CommonName='20060317211440' IncludeInSummary='False'
rs:forcenull='FormalDescription'/>
</rs:insert>
They are saved as inserts. If we (ever) retach this recordset to its
parent database and updatebatch it, these new records will be saved.
I do not know if my upload is redundant because the save could be made
directly to the http server.
I do not know if my file upload will work on a non-ms server.
But I do know that data can be accessed from, modified, added to, and
saved to an http server using only ADO. I have done it. The code is there
for you to see.
Yes, I know this is strictly flat file. Yes I know it’s not an mdb. Yes I
know that there is no simultaneous user safeguard whatever. BUT IT IS
DATA, IT IS ACCESSED WITH ADO, AND IT IS THROUGH HTTP.
Could I use and edit the recordset with a form? Sure, I could.
--
Lyle Fairfield
On Fri, 17 Mar 2006 19:54:34 GMT, rkc
<rk*@rochester.yabba.dabba.do.rr.bomb> wrote: 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.
They have quite a few "queens". Ever been to Montreal or Vancouver?
On Fri, 17 Mar 2006 15:40:15 -0600, "David W. Fenton"
<XX*******@dfenton.com.invalid> wrote: Lauren Wilson <no****@nospam.com> wrote in
news:a4********************************@4ax.com :
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.
What Lyle is suggesting requires some intermediate tech between the
MDB and the ADO connection to create the XML stream. You asked about
ADO -> MDB, but Lyle is giving you a different answer.
It's basically no different than the XHTML answers others gave,
since it requires a server-side component to produce the XML.
I understand. However, I'm not sure why we couldn't just use XML all
the way.
If we can use XML instead of an MDB (probably better anyway), then
this appears to be what we need. Thanks a lot Lyle. I'm believe we
can adapt this approach to our needs. The amount of data we require
for this project component is VERY small -- maybe 3-4 fields per user.
Each user can have their own XML file with a name equal to their user
account number.
On Sat, 18 Mar 2006 02:30:56 GMT, Lyle Fairfield
<ly***********@aim.com> wrote: "Lyle Fairfield" <ly***********@aim.com> wrote in
news:11**********************@i39g2000cwa.googleg roups.com:
I can think of no reason you can't run the ""exact"" code. The file is
there.
Writing Data will take a little longer. Maybe tomorrow.
We can write the data to a local file and upload it all with ADO only.
Sub RecordsetOnHttp()
Dim r As ADODB.Recordset
Set r = New ADODB.Recordset
With r
.Open "http://ffdba.com/ffdbaAccounts.xml", , adOpenKeyset,
adLockBatchOptimistic
While Not .EOF
Debug.Print .Collect(1)
.MoveNext
Wend
.AddNew Array(1, 2, 3), Array(Format(Now, "yyyymmddhhnnss"), Null,
False)
If DoesFileExist1997("ffdbaAccounts.xml") Then Kill
"ffdbaAccounts.xml"
.Save "ffdbaAccounts.xml", adPersistXML
End With
UploadFile "ffdbaAccounts.xml", "ffdbaAccounts.xml", "http://ffdba.com",
"UserName", "PassWord"
End Sub
Public Sub UploadFile( _
ByVal FromPath As String, _
ByVal ToFile As String, _
ByVal Server As String, _
Optional ByVal UserName As String, _
Optional ByVal PassWord As String)
Dim r As ADODB.Record
Dim s As ADODB.Stream
Set r = New ADODB.Record
Set s = New ADODB.Stream
r.Open Server & "/" & ToFile, , adModeWrite, adCreateOverwrite, ,
UserName, PassWord
With s
.Open r, , adOpenStreamFromRecord
.Type = adTypeBinary
.LoadFromFile FromPath
.Close
End With
r.Close
End Sub
Public Function DoesFileExist1997(ByVal FilePath As String) As Boolean
Const FileNotFoundErrNumber As Long = 53
On Error GoTo DoesFileExist1997Err
GetAttr FilePath
DoesFileExist1997 = True
DoesFileExist1997Exit:
Exit Function
DoesFileExist1997Err:
With Err
If .Number <> FileNotFoundErrNumber Then
MsgBox .Description, vbCritical, "Error Number: " & .Number
End If
End With
Resume DoesFileExist1997Exit
End Function
I have added 3 records to the Recordset. It is quite interesting to see
how these are saved in the xml.
<snips>
<z:row AccountID='19' CommonName='Income Tax' FormalDescription=''/>
<z:row AccountID='20' CommonName='Terraware' FormalDescription=''
IncludeInSummary='True'/>
<z:row AccountID='21' CommonName='Temp'
FormalDescription='Temporary' IncludeInSummary='True'/>
<rs:insert>
<z:row CommonName='NewName' IncludeInSummary='False'
rs:forcenull='FormalDescription'/>
<z:row CommonName='20060317211431' IncludeInSummary='False'
rs:forcenull='FormalDescription'/>
<z:row CommonName='20060317211440' IncludeInSummary='False'
rs:forcenull='FormalDescription'/>
</rs:insert>
They are saved as inserts. If we (ever) retach this recordset to its
parent database and updatebatch it, these new records will be saved.
I do not know if my upload is redundant because the save could be made
directly to the http server.
I do not know if my file upload will work on a non-ms server.
But I do know that data can be accessed from, modified, added to, and
saved to an http server using only ADO. I have done it. The code is there
for you to see.
Yes, I know this is strictly flat file. Yes I know it’s not an mdb. Yes I
know that there is no simultaneous user safeguard whatever. BUT IT IS
DATA, IT IS ACCESSED WITH ADO, AND IT IS THROUGH HTTP.
Could I use and edit the recordset with a form? Sure, I could.
On Fri, 17 Mar 2006 15:41:57 -0600, "David W. Fenton"
<XX*******@dfenton.com.invalid> wrote: Lauren Wilson <no****@nospam.com> wrote in
news:u9********************************@4ax.com :
On 17 Mar 2006 11:29:44 -0800, "Lyle Fairfield"
<ly***********@aim.com> wrote:
The quote ti which I referred is:
"You're asking if Access can retrieve data over HTTP with ADO?
The answer is NO."
Lyle, have you actually used the code you posted and succeeded in
reading and writing data to/from an MDB file on a web server?
What is running on the server to produce the XML? That's the part
Lyle has left out of the equation.
I believe, in this case, all the XML can be generated on the client
end and simply stored on the server for future
retrieve/read/write/replace operations using code similar to what Lyle
posted.
Thanks for your counterpoint views.
His answer leaves out the "from an MDB" part that is so crucial to
your original question.
Lyle's willingness to think outside the box that I created has
revealed a possible solution that I had not yet considered. That
shift in perspective may result in a better solution than I originally
had in mind.
rkc <rk*@rochester.yabba.dabba.do.rr.bomb> wrote in news:_tESf.3706$Mj.626
@twister.nyroc.rr.com: 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.
That's for 99.44 % contemptibles.
--
Lyle Fairfield
Lyle Fairfield <ly***********@aim.com> wrote in
news:Xn*********************************@216.221.8 1.119: rkc <rk*@rochester.yabba.dabba.do.rr.bomb> wrote in
news:_tESf.3706$Mj.626 @twister.nyroc.rr.com:
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.
That's for 99.44 % contemptibles.
Hmmm ... I think this might be interpreted to be a statement about sexual
preference. It is not. It is a statement about government preference.
--
Lyle Fairfield
Lyle Fairfield wrote: Lyle Fairfield <ly***********@aim.com> wrote in
news:Xn*********************************@216.221.8 1.119:
rkc <rk*@rochester.yabba.dabba.do.rr.bomb> wrote in
news:_tESf.3706$Mj.626 @twister.nyroc.rr.com:
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.
That's for 99.44 % contemptibles.
Hmmm ... I think this might be interpreted to be a statement about sexual
preference. It is not. It is a statement about government preference.
Oh yeah, be careful. Wouldn't want to offend anything less than an
entire country.
rkc <rk*@rochester.yabba.dabba.do.rr.bomb> wrote in
news:f5*****************@twister.nyroc.rr.com: Oh yeah, be careful. Wouldn't want to offend anything less than an
entire country.
I thought it would only be around 40%? http://www.pollingreport.com/BushJob.htm
--
Lyle Fairfield
Lauren Wilson <no****@nospam.com> wrote in
news:il********************************@4ax.com: On Fri, 17 Mar 2006 15:40:15 -0600, "David W. Fenton"
<XX*******@dfenton.com.invalid> wrote:
Lauren Wilson <no****@nospam.com> wrote in
news:a4********************************@4ax.co m:
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.
What Lyle is suggesting requires some intermediate tech between
the MDB and the ADO connection to create the XML stream. You asked
about ADO -> MDB, but Lyle is giving you a different answer.
It's basically no different than the XHTML answers others gave,
since it requires a server-side component to produce the XML.
I understand. However, I'm not sure why we couldn't just use XML
all the way.
You mean skip the MDB and store the data in XML files?
Well, here are some reasons:
1. loss of referential integrity.
2. loss of validity checking of data types.
3. loss of indexes to improve searching performance.
4. verbosity of storage -- much greater than in a binary format like
an MDB.
XML seems to me to make sense only as a data interchange format. For
really working with large amounts of data, an actual database is
necessary. If you've ever programmed a database-like application
against plain text files, you'll know what the problems. Yes, ADO
provides a db-like interface to XML files, but that's only on the
surface.
It would mean putting everything the database engine does for you
into the application, and that's bad, in my opinion.
In the situation you describe, if I were considering abandoning the
MDB, I think I'd go with a server back end and connect to that
across the Internet (preferably on a VPN connection, if that's
possible), rather than completely abandoning a proper database
store.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Lauren Wilson <no****@nospam.com> wrote in
news:g4********************************@4ax.com: On Fri, 17 Mar 2006 15:41:57 -0600, "David W. Fenton"
<XX*******@dfenton.com.invalid> wrote:
Lauren Wilson <no****@nospam.com> wrote in
news:u9********************************@4ax.co m:
On 17 Mar 2006 11:29:44 -0800, "Lyle Fairfield"
<ly***********@aim.com> wrote:
The quote ti which I referred is:
"You're asking if Access can retrieve data over HTTP with ADO?
The answer is NO."
Lyle, have you actually used the code you posted and succeeded
in reading and writing data to/from an MDB file on a web server?
What is running on the server to produce the XML? That's the part
Lyle has left out of the equation.
I believe, in this case, all the XML can be generated on the
client end and simply stored on the server for future
retrieve/read/write/replace operations using code similar to what
Lyle posted.
Thanks for your counterpoint views.
I assume you own't mind, then, if I continue to dissent? :) His answer leaves out the "from an MDB" part that is so crucial to
your original question.
Lyle's willingness to think outside the box that I created has
revealed a possible solution that I had not yet considered. That
shift in perspective may result in a better solution than I
originally had in mind.
I think this is a terrible idea, myself. You're basically going to
re-implement replication with text files, and this is horrendously
difficult. You're also giving up all the benefits of having a db
engine.
Is running SQL Server or some other server db on the web server not
a possibility?
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
I agree that something like an Internet enabled MS-SQL db would be
preferable if there is some actual work to be done. A good one can be
rented for $20 (US) per month, probably cheaper if one looks around, as
that price includes a web site.
But if one is only checking a version number, or date, XML would
suffice.
I would go the $20 site / MS-SQL db route myself and get the db and all
its power; I'd put documentation on the site in html files, have a mail
to developer page there too (like yours) and create an introductory
Power Point Application.
But that's just my personal preference.
On Sat, 18 Mar 2006 14:33:09 -0600, "David W. Fenton"
<XX*******@dfenton.com.invalid> wrote: Lauren Wilson <no****@nospam.com> wrote in
news:g4********************************@4ax.com :
On Fri, 17 Mar 2006 15:41:57 -0600, "David W. Fenton"
<XX*******@dfenton.com.invalid> wrote:
Lauren Wilson <no****@nospam.com> wrote in
news:u9********************************@4ax.com :
On 17 Mar 2006 11:29:44 -0800, "Lyle Fairfield"
<ly***********@aim.com> wrote:
>The quote ti which I referred is:
>
>"You're asking if Access can retrieve data over HTTP with ADO?
>
>The answer is NO."
Lyle, have you actually used the code you posted and succeeded
in reading and writing data to/from an MDB file on a web server?
What is running on the server to produce the XML? That's the part
Lyle has left out of the equation.
I believe, in this case, all the XML can be generated on the
client end and simply stored on the server for future
retrieve/read/write/replace operations using code similar to what
Lyle posted.
Thanks for your counterpoint views.
I assume you own't mind, then, if I continue to dissent? :)
His answer leaves out the "from an MDB" part that is so crucial to
your original question.
Lyle's willingness to think outside the box that I created has
revealed a possible solution that I had not yet considered. That
shift in perspective may result in a better solution than I
originally had in mind.
I think this is a terrible idea, myself. You're basically going to
re-implement replication with text files, and this is horrendously
difficult. You're also giving up all the benefits of having a db
engine.
Is running SQL Server or some other server db on the web server not
a possibility?
It is. I would rather do it with SQL Server, or MySQL. It appears
that a DAP can connect to a remote SQL Server database. If so,
believe (hope) I can create a hidden DAP form to be the interface for
this licensing, update checking process. I know, I know. DAPs are
going away in Office 12. But we should be able to continue using
Access 2003 for at least another 2-3 years. After that, I'll just
re-write the procedure using the Access 12 technology. Since it's a
process that's transparent to the user, they'll never know the
difference.
Why use a DAP?
DAPs are for editing, appending and deleting data. Hiding a DAP is
basically inconsistent with its reason for being.
DAPs can be visible or not visible.
But the DAP object can be hidden or not hidden. When it's hidden its
attributes are ored with 8. I don't know of a way to un-or them (not
eight) as they are read-only except in the ui and when the page is
hidden the ui can't find it , that is to show the object once its been
hidden. (Perhaps, someone will enlighten me.)
DAPs are, for the most part, external .htm files. These files must
contain the connection information (to the db the DAO uses), or the
user must log on. If you want these to be secret then you won't,I
think, want the user to logon. If the connection data is in the htm
file then your data security may be compromised. ANyone who opens the
htm file in notepad can read it.
If you hide the file, hide the object and make the DAP not visible then
you will have three states of visibility to manage with code, secretly.
I think this might be an opportunity for the pain of "I didn't think of
that".
What could you do with a hidden DAP that you couldn't do with a simple
OleDB-ADO connection to your MS-SQL db and recordset in a VBA Module,
encrypting your logon etc?
..
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?
One more try.
<PhoneHome>
Sub PhoneHome()
Dim msXML As Object
Set msXML = CreateObject("Microsoft.XMLHTTP")
With msXML
'.Open "POST", "http://localhost/RegCheck.asp", False
.Open "POST", "http://rkcny.com/RegCheck.asp", False
.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
'.send ("Registration=999100292124")
'.send ("Registration=3342344%6667")
.send ("Registration=334234456667")
Debug.Print .responseText
End With
Set msXML = Nothing
End Sub
</PhoneHome>
Lauren Wilson <no****@nospam.com> wrote in
news:9o********************************@4ax.com: On Sat, 18 Mar 2006 14:33:09 -0600, "David W. Fenton"
<XX*******@dfenton.com.invalid> wrote:
Is running SQL Server or some other server db on the web server
not a possibility?
It is. I would rather do it with SQL Server, or MySQL. It
appears that a DAP can connect to a remote SQL Server database. .
. .
I'm confused. An MDB can connect to a remote SQL Server database, so
why would you implement a DAP just to get to the remote SQL Server
database?
. . . If so,
believe (hope) I can create a hidden DAP form to be the interface
for this licensing, update checking process. I know, I know.
DAPs are going away in Office 12. But we should be able to
continue using Access 2003 for at least another 2-3 years. After
that, I'll just re-write the procedure using the Access 12
technology. Since it's a process that's transparent to the user,
they'll never know the difference.
I don't get what purpose a DAP would serve in a scenario where you
had a remote SQL Server connection available to your local MDB.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
On Sun, 19 Mar 2006 14:31:13 -0600, "David W. Fenton"
<XX*******@dfenton.com.invalid> wrote: Lauren Wilson <no****@nospam.com> wrote in
news:9o********************************@4ax.com :
On Sat, 18 Mar 2006 14:33:09 -0600, "David W. Fenton"
<XX*******@dfenton.com.invalid> wrote:
Is running SQL Server or some other server db on the web server
not a possibility?
It is. I would rather do it with SQL Server, or MySQL. It
appears that a DAP can connect to a remote SQL Server database. .
. .
I'm confused. An MDB can connect to a remote SQL Server database, so
why would you implement a DAP just to get to the remote SQL Server
database?
OK, to get us in sync: Until about 36 hours ago, I was CONSIDERING
whether or not a DAP could be used for something that I THOUGHT was
not possible without it. Either I misread earlier posts or there is
disagreement about the issue among those who posted responses.
Bottom line: You appear to be saying that it IS possible to use ADO
FROM the VBA code of an MDB (or MDE) to connect to a table in an SQL
Database on a remote web server, using an HTTP URL as a connection
string -- correct?
Until you reminded me that this might be possible, I first looked for
a way to do it with an MDB on the web server. Since I have access to
several web servers running either MS SQL Server OR MySQL, I've simply
switched my focus to doing it that way. . . . If so,
believe (hope) I can create a hidden DAP form to be the interface
for this licensing, update checking process. I know, I know.
DAPs are going away in Office 12. But we should be able to
continue using Access 2003 for at least another 2-3 years. After
that, I'll just re-write the procedure using the Access 12
technology. Since it's a process that's transparent to the user,
they'll never know the difference.
I don't get what purpose a DAP would serve in a scenario where you
had a remote SQL Server connection available to your local MDB.
Lyle Fairfield wrote: ROFL!
You were right all along.
I should know that by now.
This solution is where I would probably go for some small data to
support my application.
It seems simple and quick and easily modifed from the server side by
messing with the ASP files.
And I am right in thinking that if the ASP can get at a db, any db, and
write some data, I can suck that data back into my Access or other
application? And I could send Parameters?
I'm going to have to play with this after income tax season.
I suppose I can use it from Script with the ActiveXObject too!
or even from ASP ... to ASP
Hmmmmmm ...
sounds too good to be true ... what's the catch?
Lyle Fairfield wrote: This solution is where I would probably go for some small data to
support my application.
It seems simple and quick and easily modifed from the server side by
messing with the ASP files.
And I am right in thinking that if the ASP can get at a db, any db, and
write some data, I can suck that data back into my Access or other
application? And I could send Parameters?
I'm going to have to play with this after income tax season.
I suppose I can use it from Script with the ActiveXObject too!
or even from ASP ... to ASP
Hmmmmmm ...
sounds too good to be true ... what's the catch?
It's so simple it seems like magic, but it is also what makes
the so called Ajax technology possible. All major up to date
browsers support an xmlhttp object. Microsoft as an active x
object. The others built in to the javascript support of the
browser.
Lauren Wilson wrote: Bottom line: You appear to be saying that it IS possible to use ADO
FROM the VBA code of an MDB (or MDE) to connect to a table in an SQL
Database on a remote web server, using an HTTP URL as a connection
string -- correct?
Close, but not quite right. If you are connecting directly to the remote
server db (SQL Server or MySQL) then you can do so using the appropriate
connection string. This will NOT be a HTTP URL. For a list of all
possible connection strings (or at the very least all of the meaningful
ones) take a look at: http://www.carlprothman.net/Default.aspx?tabid=81
From this fantastic resource (adjust to your specifics):
ODBC Driver for MySQL (via MyODBC)
To connect to a remote database
oConn.Open "Driver={mySQL};" & _
"Server=db1.database.com;" & _
"Port=3306;" & _
"Option=131072;" & _
"Stmt=;" & _
"Database=mydb;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
HTH
--
Bri
Lauren Wilson <no****@nospam.com> wrote in
news:r4********************************@4ax.com: On Sun, 19 Mar 2006 14:31:13 -0600, "David W. Fenton"
<XX*******@dfenton.com.invalid> wrote:
Lauren Wilson <no****@nospam.com> wrote in
news:9o********************************@4ax.co m:
On Sat, 18 Mar 2006 14:33:09 -0600, "David W. Fenton"
<XX*******@dfenton.com.invalid> wrote:Is running SQL Server or some other server db on the web server
not a possibility?
It is. I would rather do it with SQL Server, or MySQL. It
appears that a DAP can connect to a remote SQL Server database.
. . .
I'm confused. An MDB can connect to a remote SQL Server database,
so why would you implement a DAP just to get to the remote SQL
Server database?
OK, to get us in sync: Until about 36 hours ago, I was
CONSIDERING whether or not a DAP could be used for something that
I THOUGHT was not possible without it. Either I misread earlier
posts or there is disagreement about the issue among those who
posted responses.
Bottom line: You appear to be saying that it IS possible to use
ADO FROM the VBA code of an MDB (or MDE) to connect to a table in
an SQL Database on a remote web server, using an HTTP URL as a
connection string -- correct?
No. Not HTTP -- a direct connection to the SQL Server port.
Until you reminded me that this might be possible, I first looked
for a way to do it with an MDB on the web server. Since I have
access to several web servers running either MS SQL Server OR
MySQL, I've simply switched my focus to doing it that way.
Well, I was not suggesting HTTP -- Access's capabilities in that
regard have already been completely defined in this thread. A
different back end on the server does not change that.
The only thing a server database changes is that there's a process
running on the server to connect to, which is not the case with an
MDB. If the ISP can't open up the SQL Server port, or provide a VPN
connection, then this won't work, either.
But Lyle has frequently posted about the ISPs that provide this kind
of service. I have no dealings with any of them, since I will never
buy web hosting from a Windows-based ISP, since I consider it
substandard.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: N3TB1N |
last post by:
Here is my assignment. I am hoping that someone here quickly knows
all of the correct answers... especially for question #5 and
everything after. Thanks in advance.
...
|
by: Suyog_Linux |
last post by:
I wish to know how the free()function knows how much memory to be
freed as we only give pointer to allocated memory as an argument to
free(). Does system use an internal variable to store allocated...
|
by: Mike Wengler |
last post by:
I inherited some code from a former employee, who was unable to cut the
umbilical cord from VB6. His code is littered with calls to VB6 functions
like Space(), String(), Left(), Mid(), Right(),...
|
by: Zorpiedoman |
last post by:
Ok....
1. Take a windows form.
2. Add a TabControl
3. Add a TabPage by right-clicking the Tabcontrol and selecting "Add Tab"
The TabPage is actually added to the form, not just visually,...
|
by: James Dow Allen |
last post by:
The gcc compiler treats malloc() specially! I have no
particular question, but it might be fun to hear from
anyone who knows about gcc's special behavior.
Some may find this post interesting;...
|
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...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
