http://people.ne.mediaone.net/lmhansen/index.html
other snippets on how to connect access to the web.
http://www.mvps.org/access/modules/mdl0052.htm
http://www.mvps.org/access/modules/mdl0037.htm
note –
‘*********** Code Start *************
Sub TestHTTP()
On Error GoTo ErrHandler
Dim objHTTP As InetTransferLib.HTTP
Const conTARGET = “http://www.mvps.org/access/acknowledge.htm”
Set objHTTP = New InetTransferLib.HTTP
With objHTTP
.About
.HttpURL = conTARGET
‘.DestinationFile = “j:temptest.htm”
.PromptWithCommonDialog = True
If .FileExists Then .OverwriteTarget = True
If Not .IsConnected Then .DialDefaultNumber
.ConnectToHTTPHost
.WriteHTTPDataToFile
End With
ExitHere:
On Error Resume Next
Set objHTTP = Nothing
Call SysCmd(acSysCmdRemoveMeter)
Exit Sub
ErrHandler:
MsgBox Err.Number & vbCrLf & Err.Description, vbCritical + vbOKOnly, Err.Source
Resume ExitHere
End Sub
‘*********** Code End *************
as an example.
from – http://www.princeton.edu/~hannahk/WebPubl.htm
How do I create a procedure to add data to my database?
This is much more difficult and requires creating an idc (Internet Database Connector) file.
Design an Access 97 database or use an existing database
Use the Save as HTML option under the File menu. This starts the Publish to the Web wizard.
Select a table, query, or form to use as the basis of your report.
Choose the Dynamic HTX/IDC option
Provide the Data Source Name. This is the name that the Web server uses to identify your database.
Save your database htm/idc/htx files to a directory on your hard disk. Modify the htm/idc/htx files that are created with a text editor such as WordPad or a Web authoring tool such as Claris HomePage.
Move your database file (.mdb) and the htm/idc/htx files to a Novell directory. You will need to create a special subdirectory and register it with the Web server administrator.
Demo of adding data to the Student Jobs database. The URL is
http://winweb.princeton.edu/dbwtest/hpajb.htm
