Split or not to Split ?

[mani]

Hi. I am trying to creat some sort of security for my database so none else make changes to design of the database apart from me. I have got a small database that i run on the company network i work for. all the staffs have a short cut of this database on ther desktop where they can add/edit/view data and unfortunatly able to change design of the database if i havent set the startup to only show switchboard. what I want is this:

Open database, switchboard popup and nothing else(ie. database window where you can see table,forms,queries)..sounds simple..but havent able to do it..

people say use database split...not so sure on...by the way, I DONT WANT OTHER USERS TO HAVE PASSWORD TO ACCESS THE DATA...hint,,no password and user name popups....

i am kinda new to access,,pleeeeeeeease help

Hi. I am trying to complete my access database by creating some security for it. I want to know how to setup the database file so when I execute, let say in my document folder so that when it opens it only shows my switchboard and not the editable(table,queries...) panel on the left hand side. I know i can hide it via the startup option but I want to completly blocking it so it doesn't allow any user to edit the design of the database.
If anyone can help I realy appreciate it...thank you

 

[Banana]

1) Splitting does not improve security. It only allows multiple users to log on, which is very good thing.

2) Search the forums on workgroup, permissions, security, hiding Access menu and commands, hiding database windows, and hiding Access. Here's a FAQ on security setting from MSDN to start with.

HTH.

 

[KeithG]

Also you can convert your database to an .MDE file and the users will not be able to go into design view.