I have been trying to bind forms to ADO recordsets the way the book "Beginning Access 2002 VBA" shows.
I have an application that potentially run much faster if I could figure out how to bind the ADO recordset to my forms. I was asked to port the application over to a new LAN running Windows XP on the desktop, NT on the server, and MS-Office 2000.
I tried the examples on page 930 (bombs at the "Set Me.Recordset = rs" line); page 921 (gets err nbr 7965 at the "Set Me.Recordset = rs" line; the example on 919 did retrieve the records into my (continuous) form , BUT, [u]the records cannot be edited</u> (status bar says record is "READ ONLY").
This same form bound to a saved Access query ran fine when the application was on my old LAN. I reference the "Microsoft ActiveX Data Objects 2.7" library in the VBE.
Could this be the problem? Any ideas what I might be doing wrong?