docmd.copyobject

S

souris

I tried to use docmd.copyobject
The code is following:

DoCmd.CopyObject "MyServer.MyDatabase", "MyNewTable", acTable,
"MySourceTable"

The code looks for a directory at My Documents\MyServer\MyDatabase but it
can not find.

I wanted to copy a table from my current database to my SQL server.

Is it possible to do this?
If yes, what I did wrong here?

Souris,
 
Top