Sharing a Secure Database on a network

2 Nov 2006 4:09 PM

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?

2 Nov 2006 4:24 PM

Joan Wild

Hayan H wrote:

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

--
Joan Wild
Microsoft Access MVP

2 Nov 2006 5:46 PM

Hayan H

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

--
Hayan H

Show quoteHide quote

"Joan Wild" wrote:

>
> Hayan H wrote:
> > 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.
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>