Bug #2857
closedExtra message box displayed "About to update 1 row" on startup
0%
Description
This happens when confirmations are not yet up. To fix:
Public Function configureCancelBackupOnCloseFields(blnBackup As Boolean)
On Error Resume Next
'updates the option to not backup (or to allow backups) when database is closed
'useful to turn this off if compacting db or if backing up now
Dim rstTemp As New ADODB.Recordset
rstTemp.Open "SEKLECT * FROM backupOptions;", CurrentProject.Connection, adOpenForwardOnly, adLockOptimistic, adCmdText
If Not rstTemp.EOF Then
rstTemp!doNotBackupOnCloseOnce = Not blnBackup
rstTemp.Update
End If
rstTemp.Close
End Function
Updated by Michael Lee over 17 years ago
also can be resolved by moving backupOnClose function below confirmation settings change. Needs test.
Updated by Michael Lee over 17 years ago
fixed v210p7
Access 2000 issues also largely resolved (at least ones that I know about there): listBox source being too large on errorReportingPopup (substitude for a text box)