How should I work with Connect and Disconnect? Should I keep my connection as short as possible, like:
do some thing to database
Or is it ok to have the database connectio lying around the business process so that other parts of the process can use the connecion?
When I’m connected to a database (backend: MS Access), does that mean I’m locking the database while I’m holding the connection. Like, nobody else can access the db while I’m using it? Or could the database be updated by another program while I maintain my connection?