Results 1 to 3 of 3
  1. #1
    Ranger7913 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Oct 2014
    Posts
    18

    Modifying Form Then Updating ACCDE File

    I have a form I created for a database. I split the database and made an accde file for other users to utilize. I have modified a form. What is the best method to get the form out to the other users? The modification includes adding tab control subforms. I assume I will need to get the subforms out also. I plan to modify the original form on the original front end of the database. Do I just make a new accde file and send it out? I have some users who have created queries in their accde file. How can they receive the new updated form without having to replace their existing accde file? Thanks for the help.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Unless users can import objects into ACCDE, I think they are out of luck and will have to create queries again.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    In a split system you have a Front End(query/form/report..) and a BackEnd(tables/data reside here).
    BackEnd resides on a shared server. Acopy of the FrontEnd exists on each user's PC.

    If you make an accde from your accdb(Front End), you must backup and protect that accdb. The reason is you can not edit the accde, and no one can modify it. So, when you need to make changes, you go to the associated accdb, make your changes, test it thoroughly, then make a new accde and distribute to all users.

    Splitting DB and Performance

    If users have added queries to their copy of accde, please tell us the details.

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

Similar Threads

  1. accde file not working properly
    By joshynaresh in forum Database Design
    Replies: 9
    Last Post: 10-28-2013, 04:42 AM
  2. .ACCDE File Format
    By kpo in forum Access
    Replies: 3
    Last Post: 10-23-2012, 11:00 AM
  3. Forms don't work after making accde file
    By bdaniel in forum Programming
    Replies: 2
    Last Post: 12-19-2011, 04:53 PM
  4. Update form record source & accde file
    By snoopy2003 in forum Programming
    Replies: 10
    Last Post: 05-14-2011, 01:10 PM
  5. Cannot create ACCDE file
    By swilliams in forum Access
    Replies: 1
    Last Post: 06-03-2010, 03:41 PM

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