Protect certain records

[Guest]

I work for a small school and I have created a database to keep track of the
students' data. The "Admissions" staff uses a front-end to enter the
information of all the people who contact the school. "Services" staff uses a
different front-end database and they check a box to enroll students who have
contacted the school.
"Admissions" can delete records from the DB (sometimes the same person is
entered 2-3 times). However, an enrolled student data was deleted, this
should not happen.
Q. How can I protect the enrolled students so they are not deleted by
accident?
The table shared by "Admissions" and "Services" is the same, "Admissions"
cannot see the [enroll] check box only "Sevices".
I am using MS Access 2000 and the users have Win XP. The server is Win NT
4.0 (I know... we are in the process to migrating)
Thanx.

 

[Joan Wild]

I work for a small school and I have created a database to keep track
of the students' data. The "Admissions" staff uses a front-end to
enter the information of all the people who contact the school.
"Services" staff uses a different front-end database and they check a
box to enroll students who have contacted the school.
"Admissions" can delete records from the DB (sometimes the same
person is entered 2-3 times). However, an enrolled student data was
deleted, this should not happen.
Q. How can I protect the enrolled students so they are not deleted by
accident?
The table shared by "Admissions" and "Services" is the same,
"Admissions" cannot see the [enroll] check box only "Sevices".

I suppose you could let them see it; then maybe they wouldn't delete an
enrolled student.

If all entry/deletion is done via forms (i.e. no one has access to the
tables), you could put the following in the Current event for the form.

If Me!YourCheckBox = true then
Me.AllowDeletions = false
end if

 

[Guest]

I work for a small school and I have created a database to keep track
of the students' data. The "Admissions" staff uses a front-end to
enter the information of all the people who contact the school.
"Services" staff uses a different front-end database and they check a
box to enroll students who have contacted the school.
"Admissions" can delete records from the DB (sometimes the same
person is entered 2-3 times). However, an enrolled student data was
deleted, this should not happen.
Q. How can I protect the enrolled students so they are not deleted by
accident?
The table shared by "Admissions" and "Services" is the same,
"Admissions" cannot see the [enroll] check box only "Sevices".

I suppose you could let them see it; then maybe they wouldn't delete an
enrolled student.

If all entry/deletion is done via forms (i.e. no one has access to the
tables), you could put the following in the Current event for the form.

If Me!YourCheckBox = true then
Me.AllowDeletions = false
end if

It works, thanx.

 

[Guest]

I work for a small school and I have created a database to keep track
of the students' data. The "Admissions" staff uses a front-end to
enter the information of all the people who contact the school.
"Services" staff uses a different front-end database and they check a
box to enroll students who have contacted the school.
"Admissions" can delete records from the DB (sometimes the same
person is entered 2-3 times). However, an enrolled student data was
deleted, this should not happen.
Q. How can I protect the enrolled students so they are not deleted by
accident?
The table shared by "Admissions" and "Services" is the same,
"Admissions" cannot see the [enroll] check box only "Sevices".

I suppose you could let them see it; then maybe they wouldn't delete an
enrolled student.

If all entry/deletion is done via forms (i.e. no one has access to the
tables), you could put the following in the Current event for the form.

If Me!YourCheckBox = true then
Me.AllowDeletions = false
end if

It works, Thanx