Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Structure only (Access 2000)

    How shall i express by code the commands copy table paste structure only. I intend to use the following expression
    Dim SQL As String
    SQL = " SELECT TblStudents.* INTO tblStudents FROM TblStudents
    CurrentDb.Execute SQL
    How can i set the requirement structure only ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Structure only (Access 2000)

    Instead of SQL, use DoCmd.TransferDatabase:

    DoCmd.TransferDatabase acImport, "Microsoft Access" , CurrentDb.Name, acTable, "tblStudents", "tblStudentsCopy", True

    The last argument True specifies that you want to transfer the structure only.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Structure only (Access 2000)

    Thank you for that. I immeditely tried it with success !

Posting Permissions

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