Hi to everyone,
I have a crazy error, running Access 2003 (Jet 4.0) on Windows XP. on a module, I open 13092 times a Report (with command OpenReport). At 13093rd time, Application goes on error 3011 "The Microsoft Jet Database engine could not find the Object ''. Make sure...".
Here the "crazy" code:
Public Function start() As Integer
Dim count As Long
Dim report As Variant
report = "prova" ' this is a simple report with only one fix text
Do
count = count + 1
If count > 20000 Then
Exit Do
End If
Open "C:\log.txt" For Append As #78 ' this i a log file
Print #78, count, report
Close #78
Application.DoCmd.OpenReport report, acNormal
Loop
End Function
can someone tell me why this happens ??
thanks and ciao
ANDY
I have a crazy error, running Access 2003 (Jet 4.0) on Windows XP. on a module, I open 13092 times a Report (with command OpenReport). At 13093rd time, Application goes on error 3011 "The Microsoft Jet Database engine could not find the Object ''. Make sure...".
Here the "crazy" code:
Public Function start() As Integer
Dim count As Long
Dim report As Variant
report = "prova" ' this is a simple report with only one fix text
Do
count = count + 1
If count > 20000 Then
Exit Do
End If
Open "C:\log.txt" For Append As #78 ' this i a log file
Print #78, count, report
Close #78
Application.DoCmd.OpenReport report, acNormal
Loop
End Function
can someone tell me why this happens ??
thanks and ciao
ANDY