que hago mal?????
Publicado por JCarles (17 intervenciones) el 08/02/2007 22:23:21
Private Sub mnuFileExit_Click()
On Error Resume Next
Dim ws As Workspace
Dim db As Database
Dim rs As Recordset
For Each ws In Workspaces
For Each db In ws.Databases
For Each rs In db.Recordsets
rs.Close
Set rs = Nothing
Next
db.Close
Set db = Nothing
Next
ws.Close
Set ws = Nothing
Next
sbStatusBar.SimpleText = " Compactan"
DBEngine.CompactDatabase "telefonos97.mdb", _
"telefonos97CO.mdb"
Kill "telefonos97.mdb"
Name "telefonos97CO.mdb" As "telefonos97.mdb"
Unload Me
End Sub
Si quito los For Each...Next me sale "Error 3356 ..."
On Error Resume Next
Dim ws As Workspace
Dim db As Database
Dim rs As Recordset
For Each ws In Workspaces
For Each db In ws.Databases
For Each rs In db.Recordsets
rs.Close
Set rs = Nothing
Next
db.Close
Set db = Nothing
Next
ws.Close
Set ws = Nothing
Next
sbStatusBar.SimpleText = " Compactan"
DBEngine.CompactDatabase "telefonos97.mdb", _
"telefonos97CO.mdb"
Kill "telefonos97.mdb"
Name "telefonos97CO.mdb" As "telefonos97.mdb"
Unload Me
End Sub
Si quito los For Each...Next me sale "Error 3356 ..."
Valora esta pregunta


0