troubleshooting Question

Can you use 'DoCmd.RunCommand acCmdLinkTables' and force a specific folder\filename?

Avatar of pgoulet_fsac_info
pgoulet_fsac_infoFlag for United States of America asked on
Microsoft Access
3 Comments2 Solutions1405 ViewsLast Modified:
Is there a way to preset the folder and file name using the DoCmd.RunCommnad acCmdLinkTables syntax.

Currently using a msgbox "Navigate Desktop\thisfolder\filename"  Click Select All then OK

The user then must navigate to the correct file, click the Select All button, then OK.

********start code snipet

MsgBox "Navigate to > Desktop\Drug Dealers\DrugDealers.mdb"
     DoCmd.RunCommand acCmdLinkTables

********End Code Snipet

OK, its kluegee but it does work.  Hope to make it better with EE help.

If that wont or can't work, any ideas to accomplish the same will be considered.

You guys and gals are the best.  


Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
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 3 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