When I try to run frmContactsBound I get a message box that says Run-time error' -2147467259 (80004005)': Could not "; file already in use. I don't what this means and i don't know what i should do.

Me too! I have replaced the code with the Wrox code, to no avail. Setting break points and using the Immediate Window, all is well until I get to the chCh5.Open strConnection line in Private Sub Form_Load(). There are no .ldb files showing using the Search feature. Please help.

Yep, I've tried these suggestions and have tried a few of my own half-brained tricks to no avail. An un-documented de-bugging challenge??

Frustrating, as the book is really very well written and set-up.

Yep, me too.

I think the error arises once you've loaded the form, as the debugger stops at the line:-

      cnCh5.Open strConnection

as (I think) the connection is already open ?

Also, I found that I couln't add or amend records to the table using the form as "This Recordset is not updatable". You might also get the message that Access has locked the table. I tried changing the LockType property on the rcordset to adLockPessimistic but still had the same problem.

Glad it's not just me!

Phil

Hmmm...thinking about this one further

I downloaded Gosnell's code and ran that and it worked fine but her mdb was in 2002-2003 format and mine was in 2000 format

Does anyone know how this might make the difference?

Switched to Access 2003 and it worked!

<{{>><