For work, feel free to ignore.

https://i0.wp.com/www.princeton.edu/~hannahk/web2.gif?w=474

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

Related Posts

  • 9653- WednesdayMarch 18, 2009 9653- Wednesday Bro's girlfriend / possible mother to his kid Shannon has been found, and she and her […]
  • 9638 – Thursday – repairing internet connection on the eeeMarch 5, 2009 9638 – Thursday – repairing internet connection on the eee See entry comments for mysql code snips in use. Saving on j:/uiia/qmysql/ --"modem […]
  • Wednesday – 9396 –August 13, 2008 Wednesday – 9396 – I officially know more about Rsync than I ever thought I would. It's a mighty handy […]
  • 9335 – ThursJune 26, 2008 9335 – Thurs That Meme - Post 3 things you've done in your lifetime that you don't think anybody else […]
  • 9268 – Sunday –May 4, 2008 9268 – Sunday – Bagel, cream cheese, strawberries and pineapple for breakfast - BHK and I slowly worked […]

Leave a Reply