Sharing a Secure Database on a network

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi and I thank you for help in advance.
I have two questions.

1) Once the datbase has been secured and user permissions assigned; how can
you share the datbase with the other users on a shared drive.?

2) How can I allow only the current user to view reporting for themself?
 
Hayan said:
1) Once the datbase has been secured and user permissions assigned;
how can you share the datbase with the other users on a shared drive.?
Click to expand...

You really should split the database. Put the backend (tables only) on the
server, and give each user a copy of the frontend on their PC. The frontend
would contain all the other objects, and have linked tables (linked to the
backend). Since you have secured your database, split it manually. See
www.jmwild.com/SplitSecure.htm
2) How can I allow only the current user to view reporting for
themself?
Click to expand...

You'll need to include a field in your tables that contains the 'owner' for
the record. The currentUser() function can be used to retrieve the Access
login username. You'll need to populate the owner field on existing
records, and for new records, you can have a control (hidden if you like) on
all your forms with =CurrentUser() as the default value.
 
Back
Top