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
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.