Security for access fle

[Ramesh]

HI,

Is there a way I can ensure that a user can do all entry operations but
cannot copy the file or steal the data into any media by any means?

Thanks
Ramesh

 

[Joel Allen]

How about a form that's set to data entry mode? They would only be able to
see one record at a time, and once they have entered it, they cannot get
back to it to copy it.

-JOel

 

[Ramesh]

Thansk Joel. My concern is that if a user has the necessary rights to make
entries, wudnt he have the rights to copy the entire file to a CD?

Regarsd
Ramesh

 

[Joseph Meehan]

HI,

Is there a way I can ensure that a user can do all entry operations
but cannot copy the file or steal the data into any media by any
means?

Thanks
Ramesh

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

 

[Rick Brandt]

Thansk Joel. My concern is that if a user has the necessary rights
to make entries, wudnt he have the rights to copy the entire file to
a CD?

Standard response...

If you need to protect the data *from users* then it doesn't belong in an MDB
file. A user will always have the capability to copy, modify, and entirely
delete your file.

A server engine where you could use a stored proceudre to do insertions and
prohibit everything else is what you need and there are numerous of those that
cost nothing if you don't need to scale very high.