Error using CopyObject

G

Guest

I would like to be able to copy a table into a database created on a network
drive, as a back up.

"Compile Error:
Wrong number of arguments or invalid property assingment"

The code for the event is:

Private Sub CmdCopy_Click()
DoCmd.CopyObject , "U:\MyDB", "Table1cpy", acTable, "Table1"
End Sub

This works fine if I leave out the path and copy the table into the existing
database
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB Code to copy linked table to local 4
CopyObject 1
Copy table structure in Access 2000 4
Copyobject and Array 2
DoCmd: Copy Table 4
Copy table to different database 5
DoCmd.CopyObject 0
DoCmd.CopyObject 2002 vs 2003 Differences 3

Top