Connections ans opinions

[checoturco]

Hi list,
I need you help or you opinions and ideias.

All the code that i have in vba was building inside Access; now i wanna migrate the code to vb but continue use my BD.
My questions are:

I have a module that have a variable for db ( dim db as database) and in all forms i have set db=currentDb.

Now i have to have a code to make a connection to Db and i think that i must buid a function to be called in onload event of each form.

What happens to all recordsets that i have used in my code? i have to change something?

What happens to macros,query's,reports that i have? i have to change the code to use again?


if somebody could help with some opinions or point me to some links with this information i appreciate.


checo

 

[Sergeant]

IF you are talking about a VB application, you probably need to build from scratch. As far as I know, your queries and tables are all that you can reach through ADO.
Much of your code in VBA can be copied into the VB app, but you will have to tweek it for its new environment. You will have to make ADO connection(s) for each time you need to get/add data.