You are currently viewing the BOOK: Beginning Access 2003 VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
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.
I think the error arises once you've loaded the form, as the debugger stops at the line:-
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.