Results 1 to 7 of 7
  1. #1
    ttrautz is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    8

    ACCDE does not run VBA or Macros - MS Access 2016

    Hello,



    I created a database in Access 2016, split it, and created an ACCDE that is in a shared (and trusted) folder.
    - Subfolders are ON for trusted locations
    - DB has been compiled and debugged prior to ACCDE
    - Trust Center has been set to "Enable All Controls" in ActiveX Settings
    - Trust Center has been set to "Enable All Macros" in Macro Settings

    Simple items like clicking a button to open a form does not work. None of the VBA code works.

    It all works fine as ACCDB - both the original and a saved version in the shared folder.

    I have read all kinds of posts on this issue, but none of the solutions work. A DB that I built a month ago worked fine in the same folders, created on the same machine, with the same codes as a split DB with an ACCDE front end.

    Please advise.

    Thank you.

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    A correctly made ACCDE file will run any code that existed when it was created.
    However you cannot add new code or make any other design changes

    It sounds like your ACCDE file is damaged.
    go back to the ACCDB version, compile it then create a new ACCDE file
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    ttrautz is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    8
    Thanks. I never added new code to the ACCDE file, and I have compiled the ACCDB file and created a new ACCDE file - as noted in my initial post.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    As I'm sure you are aware, ACCDE files will only run in the same 'bitness' in which they were created (32-bit or 64-bit)
    I have heard of users having issues in different versions of Office - mainly due to references being version specific
    Perhaps neither of those are relevant in your case

    Although you've already checked most issues, I suggest you just try remaking it in case the original is corrupted
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    created an ACCDE that is in a shared (and trusted) folder
    this implies users are sharing the same front end - that will corrupt it

    - Trust Center has been set to "Enable All Controls" in ActiveX Settings
    - Trust Center has been set to "Enable All Macros" in Macro Settings
    may or may not be relevant, these are client settings (i.e. each user) as is trusted locations, not a setting for the db, so this will only affect your machine. Also, (for your machine and since the db is on the network) have you ticked 'allow documents on network to be trusted' option under trusted documents.

    And does the .accde work OK when on your development machine?

    suggest put some msgbox code to report on progress from when the system first opens - i.e. autoexec macro or the display form open event. It may be the code is failing in accde but error not being handled

    Also, temporarily rename your .accdb (which works) as .accdr (will run as runtime) and see if that still works

  6. #6
    ttrautz is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    8
    Yes there are 4 users - all using the ACCDB right now since the ACCDE will not work still. Is there a better way to split it and offer a front end other than ACCDE? That is how I was always instructed.

    Yes they are client settings that have been set on each machine - just in case that was one of the issues affecting the ACCDE.

    Yes it does work on the development machine from the shared folder - just not on any other machines (it will open, but no code or macros will work).

    Yes it did work in runtime.

    I am still at a loss for how to make this thing work in a sharable fashion. Any help is appreciated.

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    EACH user needs their OWN copy of the front end on their OWN computer

    That is true whether the FE is an ACCDE (preferable) or an ACCDB.
    SHARING the use of the SAME FE from the same location WILL lead to corruption.
    It may take a little longer to go wrong using an ACCDB but trust me it WILL get corrupted unless you change your setup
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Automating Outlook 2016 from Access 2016
    By jcc285 in forum Programming
    Replies: 10
    Last Post: 09-30-2017, 01:53 PM
  2. VBA code missing in ACCDE - Access 2016
    By pawjer in forum Access
    Replies: 9
    Last Post: 07-31-2017, 03:33 PM
  3. Upgrade accde from 2013 to 2016
    By aldol in forum Access
    Replies: 1
    Last Post: 03-25-2017, 04:19 AM
  4. Macros in Web App Access 2016
    By solaikumar in forum Macros
    Replies: 3
    Last Post: 04-19-2016, 02:54 PM
  5. Replies: 5
    Last Post: 12-04-2015, 10:19 AM

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