Link to home
Create AccountLog in
Avatar of pgoulet_fsac_info
pgoulet_fsac_infoFlag 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
ASKER CERTIFIED SOLUTION
Avatar of Jim P.
Jim P.
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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
Avatar of rockiroads
rockiroads
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account