Lookup and copy file in ms access

[73429]

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

[cactusdata]

Use the

Application.FileDialog

to pick the file, then

VBA.FileCopy

to copy it. Finally, link it with

DoCmd.TransferDatabase

, if that is what you mean with "copy link".

[73429]

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

[cactusdata]

Sorry, but I don't understand your question. It should make no difference where the file is located.

[73429]

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