Database Deployment


J

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
 
Ad

Advertisements

J

Joan Wild

joe said:
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.
 
J

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

Advertisements

J

Joan Wild

Joe said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top