Re: Database Splitter - Moving FE to local PC

Tech-Archive recommends: Speed Up your PC by fixing your registry

"Dorna Tucker" <DornaTucker@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7B353058-9D92-462A-9E4B-DD9A4726D2F8@xxxxxxxxxxxxxxxx
I made a mistake when using the DB splitter to split the DB. The BE and FE
is placed on network server in the same folder. Can I copy the FE to each
user local PC?

Yes.

How do I create the shortcut on the users PC to run Access
from their PC and find the BE on the network server. I have 6 users that
will share/input info in the DB.


If you've split correctly, then the linked tables in the FE will work from
your users' PCs (assuming their drive mappings, server names etc are the
same as yours). You don't say if you've implemented user level security.
If you haven't then just have your users open the FE on their PC from a
browser of a desktop shortcut.

If you have then each user will need a desktop shortcut with a command line
in the format (incl the quotes):

"Full path to MSACCESS.exe" "Full path to your app.mdb" /wrkgrp "Full path
to your WIF.mdw"

HTH - Keith.
www.keithwilby.com


.

Relevant Pages

  • Data disappearing - without apparent cause
    ... to store the merged documents in different places on their PC's (or ... even on the network server where the BE is), ... fields is actually local to the FE part of the database, ... Note that it is not envisaged that users will change the folder ...
    (comp.databases.ms-access)
  • Re: Using IF and INSERTTEXT to add page to original document
    ... "Peter Jamieson" wrote: ... "expand" the INCLUDETEXT - it just leaves the field in there. ... The file is buried pretty deep on a network server - but in the same folder ...
    (microsoft.public.word.mailmerge.fields)
  • Security for specific area of a website
    ... No matter what I do all users seem to have ... access to this area as long as they have a login. ... permissions on the files and folder to include Network, Network Server, ...
    (microsoft.public.inetserver.iis.security)
  • Security for specific area of a website
    ... No matter what I do all users seem to have ... access to this area as long as they have a login. ... permissions on the files and folder to include Network, Network Server, ...
    (microsoft.public.inetserver.iis.security)
  • Re: Lost Server in Network .... kind of
    ... to access any share folder on the network server. ... You may capture screen shots of the error messages and send ... PLEASE NOTE the newsgroup SECURE CODE and PASSWORD were ...
    (microsoft.public.windows.server.sbs)