Create a web fronend to an access backend

[t1hodges]

I Need to create a web page that allows users to first log in, then second add, edit, and delete records in an access database. there will be aprox. five users on a LAN.

 

[fneily]

If they're on a LAN, why do you need a web page? Just place the database on a shared drive and create a login form.
From your question, do you want me to just hand you a DAP or do you have a specific question in creating a DAP to login and a DAP to edit and add records?
Any elementary Access book shows you how to create a DAP.
You'll also have to learn a little VBScript to make web pages communicate.
For a login, you can set up a form with a textbox (my is called EmployeeID) and then use some VBScript like this: (if he logins correctly, a hyperlink to the next web page appears)

<SCRIPT language=vbscript event=onchange for=EmployeeID>
<!--
Set rs = CreateObject("ADODB.Recordset")
sqlSelect = _
"SELECT * FROM LogonInfo WHERE EmployID = '" & EmployeeID.value & "'"
rs.Open sqlSelect, MSODSC.Connection
If rs.EOF Then
EmployeeID.value = "(Access Denied)"
Else
holdID = document.all.item("EmployeeID").value
EmployeeID.value = "(You May Edit)"
Hyperlink0.style.visibility = "visible"
End If
rs.Close
Set rs = Nothing
-->
</SCRIPT>