"barry hampson" <ba***********@ntlworld.com> wrote in message news:<AY*****************@newsfe1-gui.ntli.net>...
I know you can do it but don't know how. So how do you close the database to
prevent any more development or interference from users.
More to the point if I have passwords that relate to the database - how do
I unlock it to make it available for development and adaptation again.
I was tols that startting the database with shift key pressed gave acces
to toolbars.However they revert to limited set before database is
accessible.
Thanks for any advice
Bazza
Hi Barry:
First of all I think it is a must to have an mde database for users...
and tables should be anyway outside in other computer as a server...
if you don't want to use the security of access which is a little
complicated but not that terrible you should have your own security
programed. I have a form on the startup with user and password... if
user is me, then I have all the toolbars and privileges, if not they
have their toolbar called usertoolbar...
I also have for every table a creationdate, createuser, modifieduser
and modifieddate fields... creationdate is on default now(),
createuser is same as loged in in the userform which is opened all the
time but not visible... modifieddate is on the before event ()now and
modifieduser the same but taken from the userform again...
tables are hiden... which is like believe in Santa, but you won't do
it as easy to the users to corrupt your tables... they can't make
changes to the usertoolbar... so. They can't avoid the userform...
because on opening event it hides everything but the form... the key
problem... it is resolved by using mde, linked tables and replicate
database...
I hope this helps...
Mariana Vivar