Should ACCDE allow users to open tables?

[AHearnden]

I’ve just created my first ACCDE file. However, when I open it, I can still see the navigation pane and can open tables and go into their design view and change field sizes. Isn’t ACCDE supposed to prevent these actions?

 

[RainLover]

No it is not.

You can Open both Tables and Queries but you can't open a Form or Report in design view nor can you view or edit a Module.

 

[AHearnden]

is there a reliable way I can prevent users seeing the nav pane?

 

[RainLover]

You could start by searching for some code that hides all toolbars.

You will also have to disable the bypass key.

You may also need some addition adjustments. Like split the database and introduce a Password on the Back end.

 

[gemma-the-husky]

personally, i don't bother too much.

in most systems, users can get at THEIR data (it is their data, after all)

eg commercial systems expose all this via ODBC links. you can open tables directly with these, and make changes to data in tables. you just don't because you know it is dangerous to do.

letting users see their data is not the same thing as losing security and compromising the database.

 

[RainLover]

is there a reliable way I can prevent users seeing the nav pane?

I don't use anything after 2003 unless I have to but I think this works. There could be a problem that the F11 key will bring the Nav Pane back. It so you will have to disable the Function Keys.

  ' I think this hides the Nav Pane in 2007
    DoCmd.SelectObject acTable, , True
    DoCmd.RunCommand acCmdWindowHide

What is your intention. How secure do you want this Database. Is it just to keep honest people out? There is a limit as to how secure you can make an Access Database.

Edit

Changed 2007 to 2003