T
tw
I'm using code to compact/repair a database
data passed as parameters into the function that does the work strsource and
strdestination as seen from the immediate windowprior to running code
?strsource
C:\disco modifications\Disco 2 Back End.mdb
?strdestination
C:\disco modifications\DiscoCompactRepairTemp
Everything seems to go OK without errors, but the log file created has this
message in it
"Modules Container: 'PropDataCopy' stream has a length of zero!"
Can anyone tell me what this means?
Function below
Function RepairDatabase(strSource As String, _
strDestination As String) As Boolean
' Input values: the paths and file names of
' the source and destination files.
' Trap for errors.
On Error GoTo error_handler
' Compact and repair the database. Use the return value of
' the CompactRepair method to determine if the file was
' successfully compacted.
RepairDatabase = _
Application.CompactRepair( _
LogFile:=True, _
SourceFile:=strSource, _
DestinationFile:=strDestination)
' Reset the error trap and exit the function.
On Error GoTo 0
Exit Function
' Return False if an error occurs.
error_handler:
RepairDatabase = False
End Function
data passed as parameters into the function that does the work strsource and
strdestination as seen from the immediate windowprior to running code
?strsource
C:\disco modifications\Disco 2 Back End.mdb
?strdestination
C:\disco modifications\DiscoCompactRepairTemp
Everything seems to go OK without errors, but the log file created has this
message in it
"Modules Container: 'PropDataCopy' stream has a length of zero!"
Can anyone tell me what this means?
Function below
Function RepairDatabase(strSource As String, _
strDestination As String) As Boolean
' Input values: the paths and file names of
' the source and destination files.
' Trap for errors.
On Error GoTo error_handler
' Compact and repair the database. Use the return value of
' the CompactRepair method to determine if the file was
' successfully compacted.
RepairDatabase = _
Application.CompactRepair( _
LogFile:=True, _
SourceFile:=strSource, _
DestinationFile:=strDestination)
' Reset the error trap and exit the function.
On Error GoTo 0
Exit Function
' Return False if an error occurs.
error_handler:
RepairDatabase = False
End Function