Database Deployment

[joe]

Hello,

I have created a simple timecard database at my job and
now the manager wants to have access from his desktop and
one more employee as well.My question, after applying
security and having the shortcut on my desktop, could i
move the database and shortcut to a shared folder on the
network and just copy the shortcut to the desktops using a
front end/back end design?

Thanks

 

[Joan Wild]

Hello,

I have created a simple timecard database at my job and
now the manager wants to have access from his desktop and
one more employee as well.My question, after applying
security and having the shortcut on my desktop, could i
move the database and shortcut to a shared folder on the
network and just copy the shortcut to the desktops using a
front end/back end design?

You should split the secured database (don't use the database splitter
wizard though) - see
www.jmwild.com/AccessSecurity.htm for a link of how to do it manually.

Put the backend and the mdw on the server. Give each user a copy of the
frontend (linked to the backend on the server), and a copy of the shortcut.
As long as the frontend is installed to the same location on their computer
as your's, your existing shortcut should be OK.

You can edit the shortcut, specifically the path to the mdw, so that it
reflects its new location on the server. You can use UNC for the path.

 

[Joe]

Thanks Joan,

I am not sure what you mean by UNC?The path to the folder
is the following----S:\GROUPS\INVOICE\CustomerDB
All three of us work in the INVOICE dept so i would have
the back end located in the CustomerDB folder and copy
front end with shortcut to each users desktop?Is this
correct?

 

[Joan Wild]

Thanks Joan,

I am not sure what you mean by UNC?

UNC stands for Universal Naming Convention. It identifies a resouce by its
network location, rather than the local name to which it is mapped. The
syntax is
\\server\share\directorypath

The path to the folder
is the following----S:\GROUPS\INVOICE\CustomerDB
All three of us work in the INVOICE dept so i would have
the back end located in the CustomerDB folder and copy
front end with shortcut to each users desktop?Is this
correct?

Yes it is. Your 'S' drive is mapped to a network location. Instead of
relying on your users having S mapped correctly, you could use
\\servername\groups\invoice\customerdb\secure.mdw

Check to see what S is mapped to.