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