This sample shows how to use the Windows API to bring up the OpenSaveFile dialog box and save a file to a directory of your choosing. In this case, it saves the file to whatever directory the application sits in. It doesn't have to be that. It could be the directory where the linked tables are stored. In that case, you would want to use the FindSource function instead of the GetPath function. Or you can hard code a directory into the GetPath function and store it anywhere you want. If you want a further explanation of these functions, see my sample "GetPathFilename.mdb"

Note: this app does NOT illustrate how to allow your user to save wherever he wants. YOU are determining where the file will be stored. The user only selects the file that will be copied. For a further discussion of how the API function works, see: http://www.mvps.org/access/api/api0001.htm