avoid data changed or deleted carelessly

[Simon Wong]

My staff use forms for data input and they are also able to access the
underlying table. There is possibility that when they open tables the data
therein are altered or deleted by mistake.

Any way to not allowing the staff to access tables to avoid exposing the
data to danger?


Simon Wong

 

[Keith Wilby]

My staff use forms for data input and they are also able to access the
underlying table. There is possibility that when they open tables the
data
therein are altered or deleted by mistake.

Any way to not allowing the staff to access tables to avoid exposing the
data to danger?

There are several precautions to take - hide the db window, provide custom
menus, set startup options, create and disable the AllowBypassKey property
and invoke user-level security (ULS). Be warned that none of these are
trivial tasks, *especially* ULS. I'd start by hiding the db window, making
the custom menus and setting the startup options, they being the easiest
IMO, then post back when you're ready to tackle the big guns.

HTH - Keith.
www.keithwilby.com

 

[E-mail report using Lotus Notes rather t]

Simon, you can use the macro to open the form and it will only allow you to
go forward and not backward. For the table issue you can hide it. Select
the table file, right click mouse, attribute, select hide. If you can't see
it you can't change anything. If you want to unhide it go to Tools, Options,
View, unselect Hidden. For the Macro it's easier if you can creat a
switchboard and create buttons to link it. Then you can program the button
to open with macros and in the macros you can select read-only for form,
table, etc. Afteryou you creat all the links in switchboard you can hide all
your files. That's the beauty of Access.

Questions: For multi-users do you know how I can allow more than one users
to access my table database at the same time rather than if another user
wants to open the table database it can't open or query the database if
someone else has opened the table database?