Sharing a Secure Database on a network

[Hayan H]

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?

 

[Joan Wild]

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.?

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?

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.

 

[Hayan H]

Thank You for your quick response, It works perfectly!!!!!!!