Forum Discussion

Jeanette2280's avatar
Jeanette2280
Copper Contributor
Nov 27, 2021

Saving a ACCDE file gives an error message

I am designing a database to share with people who do not have access, and I can not get Access to save as an ACCDE file
access
Jeanette2280's avatar
Jeanette2280
Copper Contributor
Nov 28, 2021

George_Hepworth 

I am using ACCESS that comes with Microsoft 365. I am current in all updates.

I am compiling and repair before I attempt to save.

 

In trying to save as an ACCDE , I go to file and choose save as ACCDE and choose where to save 

I get a message box which states that "Access was unable to create the file .accde, .mde or .ade file"

 

I have discovered, by trial and error that if I take out autoexec that opens a welcome page and aids in navigation it will save. But doing that makes the database useless to most users. 

 

isladogs's avatar
isladogs
MVP
Nov 28, 2021
In the VBE options, make sure you have Require Variable Declaration ticked. This should be your default option but unfortunately Access doesn't do this automatically. Once ticked the line Option Explicit will be added to each new code module...but not existing modules
So, next make sure you have Option Explicit as the second line in EVERY code module and if not add it.

Now compile your database again. You will probably find errors that weren't flagged before.
Fix all errors and you should then be able to create an ACCDE successfully
  • Jeanette2280's avatar
    Jeanette2280
    Copper Contributor
    Nov 28, 2021
    Okay you are speaking to a newbie here
    Where do I find the VBA option?
    I tried the options under file and could not locate
    • George_Hepworth's avatar
      George_Hepworth
      Silver Contributor
      Nov 28, 2021

      Jeanette2280 

       

      You can find the VBE Here:

       

       

      Compile here, and add Option Explicit to all Code modules.

       

       

      • Jeanette2280's avatar
        Jeanette2280
        Copper Contributor
        Nov 28, 2021
        Compile is greyed out
        I cant access it ?
    • isladogs's avatar
      isladogs
      MVP
      Nov 28, 2021

      Jeanette2280 

      First open the Visual Basic Editor (VBE) e.g. from the Database Tools ribbon

      In the VBE, click Tools ...Options and tick the item highlighted

       

       

      Then make sure each code module has Option Explicit as line 2 as shown above.

      After that, click Debug...Compile.

      You will almost certainly have at lease one undeclared variable.

      Fix and continue until your project is compiled. Then try saving as ACCDE again.

Resources