Printable View
I am a bit confused on this matter, ATM I link my DB from the properties form and go that route
:confused: Would it be better to Load and unload by code rather than do it on the menu. Will using it by properties menu cause problems later if I get a bit technical in my coding?VB 6.0
Thanks
Re: When should i open and close database
--------------------------------------------------------------------------------
Quote:
Originally Posted by sajankk
my doubt is whether i should close the database in each operation or i can open the databse in the form load and close in the form unload.
Answer By Hack:
Yes, this is the way to go. Open it when the program starts, and close it when the program is existed. While the program is running, your database should remain open.
This poses a question , Does linking with properties open and close for me or does it just stay open?
Are you referring to a connection of the database?
Yes, whether it is better to connect by means of setting in the properties or just doing it all by code? the setting wich DB and opening and closeing
Please read Database Problems in my signature for some assistance.
The connection object is required througout the life of the application. So it should be opened on the first form load and then closed only at the end of the application.
From your explanation I guess you are using Data Controls (ADODC or similar), in which case I can happily say get rid of them and never go back.
They are restrictive at best, and can cause nightmares. I haven't checked, but I would be willing to bet that that none of our members who have written serious database applications use them - as code leaves you in control of what is going on.
It takes a little bit of extra work to use code, but (IMO) the benefits outweigh this hugely.
If you want to see an example of connecting purely by code, check out the ADO Tutorial in my signature.
Yes I have a long way to go lol But I will take your word for it
and try to do all I can with code rather than controlls
thanks again