troubleshooting Question

How can I use vba to delete connection to external tables.accdb and reconnect to them?

Avatar of Jarred Meyer
Jarred MeyerFlag for United States of America asked on
Microsoft Access
9 Comments2 Solutions722 ViewsLast Modified:
My ultimate goal here is during logon, the user also has a dropdown box where they can select whether to connect to the test tables or the live tables. So I will just write an if statement in vba that will look at which is selected in the drop down box when they click logon and will create the link to the tables in the corresponding external .accdb file containing the tables.

So here is some mocked up code of what I think it may look like;

Private Sub cmdLogon_Click()

if me.cboEnvironment = "Test" then
     CreateConnection = "\\sfile0\Data\Inspection\FAIDatabase\Tables\TestTables.accdb", Connect to all Tables"
else
     CreateConnection = "\\sfile0\Data\Inspection\FAIDatabase\Tables\Tables.accdb", Connect to all Tables
End if

End


**Oh and I guess I would need to delete the connection to the current tables first?

That's just my theoretical idea of what the code would look like.. I really don't have a clue what the connection vba looks like.

Thanks for your advice and assistance!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 9 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros