Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    280
    Thanks
    0
    Thanked 0 Times in 0 Posts

    CopyObject method (Access 2000)

    I want to copy an object from a source database called University.MDB in my current database and to use a copy object method instead of the TransferDatabase method.However I do not know where the place the source database in my command.
    DoCmd.CopyObject, "Employees Copy", acTable, "Employees"
    Can somebody explain to me is it possible to use the CopyObject method to copy an object,say table from an extenal database?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: CopyObject method (Access 2000)

    You don't. You can only use copyobject to *export* as far as I know. CopyObject assumes that the source is in the current database.

    If you want to get an object from another database, you import it. In code, that normally means using TransferDatabase. Is there some reason you don't want to use that method?
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •