I'm having a problem creating an MDE.

These are the steps that I use, if anybody can see where I'm going wrong I
would really appreciate it if you would point out my error.

I open access, go to Tools/Database Utilities/Make MDE file
I then choose the database to be saved as an MDE file, hit the "make MDE"
button, and choose a location for the new MDE.

It's at this point that I hit a snag. The file doesn't get saved as an MDE,
another MDB is created, and then Access freezes up and I have to shut it
down.

The first step in creating an MDE is to make sure all the code is compiled.

Open the database exclusively. With the database open, do a Ctrl + G. When
the Microsoft Visual Basic code window opens go to Debug on the menu. If
Compile is grayed out, that means it's compiled already and there's some
other problem. If it isn't grayed out but won't compile, you need to fix the
problem code then compile. After it's compiled, try making the MDE again.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"HollieB" wrote:

> I'm having a problem creating an MDE.
>
> These are the steps that I use, if anybody can see where I'm going wrong I
> would really appreciate it if you would point out my error.
>
> I open access, go to Tools/Database Utilities/Make MDE file
> I then choose the database to be saved as an MDE file, hit the "make MDE"
> button, and choose a location for the new MDE.
>
> It's at this point that I hit a snag. The file doesn't get saved as an MDE,
> another MDB is created, and then Access freezes up and I have to shut it
> down.

Thank you Jerry, that fixed my problem!

"Jerry Whittle" wrote:

> The first step in creating an MDE is to make sure all the code is compiled.
>
> Open the database exclusively. With the database open, do a Ctrl + G. When
> the Microsoft Visual Basic code window opens go to Debug on the menu. If
> Compile is grayed out, that means it's compiled already and there's some
> other problem. If it isn't grayed out but won't compile, you need to fix the
> problem code then compile. After it's compiled, try making the MDE again.
> --
> Jerry Whittle
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "HollieB" wrote:
>
> > I'm having a problem creating an MDE.
> >
> > These are the steps that I use, if anybody can see where I'm going wrong I
> > would really appreciate it if you would point out my error.
> >
> > I open access, go to Tools/Database Utilities/Make MDE file
> > I then choose the database to be saved as an MDE file, hit the "make MDE"
> > button, and choose a location for the new MDE.
> >
> > It's at this point that I hit a snag. The file doesn't get saved as an MDE,
> > another MDB is created, and then Access freezes up and I have to shut it
> > down.