Copying access file with user level security

[Eyal Semo]

Hello all
I have an access aplic. With user level security.
I have 3 files to the aplic. Due to the security:
..MDB / . mdw / link.mdb

when the file is been open an user/password window is open
and accordingly the permissions is activated.

I like to run the applic. With the same security
On other computers, but after I copy 3 files and edit the link.
I get a massage that I don’t have necessary permissions……
What can I do to resolve this ?
Thanks, Eyal

 

[Rick Brandt]

Hello all
I have an access aplic. With user level security.
I have 3 files to the aplic. Due to the security:
.MDB / . mdw / link.mdb

when the file is been open an user/password window is open
and accordingly the permissions is activated.

I like to run the applic. With the same security
On other computers, but after I copy 3 files and edit the link.
I get a massage that I don't have necessary permissions..
What can I do to resolve this ?
Thanks, Eyal

It is not enough to copy the MDW to the other computer. You have to do
something to make Access actually USE that MDW when you start a session.
This can be done either by having that user "Join" it which would make it
there default workgroup (not recommended), or by creating a shortcut to open
the app that specifies the MDW as a command line argument. The target of
such a shortcut would have the format...

"Path to MSAccess.exe" /wrkgrp "Path to MDW" "Path to MDB"

The latter is preferred because it will not impose a sign-in prompt on all
files that the user opens, but only on the one file that requires it.