Disable tools in ACCDE

B

BrunoKP

I want to disable some tools in the accde-file. For instance "Create table
design, - Macroes, -Query Guide" and certain databasetools.
I can't find where to set the options for that.
 
C

Chris O'C via AccessMonster.com

You can only do those things with Access user level security, which is
available with the Jet db engine (mdb file format), not the ACE db engine
(accdb file format).

Chris
 
C

Chris O'C via AccessMonster.com

Wait a min ... just remembered. You can change your accde file name
extension to accdr so it opens in runtime mode. Design level tools aren't
available in the runtime version. That won't stop a user from renaming the
file, but not everybody knows this trick.

Chris
 
B

BrunoKP

Strange solution, but I won't blame you for that. I'm sure that my users
don't know the trick.

Thanks a lot.

Bruno

"Chris O'C via AccessMonster.com" skrev:
 
L

Linq Adams via AccessMonster.com

I'm confused! ACCDE is the 2007 version of an MDE file, which means no
design changes/creations can be made, does it not? Without anything being
done other than converting the ACCDB file to an ACCDE file.
 
C

Chris O'C via AccessMonster.com

You can still create/modify tables, queries and macros in an accde or mde.
It's only the code, forms and reports that are protected in an accde or mde
file.

Chris
 
B

BrunoKP

With the navigation panel disabled and all tables placed in the "be", I don't
think that my users can make any harm, but they can be confused by several
menues which they have no use for.

Bruno

"Linq Adams via AccessMonster.com" skrev:
 
Top