Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Thanked 0 Times in 0 Posts

    copy table structure only (Access 2000)

    My way of copying table structure only does not work with linked does copy the table but not structure only,and with everything with it.Coukd i avoid that and copy a linked table structure only ?
    DoCmd.TransferDatabase acImport, "Microsoft Access", CurrentDb.Name, acTable, "tblClients", "tblObsoleteClients", True

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: copy table structure only (Access 2000)

    StructureOnly:=True won't work with linked tables, so you have to import from the database containing the source table instead of from the current database. Let's say that tblClients is linked to a table of the same name in C:BEData.mdb. You can then use

    DoCmd.TransferDatabase acImport, "Microsoft Access", "C:BEData.mdb", acTable, "tblClients", "tblObsoleteClients", True

    to import the structure of TblClients without the records.

Posting Permissions

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