Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access-Vb6 Connectivity
- Thread starter Omkar158
- Start date
ChiHappens
Programmer
try using a connection instead of a recordset:
Set CN = CreateObject("ADODB.Connection"
CN.Open ConnectionString ' Where ConnectionString is your connection string
SQL = "DELETE FROM MyTable WHERE MyField='Delete Me'"
CN.Execute SQL
CN.Close
Set CN = Nothing
Set CN = CreateObject("ADODB.Connection"
CN.Open ConnectionString ' Where ConnectionString is your connection string
SQL = "DELETE FROM MyTable WHERE MyField='Delete Me'"
CN.Execute SQL
CN.Close
Set CN = Nothing
- Status
