Hi all,
When connecting to an Access database from a VB front end usig the ADO control is there any problem caused by the connection being permanently open or am I better to open and close the connection for each transaction.
Will there be any difference for a mySQL database.
To start with there will only be 2 or 3 users accessing the database at any time but that could go up to 20-30 in the future.
Thanks for any replies,
Cheers for now:-/
lostandfound
10
Junior Poster in Training
Recommended Answers
Jump to PostIt is always bettter to open and close the connection in the application itself.
All 2 Replies
debasisdas
580
Posting Genius
Featured Poster
It is always bettter to open and close the connection in the application itself.
lostandfound
10
Junior Poster in Training
Yes , that is not quite what I was asking.
Is there any problem with keeping the connection open for as long as the application is running or should I only open and close the connection each time the database is being accessed.
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.