After typing in the code for the first example in Ch. 5, I ran it successfully, but now I get a "Run-time error '-2147467259 (80004005)' Could not use "; File already in use" message. What's wrong???

0-7645-5659-2
Beginning Access 2003 VBA

Barely here:
Mona
Encinitas, CA

__________________
Barely here:
Mona
Encinitas, CA

I don't know the 'why', but I seem to have gotten around it by adding an error trapper:

On Error GoTo HandleError

(code, code, code)

HandleError:
    If Err.Number = "80004005" Then
        cnCh5.Cancel
        MsgBox "Error 80004005 thrown and trapped."
    End If

Oddly, my MsgBox doesn't pop on this one...but at least the stupid error is gotten around. I had lots of trouble getting

Etc, based on Ms. Gosnell's p71, etc