Re: Secured Shortcut & Citrix
- From: "Joan Wild" <jwild@xxxxxxxxxxxxxxxx>
- Date: Mon, 8 May 2006 10:28:34 -0400
Create a desktop shortcut like...
"path to msaccess.exe" /wrkgrp "path to secure mdw"
Once Access opens, open the testproperties.mdb; provide a username/password
that's a member of the Admins Group in secure.mdw.
Now run the function in the immediate window.
--
Joan Wild
Microsoft Access MVP
karlroes@xxxxxxxxxxx wrote:
HI Joan,
I just had a chance to try this and it worked a treat - thank you.
In my excitement at possibly repairing the problem, I've inadvertently
caused another bigger problem for myself as follows.
The first thing that happens in code behind a hidden startup form is
to call a startup function to change properties for the application.
Well, I always have this call commented out for testing and in my
haste, for one reason or another I uncommented it, tested the mdb and
now I can't use my external testproperties.mdb to change the
properties back because it is now a secured mdb made using the
secured non-default .mdw!!!
I have tried the following:
DBEngine.SystemDB = "C:\PathtoSecured.mdw"
Set wksSecure = DBEngine.CreateWorkspace("", "UserName", "Password"")
Set db = wksSecure.OpenDatabase( "C:\Pathtosecured.mdb")
and I consistantly get Error 3029 - not a valid account name or
password when both are correct.
In a nutshell, please, what is the procedure for externally changing
the startup properties of a secured mdb to enable the shift bypass key
using the developer username/password?
Regards
K
Joan Wild wrote:
I haven't had a problem doing this (even in a TS environment).
I didn't bother with any code to change the permissions. Just give
full permissions on the frontend links (that doesn't affect the
permissions they really have, as that is dictated by the permissions
on the backend tables).
--
Joan Wild
Microsoft Access MVP
karlroes@xxxxxxxxxxx wrote:
Thanks Joan,
I tried the above code with little success.
Apparently, linked tables need a minimum of Modify Design
permissions in the frontend for the RefreshLinks method. So I set
the table properties in the FE to Modify Design and all worked fine
on a local dev machine.
On install in the TS/Citrix environ, a " You do not have exclusive
access to the database at this time" message appears. Install
personell can OK through the error 32 times ( the number of tables )
to get the app to run.
Please, why does this occur and how can I prevent it as there will
be a total of 5 users with their own copy of the FE?
Regards
K
.
- References:
- Re: Secured Shortcut & Citrix
- From: karlroes
- Re: Secured Shortcut & Citrix
- Prev by Date: Re: where are posts from last week?
- Next by Date: Security on Modules
- Previous by thread: Re: Secured Shortcut & Citrix
- Next by thread: Re: where are posts from last week?
- Index(es):
Relevant Pages
|
