Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Brugge, Belgium
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Code doesn't work (Access 2007)

    I want to transfer the Access datatable "tblContacts" from the Access database "Test.accdb" residing in the folder "d:Nieuwe map" to the access database "Opvang.accdb" residing in the folder "d:OntwerpOpvang.accdb" To do so i us the following code:
    DoCmd.TransferDatabase , acExport, "Microsoft Access", "d:Nieuwe mapTest.accdb", acTable, "tblContacts", "dntwerpOpvang.accdb", False

    What's wrong with this code. I get an errromessage, saying " types mismatched"
    What to do if i also want to gif te transferred table another name?

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

    Re: Code doesn't work (Access 2007)

    Read <post:=730,199>post 730,199</post:> carefully, please.

    You're asking a lot of questions without acknowledging the replies: <post:=722,083>post 722,083</post:>, <post:=723,829>post 723,829</post:>, <post:=728,076>post 728,076</post:>, <post:=728,927>post 728,927</post:>, <post:=729,095>post 729,095</post:> and most recently <post:=730,195>post 730,195</post:>, so other Loungers don't know whether the replies were helpful.

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

    Re: Code doesn't work (Access 2007)

    This is an offshoot of the thread starting at <post:=730,195>post 730,195</post:> and discussion has continued there.
    Please post all replies in that thread, this one is locked to prevent further duplication.

Posting Permissions

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