By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,553 Members | 890 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,553 IT Pros & Developers. It's quick & easy.

Lookup and copy file in ms access

P: 3
Hi
i have a MS access data base with multiple users running on it and i"m using the attach a file option and slows down the application i would like to create a CMD that should open file dialog and ask user to select the file that he wants to attach and it should copy the file to a different folder and copy link in a field
3 Weeks Ago #1

✓ answered by cactusdata

Use the
Expand|Select|Wrap|Line Numbers
  1. Application.FileDialog
to pick the file, then
Expand|Select|Wrap|Line Numbers
  1. VBA.FileCopy
to copy it. Finally, link it with
Expand|Select|Wrap|Line Numbers
  1. DoCmd.TransferDatabase
, if that is what you mean with "copy link".

Share this Question
Share on Google+
4 Replies

cactusdata
Expert 100+
P: 128
Use the
Expand|Select|Wrap|Line Numbers
  1. Application.FileDialog
to pick the file, then
Expand|Select|Wrap|Line Numbers
  1. VBA.FileCopy
to copy it. Finally, link it with
Expand|Select|Wrap|Line Numbers
  1. DoCmd.TransferDatabase
, if that is what you mean with "copy link".
3 Weeks Ago #2

P: 3
thanks for your answer i do have no an issue that the file does not open when you click on the link since its located on a server how do i set that all files should automatically get the quotation after inserting into field
thanks for your help
2 Weeks Ago #3

cactusdata
Expert 100+
P: 128
Sorry, but I don't understand your question. It should make no difference where the file is located.
2 Weeks Ago #4

P: 3
when its stored in a network location you need to add double quotations in the beginning of the link and the end in order it should work
2 Weeks Ago #5

Post your reply

Sign in to post your reply or Sign up for a free account.