MDE Files

[Samuel]

Hi

I got Access database that I can only view the tables and queries if I hold
down the Shift button while I open it.

How can I take a normal database and make it like that so users will not be
able to browse the tables etc.


Thank you,
Samuel

 

[Ken Snell \(MVP\)]

Tools | Startup

Here is where you do that. Turn off the ability to see the database window
in the above menu. You can have the database open an initial form (see
above menu for doing that), or you can create a macro (name it AutoExec)
that will open an initial form. See Help for more info.

 

[Ken Snell \(MVP\)]

Additionally, to make an .mde file, see Tools | Database Utilities | Make
MDE File menu.

 

[Samuel]

Thank you for your reply,

The option to Make MDE file is disabled, why?

Samuel

 

[Ken Snell \(MVP\)]

Usually that means that the database was created in a different version of
ACCESS than the one you're using. An MDE file can be created only if the
database was created in your version or has been converted to your version.

 

[Samuel]

That is the case here

Thank you,
Samuel

Usually that means that the database was created in a different version of
ACCESS than the one you're using. An MDE file can be created only if the
database was created in your version or has been converted to your
version.