472,954 Members | 2,357 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,954 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 1884
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

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

Similar topics

by: robert walker | last post by:
hi all, to my webapp named mrf, i have added load-on-startup tag to mrf\WEB-INF\web.xml so i added a snippet like so <servlet> <servlet-name>loadDbProperties</servlet-name>...
by: cefrancke | last post by:
I cant seem to find a straight answer on the following. I want to programmatically hide all menus except a basic custom report menu (during report preview) and right click pop-up A-Z sorting on...
by: cefrancke | last post by:
I have set the Startup properties to the following... All menus, toolbars, etc are turned off plus these are unchecked Allow Full Menus Allow Built-in Toolbars Allow Default Shortcut Menus...
by: deko | last post by:
I'm trying to set startup properties with code after I make an MDB into an MDE. I have this code in the startup form's Form_Open event: If IsItMde Then For Each var In Array("Perform Name...
by: PC Datasheet | last post by:
How can I programatically set the startup form when the database opens? Thanks! Steve
by: David L Wright II | last post by:
I am trying to access a mdi parent form's properties and methods outside of the mdi parent form's class module. I keep getting "Reference to a non-shared member requires an object reference"...
by: Chris Ashley | last post by:
I have a class called App set as the startup object with the following code: Friend Class App Shared Sub Main() Dim FrmMain As New MainForm Application.Run(FrmMain) End Sub End Class In...
by: Danieltbt05 | last post by:
just installed SQL server 2000 and using my client , i can't locate the server. I used SQL query analyzer to search but no servers were found. Error message is as below Server : Msg17,level...
by: cj | last post by:
I found a good tutorial for making a windows setup program so I'm doing that. But when I add folders to the target machine list they don't seem to have one for the all users startup folder. I...
by: ApothecarySW | last post by:
Hello all, I have created a class to track the session details on a database we use at work. The class stores information about the current user, start time, end time, etc. The object...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.