Avatar of pgoulet_fsac_info
pgoulet_fsac_info
Flag for United States of America asked on

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

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.  

Thanks

Paul
Microsoft Access

Avatar of undefined
Last Comment
rockiroads

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Jim P.

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
jefftwilley

Expound a little more on what you're doing for us. Are you trying to have a deployed database link tables back to a specific database?
SOLUTION
rockiroads

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy