"Lone" <L***@discussions.microsoft.com> wrote in message news:F0B3C10C-1B2A-44E2-AFF5-F17E0E9C6E56@microsoft.com...
>I was created a new database and user level security wizard set up the
> permission. The shortcut will be created automatically. But I want to share
> the database to other, the shortcut don’t work anymore.  For example,
>
> "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Documents and
> Settings\aaa\Desktop\example.mdb" /WRKGRP "C:\Documents and
> Settings\aaa\Desktop\Security.mdw"
>
> I’m user aaa, how can I change the userprofile automatically when I share
> the database?
>
> I’ve tried to use @userprofile@, but some alarm occurs. Is there any
> possible way update the shortcut automatically?
>

"Joan Wild" wrote:

> You should split the database - don't use the splitter wizard to do this.  See www.jmwild.com/SplitSecure.htm
>
> Put the backend in a folder that all users have access to (also put the security.mdw file there).  When you refresh the links in the frontend, use UNC pathnames for the links.
>
> Modify your shortcut to point to the new location of the security.mdw.
>
> Each user will have a copy of the frontend on their computer, as well as a shortcut.  You modify the path to the example.mdb in the shortcut to reflect the location of it on each person's computer.  Alternatively, you could install the frontend to the same location on everyone's computer, and then just copy the shortcut (it's just a file with a lnk extension) to everyone.
>
> --
> Joan Wild
> Microsoft Access MVP
> "Lone" <L***@discussions.microsoft.com> wrote in message news:F0B3C10C-1B2A-44E2-AFF5-F17E0E9C6E56@microsoft.com...
> >I was created a new database and user level security wizard set up the
> > permission. The shortcut will be created automatically. But I want to share
> > the database to other, the shortcut don’t work anymore.  For example,
> >
> > "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Documents and
> > Settings\aaa\Desktop\example.mdb" /WRKGRP "C:\Documents and
> > Settings\aaa\Desktop\Security.mdw"
> >
> > I’m user aaa, how can I change the userprofile automatically when I share
> > the database?
> >
> > I’ve tried to use @userprofile@, but some alarm occurs. Is there any
> > possible way update the shortcut automatically?
> >
>

"Joan Wild" wrote:

> "Lone" <L***@discussions.microsoft.com> wrote in message news:9A1C0757-5FFE-4BA5-9457-D1F7484E024B@microsoft.com...
> > Thanks for your answer first.
> >
> > But I don't want to split the database to frontend and backend. I want to
> > share the whole database, let user download it and use it at their computer
> > with permission setting.
>
> I take it that the users won't be adding/editing any information then?
>
> > As you mentioned, we need to modify the path for each user. But I have a
> > hundred users. I want to find out another way to modify it automatically. Is
> > it possible?
>
> I would suggest that you install the mdb to the same folder on each PC, perhaps
> "C:\Documents and Settings\All Users\Desktop\example.mdb" /WRKGRP "C:\Documents and
>  Settings\All Users\Application Data\Security.mdw"
>
>

"Lone" <L***@discussions.microsoft.com> wrote in message news:382EDA35-5A4A-47C4-89FC-144AE0F5911E@microsoft.com...
> Thanks, actually I placed the mdb at C:/temp now. But it would be more
> convenience if i can run the database on the desktop.
>
> "Joan Wild" wrote:
>
>> "Lone" <L***@discussions.microsoft.com> wrote in message news:9A1C0757-5FFE-4BA5-9457-D1F7484E024B@microsoft.com...
>> > Thanks for your answer first.
>> >
>> > But I don't want to split the database to frontend and backend. I want to
>> > share the whole database, let user download it and use it at their computer
>> > with permission setting.
>>
>> I take it that the users won't be adding/editing any information then?
>>
>> > As you mentioned, we need to modify the path for each user. But I have a
>> > hundred users. I want to find out another way to modify it automatically. Is
>> > it possible?
>>
>> I would suggest that you install the mdb to the same folder on each PC, perhaps
>> "C:\Documents and Settings\All Users\Desktop\example.mdb" /WRKGRP "C:\Documents and
>>  Settings\All Users\Application Data\Security.mdw"
>>
>>