Closing the connection of an .accdb file when it is no longer needed

I have an Access database with the front-end running locally and the back-end on the server.  My main form has several combo boxes, each of which is populated through a single table.  This table is linked to a separate Access database (called TSCS.accdb), which is held locally.  Pretty much everything works fine (including distributing updates etc.).  

The problem is, that the moment I select an item from a combo box, it opens up TSCS.accdb and populates the list (quite correctly).  However, this action also keeps TSCS.accdb open, even when I move to another record, and change fields.  I understand why this happens, but in this specific instance, I need it to close connection as soon as the combo box loses focus.  

Is there any way that I can close this connection without closing the form?
Andy BrownDeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Anders Ebro (Microsoft MVP)Microsoft DeveloperCommented:
Not unless you want to load the combo through code. You could either: Load all combo items in code, or load data from the external database into a local table, and bind the combo to that.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Andy BrownDeveloperAuthor Commented:
I had a feeling someone was going to say that.

Thanks for coming back so quickly.
PatHartmanCommented:
Why do you need to close the connection?
SolarWinds® VoIP and Network Quality Manager(VNQM)

WAN and VoIP monitoring tools that can help with troubleshooting via an intuitive web interface. Review quality of service data, including jitter, latency, packet loss, and MOS. Troubleshoot call performance and correlate call issues with WAN performance for Cisco and Avaya calls

Andy BrownDeveloperAuthor Commented:
Hi Pat,

I need to overwrite TSCS.accdb, as users switch from one database/project to another (each with its own TSCS database).
PatHartmanCommented:
Each user needs to have his own personal copy of the FE.  Users should NEVER share a single copy of the FE.  The FE contains the forms/reports/queries/code.  The BE contains ONLY tables.  The FE on each user's local drive links to the shared BE on a network drive.

Given that, if you want each user to link to a separate BE, there should never be a conflict and therefore no need to close a connection.
Andy BrownDeveloperAuthor Commented:
Hi Pat,

Each user does have their own FE.  There is also a single, main BE (for each project).  TSCS.accdb, is simply used to store small amounts of data, locally (where the FE resides), so to minimise network traffic.
PatHartmanCommented:
Then there is no need to close the connection.  Access supports multiple connections so you can support 50 or so concurrent users if you are not working with large tables.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.