Is It Good Method to Hide DB Objects!

[cap.zadi]

Hi,



I just wonder to know the feasibility and recommendations of to hide the FE DB objects at opening of login form although they are Nav. is disabled and ribbons too.

I used this code for tables and works fantastic but is it feasible option and if so then can we hide all other objects and how?

Private Sub Form_Open(Cancel As Integer)
Dim db As DAO.Database
Dim tdf As DAO.TableDef
Set db = CurrentDb
'Loop through the TableDefs Collection.
For Each tdf In db.TableDefs
            tdf.Attributes = acHidden 'Hide Tables (Change acHidden to acNormal to unhide all tables)
Next tdf
End Sub

[isladogs]

Yes its feasible but in my view the wrong approach
Better still hide the navigation pane completely.
You can do that via Access options and lock down the database using code.

End users should have no access to tables and queries
All navigation should be done using controls on forms

For examples of ways of locking down parts of the Access user interface see http://www.mendipdatasystems.co.uk/c...ace/4594365418

[cap.zadi]

Hi
Thanks and its seems a wonderful solution to protect the DB.

So means i can use the codes for hiding Nav and Ribons for my DB or else as well.

Some more Questions since u had wider expertise:

a. Why still Linked Table in front end are data editable?
b. How to protect the BE from deleting and copying? (*I already set a password for opening).
c.

[isladogs]

Hi
Thanks and its seems a wonderful solution to protect the DB.

So means i can use the codes for hiding Nav and Ribons for my DB or else as well.

Some more Questions since u had wider expertise:

a. Why still Linked Table in front end are data editable?
b. How to protect the BE from deleting and copying? (*I already set a password for opening).
c.

Yes you can use any of that code
A) Split databases are designed for use by multiple users with all tables in the BE.
The linked tables are editable by default. It is possible to make tables read only but fairly unusual to do so.
As users should have no direct access to tables, they should only be able to edit data using forms and only for selected tables

B) Basically you can't as Access is file based system.
However you should make sure end users do not have permission to open the folder containing the BE
If you need a more secure solution, use a server based BE such as SQL Server

C) ?

[cap.zadi]

Hi

Thanks for your expert opinion.

Can we use yours code like HideAccessWindow@ at form load instead of giving options to user via buttons.

[isladogs]

Yes of course and that would be the normal method of doing so.
The easiest method is probably to create an autoexec macro which will run automatically run when the application starts
Alternatively, add such code to the form load event of your start-up form.

[cap.zadi]

Well, Thanks for bringing up such wonderful solutions and advises for juniors who were only thinking out of box without any solutions.

I will try to create autoexec otherwise you can help to create for me.

Thanks