Member Avatar for tirtha87

Guys, I'm in a bit problem & need help...

My problem is:
In my project I've several forms (almost 30) and 1 MDI form. Now when I'm connecting to the database (MS Access) I want when the MDI form will be opened the database will b connected & as soon I close the MDI it will be disconnected. Otherwise for database connectivity I've to write the code for every form .
Do I have to take a module??
Plz suggest what should b the best approach to it.

  • 2 Contributors
  • 1 Reply
  • 85 Views
  • 19 Hours Discussion Span
  • Latest Post Latest Post by vb5prgrmr
Member Avatar for vb5prgrmr

Yes, a module with public declared variables would be the easiest bet. Then in form load open the database and in form unload close the database.


Good Luck

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.