Results 1 to 3 of 3

Thread: Access

  1. #1
    sean Guest

    Default Access

    How do i get information from a form in HTML into an access database and keep the info in there so that my boss can go in access and look at the updated database whenever he wants? i can extract info. from databases using ASP but don&#039t know how to get the info in there?? please help?!!!

  2. #2
    Jason Miller Guest

    Default RE: Access

    objConn.execute "insert into TABLENAME (colName1, colName2, colName3, etc) values (&#039request.form(value1)&#039, &#039request.form(value2)&#039, &#039request.form(value3)&#039, etc);"<BR><BR>1) I didn&#039t put in all of the " & & "s around the variables. You&#039re on the advanced board, you&#039re bright enough to do it yourself.<BR>2) objConn is connected.<BR>3) You&#039ll probably want to filter the form data for things like &#039 and remember that saving date/time info is easier with a # instead of a &#039 delimiter.

  3. #3
    sean Guest

    Default RE: Access

    Thanks for the info but can anyone post the KISS code for it or provide a link so I can see how to do this better? thanks in advance... i was told that only sql could do this and am glad I can get around using it (for now)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts