I have a scheduled event that occurs once per day. It executes the following code:<br><br><cfoutput><br><cfloop query=GetStatusData><br><CFSET nWeek = #DateDiff("WW", Start_Date, Now())# + 1><br><CFQUERY DATASOURCE="AFSM_GeneralArchive"><br>INSERT INTO StatusSnapshot_tbl (SnapshotDate, Plant, nweek, status, statusdate)<br>Values '#szDate#', '#Plant#', '#nWeek#', <br>'#Status#', '#Status_Date#') <br></cfquery><br></cfloop><br></cfoutput><br><br>After this event occurs, the AFSM_GeneralArchive table stays locked. (.ldb file exists). Any Ideas??<br><br> Thanks,<br> Dave Joyce<br><br>
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 database locking after scheduled event
- Thread starter davejoyce
- Start date
Similar threads
- Locked
- Question