?
Solved

Help with Syntax DoCmd.CopyObject

Posted on 2007-08-06
3
Medium Priority
?
455 Views
Last Modified: 2013-11-05
I want to include the password in this procedure.  Need help with syntax.  

Here is the code.

Any help would greatly be appreciated.

Private Sub cmdTransferBackup_Click()
   
    DoCmd.SetWarnings False

    DoCmd.CopyObject "\\Dtcnas-mosl002\slguest\ILSPIBackup\ILSPBackup;Jet OLEDB:Database Password=XXXXXX;", "", acTable, "Backup_BuyersElectronicTradeTicketsTable_Live"

End Sub
0
Comment
Question by:ca1358
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
Clif earned 2000 total points
ID: 19638501
You need to open the database with the password before you copy.
Check this out:
http://alexdyb.blogspot.com/2006/04/how-to-export-objects-to-secured.html
0
 

Author Comment

by:ca1358
ID: 19638979
Thank you!
0
 
LVL 10

Expert Comment

by:Clif
ID: 19639013
No prob, glad I could help.

TFTP  :)
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you haven’t already, I encourage you to read the first article (http://www.experts-exchange.com/articles/18680/An-Introduction-to-R-Programming-and-R-Studio.html) in my series to gain a basic foundation of R and R Studio.  You will also find the …
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
The viewer will learn how to pass data into a function in C++. This is one step further in using functions. Instead of only printing text onto the console, the function will be able to perform calculations with argumentents given by the user.
The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.
Suggested Courses
Course of the Month15 days, 2 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question