O.k. guys/gals ADO experts. I'm trying to get into VB6 ADO databasing. I'm from the old school and I want all the database commands to work through all the formS included in the Project.
I've been told to just create the ADO Data Control (in the startup form)and I have. BUT (there always is, isn't there !) then I can't use AddNew /Find /FindNext and a couple of others. AND it only works if I keep re-creating the control on each subsequent form, no universal method I can see.
Then I've been told to use [Dim cnn as ADODB.Connection] and all the code that goes with this method (and there is a LOT). It then produces a connection to the database but has no AddNew/Edit and I haven't checked others. AND it only works in the immediate form, also.
Lastly I read VB6Database for Dummies and found that they recommended I use Set rsCCF = OpenDatabase(mPath+"CCFile") and all the code they attached to that (this doesn't seem to be an ADO Connection). This worked (partially : I had AddNew and Edit but no Find or others, but nowhere in this code is ADO mentioned) in one application. But (there always is, again) when I tried to duplicate it in another I got error messages and no amount of work has gotten rid of the messages (i.e.- Dim CCFile as Database = User defined function, undefined).
HHHHHHHHEEEEEEEEEEELLLLLPPPPP!!!!!!!
I'm lost :
Question is basically :
Is there a way to make a connection to the database (ADO if possible) that is good for all the forms in my Project and that allows me to perform ALL the database operations (like : AddNew/Edit/Find/FindNext/Move/MoveLast,First,Etc.
Are any of the above three the proper method or a combination of them ????? I'd REALLY APPRECIATE any HELP - particularly if you can keep it simple (for the simple minded!).
Mike
