I have a working code for inserting a new record in to my access database.
Set Cnn = Server.CreateObject("ADODB.Connection")
Cnn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=C:\mydatabase.mdb"
SQL = "INSERT INTO mytable (name) VALUES('"& Name &"')"
set Cnn = nothing
What is the SQL and syntax for returning the total number of records from mytable? Please give me a complete working code.