C
Ching
Dear friends,
How can i do the security protection if I have 3 mdb.
1) this mdb is storing all the table and records
2) this one is storing all the predefined report and
query, and
3) this mdb is for individual user to create their own
report and query but they have no right to access the
tables and record.
If I startup with 2) mdb, everytime I need the data, then
I call 1) mdb by using opendatabase command without really
open another access application. I can apply logic in this
point. But in case if a user want to create their own
report, I will shell another Access i.e. 3) mdb for them
to use. But how can I apply security to ensure user can
only create their own report & query without modify any
tables and data?
Can Access 97 can do the above requirement?
Pls give me some help & suggestion!
Thx!
Ching
How can i do the security protection if I have 3 mdb.
1) this mdb is storing all the table and records
2) this one is storing all the predefined report and
query, and
3) this mdb is for individual user to create their own
report and query but they have no right to access the
tables and record.
If I startup with 2) mdb, everytime I need the data, then
I call 1) mdb by using opendatabase command without really
open another access application. I can apply logic in this
point. But in case if a user want to create their own
report, I will shell another Access i.e. 3) mdb for them
to use. But how can I apply security to ensure user can
only create their own report & query without modify any
tables and data?
Can Access 97 can do the above requirement?
Pls give me some help & suggestion!
Thx!
Ching