I am getting a file sharing lock count exceeded error.
I am trying to delete a lot of rows from a table, about 18000 rows.
lsSQL = "Delete from " & lsTblName & " " & lsWhereClause
CnAccess.Execute lsSQL, lnRecsAffected
Does anyone know why this would happen or if there is away for me to delete such large amounts of data?




Reply With Quote