no shortcuts

[Guest]

Hello,
I need to deploy a secured database to be used to collect data for clinical
trial.
The .mdw works properly and all the permissions are fine.
But…here comes a doubt… This database is hosted on a pc that is shared among
many people and many projects. I cannot join to my .mdw since this will not
allow all others database to work properly. And in any case I don’t want to
set the default .mdw to something different than the standard system.mdw.
Ok I can use shortcuts…but anyone can look at its properties and find out
userid and password.
Is there any other way to manage this issue?
I mean: having the database secured to its .mdw file; the pc running the
system.mdw and logging into the secured database w/o using shortcut.
Maybe the only way to authenticate users through data stored in a table and
then managing permission with RWOP.
Hope all this make sense…
Rocco

 

[Rick Brandt]

Hello,
I need to deploy a secured database to be used to collect data for
clinical trial.
The .mdw works properly and all the permissions are fine.
But.here comes a doubt. This database is hosted on a pc that is
shared among many people and many projects. I cannot join to my .mdw
since this will not allow all others database to work properly. And
in any case I don't want to set the default .mdw to something
different than the standard system.mdw. Ok I can use shortcuts.but
anyone can look at its properties and find out userid and password.
Is there any other way to manage this issue?
I mean: having the database secured to its .mdw file; the pc running
the system.mdw and logging into the secured database w/o using
shortcut.
Maybe the only way to authenticate users through data stored in a
table and then managing permission with RWOP.
Hope all this make sense.
Rocco

Just because you use a shortcut to specify your MDW file does NOT mean you
should also include the UserName and Password as additional arguments. You
should take those out and then the user will be prompted for them.

 

[Guest]

thanks!

Just because you use a shortcut to specify your MDW file does NOT mean you
should also include the UserName and Password as additional arguments. You
should take those out and then the user will be prompted for them.