Hiding Tables For Users

[Batselot]

Hi there, I have a quick question hoping I get an easy answer for this one.


I have successfully created a database on request. There is one problem though, I ask the user to enter the data from the forms I have created and I need to get rid of the tables that contain the data( at least for the customer so they don't enter data to the table by accident).How can I hide the tables only for myself to see if i really want to? Thanks a lot

[ranman256]

in a module, add this function:

Public Function HideDB()
    DoCmd.SelectObject acTable, , True
    DoCmd.RunCommand acCmdWindowHide
End Function

then in the autoexec macro that opens your startup form
add this as the 1st item
runcode HideDb()
openform fMainMenu

this will hide the tables.

[mike60smart]

Hi

You should split the Database and then all that the users have to work with are the Forms , Queries & Reports

[Micron]

Access security is a piece meal thing, requiring several things to be done to gain any significant level - which won't achieve 100%. That macro can easily be suppressed, but so can efforts to prevent that. Suggest you read up on the rather large subject and decide what level you need to go to. There are a few articles on the subject here
and plenty more in many other places.