Shortcut help...

[Guest]

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]

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.

 

[Guest]

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.

You modify the path to the example.mdb in the shortcut to reflect the location of it on each person's computer.

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?

 

[Joan Wild]

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"

 

[Guest]

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]

The mdb doesn't need to be on the desktop, just the shortcut.