Database deployment with security

[Guest]

I went to Joans great web site to split the db manually and that is much better idea than the steps in the wizard.Now, once the db is split and the tables reside on a shared folder(front/end, back/end) design.Do i copy the front end with the short cut to each users desktop (i am on a shared network so i would drag and drop to each persons folder on the network) so they can enter with their password?
thanks in advance.....

 

[Joan Wild]

Ensure that you open the frontend and refresh the links to the backend in
its new location on the server.

Then you can copy that FE everywhere, as well as the shortcut. Check that
the shortcut has the correct paths in it (assuming you put the mdw on the
server as well, you may need to modify your shortcut to suit). Also you can
use UNC pathnames in the shortcut \\servername\folder\filename rather than
using mapped drives.

Even when you refresh the links in the linked table manager, if you browse
via Network Neighborhood, the links will use UNC.


--
Joan Wild
Microsoft Access MVP

I went to Joans great web site to split the db manually and that is much

better idea than the steps in the wizard.Now, once the db is split and the
tables reside on a shared folder(front/end, back/end) design.Do i copy the
front end with the short cut to each users desktop (i am on a shared network
so i would drag and drop to each persons folder on the network) so they can
enter with their password?