MS Access Help

  • Thread starter Thread starter Lei
  • Start date Start date
L

Lei

Hi,

I'm a new to Access. Here is my problem:

In MS Access. One user will import new date to Access table
frequently. More than 30 users need to view only one of the
different the reports (or forms ) based on the new data
from the table.

How can I prevent the 30 users to view the table content?
What's the limit for multi-user access to the database? Do
I need to split the database into front-end and back-end?

Any suggestion will be highly appreciated!
Lei
 
First you will need to modify your table by adding a field that will
segregate the data by users. Then you will need to apply user-level
security to your table. Next step is to deny all users the
read-permission to the table. The create a Read With Owner's
Permission query that includes some selection criteria matching the
CurrentUser() function with the user-specific info in the new column.

It is explained in general in the Microsoft security FAQ. Find a link
in the website in my signature.



Hi,

I'm a new to Access. Here is my problem:

In MS Access. One user will import new date to Access table
frequently. More than 30 users need to view only one of the
different the reports (or forms ) based on the new data
from the table.

How can I prevent the 30 users to view the table content?
What's the limit for multi-user access to the database? Do
I need to split the database into front-end and back-end?

Any suggestion will be highly appreciated!
Lei
Click to expand...


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Hi,

To Modify the table by adding a field that will segregate
the data by users wil be a little too much manual work
since the data in table will be updated very frequently.
However, It is easy to create a query which can get all
the contents as you want in the above table. Can I use
the query instead of the table? then follow you next two
step?
Do I need to program based on your instruction? Since I
don't know VB.
Thanks very much for your reply!
 
Back
Top