Msaccess copy file

This method wasn't used in the example, but you may want to read this page anyway Help: CopyFile method. Share with others Share your comments! Was something not clear? Did you find a bug? Is an explanation wrong or not sufficient? Do you want the code do more there is always more? Some of you write to say thanks and tell me what you're doing with Access I want you to be the best you can with Access, and leverage other applications like Excel, Word, and PowerPoint Are you a developer?

Do you want to share? Email to ask about getting your pages added to the code index. Let's communicate, collaborate, and appreciate Email me anytime at info msAccessGurus. I love hearing from you. Home Code. Example This show a list of files in the source folder, and the resulting list in the target. True to overwrite file if it already exists. Use at your own risk. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No.

Any additional feedback? In this article. You should deploy the database the only way that works reliably, which is to split it between a back-end tables and front-end everything else, plus linked tables.

The BE goes on a server, the FE on each user's workstation. Thanks, JP. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question Report abuse. Active Oldest Votes. To fix the code itself, the only real error was that on the destination part of the file copy, there was no file name, So I used Dir Trim.

Item 1 To get the file name and tacked it on the end. Path With fDialog ' Allow user to make multiple selections in dialog box '. SelectedItems 1 , Application. Improve this answer. Show method returns True, the 'user picked at least one file. Show method returns 'False, the user clicked Cancel.

FileSystemObject" fs. Community Bot 1 1 1 silver badge. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.