Results 1 to 4 of 4
  1. #1
    uaguy3005 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    45

    ACDE Question


    I'm relatively new to databases and access. I have a database that I've compiled into an ACDE file. When I enter data using the ACDE file, the tables in the ACDB file are not updated. Are these 2 file formats supposed to be linked? What happens if I want to add a query in the ACDB file and recompile into the ACDE (ie, will i lose the data entered in the ACDE)?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    They are not linked unless you link them. Typically an application is split between a "front end" accde with the forms, reports etc and a "back end" accdb with the data tables. There's a wizard that will split the db or you can simply go into the front end accde and do it manually. You'd delete (or rename) the local tables in the accde, then click on the Access button on the Import section of the External Data tab and choose link rather than import.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    uaguy3005 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    45

    Thanks!

    Thanks! That helped. Got it split.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Excellent! Keep in mind that you can't make form/report design changes to the accde. You keep the accdb it was created from, make changes to it, and compile a new accde from that to give users.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums