Erasing Access tables and more!

Results 1 to 2 of 2

Thread: Erasing Access tables and more!

  1. #1
    Michael W. Guest

    Default Erasing Access tables and more!

    Howdy!<BR><BR>This is a tough one and any help would greatly be appriciated. My client would like me to put together an interface where a user fills out a form and the results go into an Access database. Okay, that&#039;s no problem. Now, he wants (at any time), to go and download the information in an access database, and then have the datatbase residing on the server to clear out all the information, so the next time he does it, it will have only new information. Any ideas on how to accomplish this? Thanks in advance!

  2. #2
    testy Guest

    Default RE: Erasing Access tables and more!

    "DELETE from mInTable WHERE " & mField & "=&#039;" & mRecID & "&#039;"<BR><BR>"Insert Into mInTable (" & IFields & ") Values (" & IValues & ")"

Posting Permissions

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