Re: Database Deployment

From: Joe (anonymous_at_discussions.microsoft.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 08:29:54 -0700

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?

>-----Original Message-----
>joe wrote:
>> 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.
>
>--
>Joan Wild
>Microsoft Access MVP
>
>
>.
>

Relevant Pages

  • Copy FE of DB when it is already open on the server
    ... I just recently changed my database that I'm running from a monolithic ... They click a shortcut, which used to lead to the old ... network (the master copy that Tony's program copies out to each user) ... by itself (as apposed to putting it in the same folder with the ...
    (comp.databases.ms-access)
  • Re: See the same desktop
    ... >> You can create shortcuts for all users in the all uses desktop folder. ... Is one created on the Terminal Server? ... > The shortcut points to a server other than the T.S. ...
    (microsoft.public.windows.terminal_services)
  • Re: restricting software currently loaded
    ... the shortcut to the program *does* exist in ... > permissions on the folder in which the applications are installed. ... > MCSE, CCEA, Microsoft MVP - Terminal Server ...
    (microsoft.public.windows.terminal_services)
  • Re: Sharing folders mac > PC
    ... From that point on he should be able to just double-click the shortcut ... and the Mac will mount the share and open the folder. ... didn't have to enter any server names - it found the share all by ...
    (uk.comp.sys.mac)
  • password glitches in 20003 and 2000
    ... Access created a shortcut on my desktop that I copied to a folder on the ... server where the database resides. ...
    (microsoft.public.access.security)
Loading