"Joan Wild" wrote:

>
> chouetteray wrote:
> > I created a database on my local drive and secured it using the
> > wizard.  I then placed a copy/shortcut on a different drive.
>
> Copy/shortcut of what?  Did you copy the WIF to a network location that all
> users have permissions to?  Did you copy the MDB to a network location that
> all users have permissions to?  Did you copy the shortcut the wizard created
> to each user's PC?
>
>
> >No one
> > can open it but me. They all get an error message that they don't
> > have permission...  How do I change the current WIF to point to the
> > new drive and not my local drive? Thanks a million.
>
> Copying the shortcut to each user's PC will work, provided they have Access
> installed in the same location as you do on your computer.
>
> The shortcut should look like:
> "path to msaccess.exe" "path to mdb" /wrkgrp "path to secure.mdw"
>
> You can use UNC pathnames for the mdb and mdw
> (\\server\share\ rather than some mapped drive letter).
>
> If you get the above working, you should split the database and leave the
> backend (tables/relationships) on the server.  Give each user a copy of the
> frontend (all other objects with linked tables pointing to the backend on
> the server) on their PC.  Then modify the "path to mdb" portion of the
> shortcut to point to the local copy of the frontend.mdb.
>
> When you split it, don't use the splitter wizard as that will result in an
> unsecure backend mdb.  Instead split it manually.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>

> Hi Joan,
>
> Can you point me to a reference which explains how to manually split
> a db. I have used the wizard previously but didn't realise that a
> manual split preserves back-end security.
>
> Thanks very mcuh,
> Ian.
>
> "Joan Wild" wrote:
>
>>
>> chouetteray wrote:
>>> I created a database on my local drive and secured it using the
>>> wizard.  I then placed a copy/shortcut on a different drive.
>>
>> Copy/shortcut of what?  Did you copy the WIF to a network location
>> that all users have permissions to?  Did you copy the MDB to a
>> network location that all users have permissions to?  Did you copy
>> the shortcut the wizard created to each user's PC?
>>
>>
>>> No one
>>> can open it but me. They all get an error message that they don't
>>> have permission...  How do I change the current WIF to point to the
>>> new drive and not my local drive? Thanks a million.
>>
>> Copying the shortcut to each user's PC will work, provided they have
>> Access installed in the same location as you do on your computer.
>>
>> The shortcut should look like:
>> "path to msaccess.exe" "path to mdb" /wrkgrp "path to secure.mdw"
>>
>> You can use UNC pathnames for the mdb and mdw
>> (\\server\share\ rather than some mapped drive letter).
>>
>> If you get the above working, you should split the database and
>> leave the backend (tables/relationships) on the server.  Give each
>> user a copy of the frontend (all other objects with linked tables
>> pointing to the backend on the server) on their PC.  Then modify the
>> "path to mdb" portion of the shortcut to point to the local copy of
>> the frontend.mdb.
>>
>> When you split it, don't use the splitter wizard as that will result
>> in an unsecure backend mdb.  Instead split it manually.
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP