By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,695 Members | 1,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,695 IT Pros & Developers. It's quick & easy.

Send single record Access DB on remote web server.

P: n/a
Our orders database exists inside our firewall but we have a web site hosted
on an ISP server. If we wanted to give users the ability to query the
status of their order in real time, we could just export a simple subset of
data to our ISP, like customer name, order ID and status.

Anyone ever do this?

For example, if the status changed from REQUEST to QUOTE or from QUOTE to
PRODUCTION, the AfterUpdate event of the Access application running behind
the firewall would need to send that new information to the ISP.

What I'm thinking is that there could be a page at the web site for
processing the data, that would have an address like this ...

http://www.myISP.com/CustData/update...23456&status=9

The ASP page on the remote, ISP server could process this and update the
status for this order, but how can I, from my Access client application
"navigate" to this address? ... that is to say, pass these simple
parameters to the ASP page on the web server that will update my remote
database, keeping it in synch with my master orders database?

As usual, any suggestions appreciated. (Do I need to mention that the
suggestions should be relevant and not along the lines of my getting a hair
cut or losing weight? For that kind of advice, I have a wife.) Thanks
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast


Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
OK, here's what I stumbled upon, but I don't completely like it. There is a
library called Microsoft Internet Controls that points to SHDocVw.dll
This library exposes an InternetExplorer object which has a Navigate method.
The following code works, but only if I supply a pause between the Navigate
method and the line that sets the object to nothing.

I'm running this code from a module function in an Access 97 database:

Function Foo()
Dim objDoc As SHDocVw.InternetExplorer
Set objDoc = New SHDocVw.InternetExplorer

Dim sURL As String
sURL = "http://mysite/ProjectList.asp?OrderID=42&status=9"

objDoc.Navigate sURL, , , True

' must pause here
Set objDoc = Nothing
End Function

Has anyone used this method? Are there any dangers to using it? I have
this library, but should I expect that my local network users have it too?
--

Danny J. Lesandrini

"Danny J. Lesandrini" <dl*********@hotmail.com> wrote in message
news:bq*************@ID-82595.news.uni-berlin.de...
Our orders database exists inside our firewall but we have a web site hosted on an ISP server. If we wanted to give users the ability to query the
status of their order in real time, we could just export a simple subset of data to our ISP, like customer name, order ID and status.

Anyone ever do this?

For example, if the status changed from REQUEST to QUOTE or from QUOTE to
PRODUCTION, the AfterUpdate event of the Access application running behind
the firewall would need to send that new information to the ISP.

What I'm thinking is that there could be a page at the web site for
processing the data, that would have an address like this ...

http://www.myISP.com/CustData/update...23456&status=9

The ASP page on the remote, ISP server could process this and update the
status for this order, but how can I, from my Access client application
"navigate" to this address? ... that is to say, pass these simple
parameters to the ASP page on the web server that will update my remote
database, keeping it in synch with my master orders database?

As usual, any suggestions appreciated. (Do I need to mention that the
suggestions should be relevant and not along the lines of my getting a hair cut or losing weight? For that kind of advice, I have a wife.) Thanks
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast

Nov 12 '05 #2

P: n/a
Hi Danny

I have an application that is part ASP-HTML etc, and part ADP.
To ensure that help is consistent, from the ADP I call the ASP-HTML Help
Files by having a Web Control
(OLEClass ="Microsoft Web Browser"
Class ="Shell.Explorer.2"
GUID = Begin
0x0d8ea426b2beae4e8fc7f771a6c349b1
End
)
on a Help Form and setting its navigate as follows:

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyF1 Then
Form_frmHTMLHelp.wbHDSBHelp.navigate
"http://ffdba.com/SomeFolder/SomeSubFolder/SomeFile.htm"
KeyCode = 0
End If
End Sub

The Help Form then runs its own code on open.
Private Sub Form_Open(Cancel As Integer)
Me.wbHDSBHelp.Width = 480
PlaceForm Me
End Sub

I'm not sure if this could be adopted for your needs, but I find it quite
helpful for my purposes.

"Danny J. Lesandrini" <dl*********@hotmail.com> wrote in message
news:bq*************@ID-82595.news.uni-berlin.de...
OK, here's what I stumbled upon, but I don't completely like it. There is a library called Microsoft Internet Controls that points to SHDocVw.dll
This library exposes an InternetExplorer object which has a Navigate method. The following code works, but only if I supply a pause between the Navigate method and the line that sets the object to nothing.

I'm running this code from a module function in an Access 97 database:

Function Foo()
Dim objDoc As SHDocVw.InternetExplorer
Set objDoc = New SHDocVw.InternetExplorer

Dim sURL As String
sURL = "http://mysite/ProjectList.asp?OrderID=42&status=9"

objDoc.Navigate sURL, , , True

' must pause here
Set objDoc = Nothing
End Function

Has anyone used this method? Are there any dangers to using it? I have
this library, but should I expect that my local network users have it too?
--

Danny J. Lesandrini

"Danny J. Lesandrini" <dl*********@hotmail.com> wrote in message
news:bq*************@ID-82595.news.uni-berlin.de...
Our orders database exists inside our firewall but we have a web site

hosted
on an ISP server. If we wanted to give users the ability to query the
status of their order in real time, we could just export a simple subset

of
data to our ISP, like customer name, order ID and status.

Anyone ever do this?

For example, if the status changed from REQUEST to QUOTE or from QUOTE to PRODUCTION, the AfterUpdate event of the Access application running behind the firewall would need to send that new information to the ISP.

What I'm thinking is that there could be a page at the web site for
processing the data, that would have an address like this ...

http://www.myISP.com/CustData/update...23456&status=9

The ASP page on the remote, ISP server could process this and update the
status for this order, but how can I, from my Access client application
"navigate" to this address? ... that is to say, pass these simple
parameters to the ASP page on the web server that will update my remote
database, keeping it in synch with my master orders database?

As usual, any suggestions appreciated. (Do I need to mention that the
suggestions should be relevant and not along the lines of my getting a

hair
cut or losing weight? For that kind of advice, I have a wife.) Thanks
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.