471,573 Members | 1,668 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,573 software developers and data experts.

problem with startup properties

Hi all,

I want urgent feedback on my request. I have to clear the AllowSpecialkey from the startup properties based on the workgroup user security so that the user may not see the database window and VBE. My Application is multiuser Application and it runs thru Terminal Server services. Application sets the AllowSpecialkey properly but it is not working for the first time. For example, say application will clear the AllowSpecialKey for users from security group X and will set the AllowSpecialKey for users from Security group Y. Now when the user from X logs in, Applications sets the AllowSpecialKey to false via script called from AutoExec Macro. But the changes are not reflected immediately. When user from X logs in for the second time , then the Application behaves in desisred manner .

Can anybody help me in this. I want the Application to have the changes took place at the time user logs in.
Jul 11 '06 #1
1 1836
At the point that you run the AutoExec macro, the MS Access environment is already created so that its too late to change to the global environment (such as setting or resetting AllowSpecialKey) . The MS Access help file on AllowSpecialKey states specifically that this does not take effect until the next time the database is opened so you will not get the result you want via this method.

Access does provide command line startup functions however that may fit the bill - in Access help type in "command" and one of the subjects will be command line parameters - check them out especially /wrkgrp - you may be able to create a workgroup profile for each workgroup that will do what you want on startup based - there are other options also such as /user etc. I think this will help you
Jul 13 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by robert walker | last post: by
1 post views Thread by cefrancke | last post: by
10 posts views Thread by PC Datasheet | last post: by
4 posts views Thread by Chris Ashley | last post: by
17 posts views Thread by Danieltbt05 | last post: by
1 post views Thread by ApothecarySW | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.