Emptying a table

Results 1 to 2 of 2

Thread: Emptying a table

  1. #1
    Join Date
    Dec 1969

    Default Emptying a table

    I try to delete all the data in a MS Access file using ASP but nothing work...anyone know how to do it..thanx<BR><BR>Set ExpEquipes = Server.CreateObject("ADODB.Recordset")<BR>strSQL = "Delete Tbl_ExpEquipes.* FROM Tbl_ExpEquipes;"<BR>ExpEquipes.Open strSQL, adoCon<BR>ExpEquipes.Close

  2. #2
    Join Date
    Dec 1969

    Default RE: Emptying a table

    Wrong syntax:<BR><BR>&#060;%<BR>Dim objConn<BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR>objConn .Open adoCon &#039; Assumes this is a connection string, not an object.<BR>objConn.Execute("DELETE FROM Tbl_ExpEquipes")<BR>objConn.Close<BR>Set objConn = Nothing<BR>%&#062;<BR><BR>Craig.

Posting Permissions

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