DAP and ADP questions

[rjoshi2]

How are Data Access Pages (DAP) and Access Data Pages (ADP) different? Is there a befit for using one or the other? Which one should I use if I am trying to simulate an access form that that will only show information base on a username (login). I am also using workgroup security on my database. How will this affect the DAP or ADP (login)? Any help would be appreciated.

Thank You,
rjoshi2

VBA code that I would like to sumulate in the ADP or DAP:

Option Compare Database
Option Explicit

Private Sub Form_Load()
Dim getdata As String

MsgBox ("Hello: " & CurrentUser & "!&quot

getdata = "Select * from FY03COMREG where " & _
"FY03COMREG.[User ID] = '" & CurrentUser & "'"
Me.RecordSource = getdata
Me.Requery

End Sub

Private Sub OCB_AfterUpdate()
User_ID = CurrentUser
MsgBox ("User ID: " & Me.User_ID)
End Sub

 

[vbajock]

ADP's are for building SQL server front ends
Data Access Pages are for publishing Access objects on the Internet.