Problem with Startup

[sunil sharma]

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. Is there any way that i can close the current database and then open the same database in the Access Application window without restarting creating another session of Access Application

[PEB]

Use the left Shift when you open your database :)