hi friends
I am facing problems generating a query from access database.
I have a form which fills all the records, validates and then send the
collected info to the db.
Now the problem part, I need to chk or validate the current records by
the ID number which is unique and is not to be duplicated.
So i am trying to generate a query by select statement, no go
then i saw this type of database dsnless connection..
set rs = Server.CreateObject("ADODB.recordset")
rs.open "Customers", conn
' Method 1
rs.addnew "FirstName", "Rich"
' Method 2
rs.AddNew Array("FirstName", "LastName"), Array("Rich","Smith)
' Method 3
myFieldList = Array("FirstName", "LastName")
myValueList = Array("Rich", "Smith")
rs.AddNew myFieldList, myValueList
rs.close
set rs = nothing
conn.close
set conn = nothing
My question ????
can we do it with msaccess database and whether do we need to have some
extra configurations configured at my ISP's end ?
2nd...
how do I validate the current records by the ID number which is unique
and is not to be duplicated.(being taken from the user which filling
the form)
thanks