hey would any one help me to write code access my msaccress2000 database located at webserver on www.lips-club.com for view insert update delete data from with in visual basic using gui as input for
dim conn as ADODB.Connection
dim rs as recordset
Conn.Open "...", "...", "..."
' ^DSN ^User ^Password
Set RS = Conn.Execute( "SELECT * FROM theTable" )
do while not rs.eof
msgbox RS(i).Value<% Next %>
rs.movenext
loop