I have a working Access 2000 application I want to convert into an executable using VB6.0. My Operating System is Windows 2000 and my VB comes from Visual Studio 6 w/SP-3 installed. I want Version 1.1 of my project named ?BNM? to link to an Accessback-end employing Microsoft?s DAO 3.6 Object Library. I don?t want to build this executable with the Access Developers Toolkit ? I need to learn pure VB and want to it managing objects I understand.
I am having trouble declaring and loading thelink to BNM.mdb (my Microsoft Access 2000 application containing the tables, queries, forms, reports, and modules) into my VB Project named BNM. I have created a ?BNM? directory on my C:\ drive where I store BNM.mdb (C:\DataByte\BNM\BNM.mdb) and the Visual Basic Project (C:\DataByte\BNM\BNM.vbp).
I installed the Microsoft DAO 3.6 Object Library (via Project | References) and renamed Form1 to ?frmDesktop?. My new VB Project hierarchy reads ?BNM(BNM.vbp)? and it has a Forms collection containing ?frmDesktop(Desktop.frm)?.
Where do I declare and place the code:
Dim db As Database
Set db = OpenDatabase(?C:\DataByte\BNM\BNM.mdb?)
I need one or more of my 12-15 tables available to every object I create within the BNM Visual Basic 6 project so I can write unique query (OpenRecordset) to each form?s load event?
What is my next step to be able to see (and manage) my Access database objects within the VB environment on my forms or through the Object Browser?
How do I efficiently convert my Access Forms to VB Forms (without re-constructing everything)?