How to prevent Front End user to see the tables in the back end

[Ignace]

HI



i created a database for our company and aplit the database.
the fornt end is an .ACCDE, which contains the forms, queries, macro and reports that the users need. the front end user need to enter a password when opening the file for protection purposes.

However, although split, the users can still see the tables listed in the "all Access Objects" panes on the left (OUtlook 2010). this also means that they can open the tables (instead of using the forms that i created) and therefore alter the data of the tables.
this is obviously not ideal and potentially dangerous.

is there a way for the users to be "forced" to use only the forms that i created and have NO direct access or see the tables in the back end? i.e. just use the forms, macro and queries that are in the front end?

thanks a lot for your help. as you might have figured out i am not a pro with access!

I

[burrina]

Try this code:
Function setHidden(objType As Integer, hideIt As Boolean)
'setHidden(int,bool) sets the hidden properties of Applicaiton objects ie tables, queries, forms
'objType determines table, query or form
'hideIt hides or shows objects dependent on true of false

Dim myObj As AccessObject, fromWhat, db As Object, whatType As Integer
Set db = Application.CurrentData
Select Case objType
Case 1
Set fromWhat = db.AllTables
whatType = 0 'acTable int val = 0
Case 2
Set fromWhat = db.AllQueries
whatType = 1 'acQuery int val = 1
End Select
For Each myObj In fromWhat
On Error Resume Next
Application.SetHiddenAttribute whatType, myObj.Name, hideIt
Next myObj
End Function