Insert records from web form (asp page) to Access db and display records from db in descending order
Posted on 2004-04-17
I have a web form (ASP page) that inserts the user’s input into an access database. I have as many numbers of columns in the table as there are fields in the form. Once entries are made, I display the records on another ASP page. I would like to display the entries/records made in descending order. That is the last entry made first and so on. However, when I try to add another column with auto-number to the table, the form does not work and gives me an error “Number of query values and destination fields are not the same” when I try to submit the form.
Can anyone help please? Much appreciated. Thanks ggd.