Hey Ridders:
What I would suggested that you do, is hide all that anyway and then
create a MDE file of just the application parts (Queries, Forms,
Reports, Macros, Modules), Having the Tables in a separate MDB file.
This way you can have the option of having the customer menus when they
are running the application, but once the application is open, the admin
can open the database window simply by pressing F11.
Then he would be allowed to make changes, test them, and then distribute
a new MDE file to all the users.
The other option is to make use of the CurrentUser() function that is
available in MS Access. This will allow you to setup permissions for
each table, Query, Form, Report, Macro, and module that you have in your
MDB file.
Read up on how to implement a Database MDW file with your current
MDE/MDB file. This way you can have some security with your app, if that
is the reason that you want these options.
-----Original Message-----
From: ridders [mailto:
[email protected]]
Posted At: Tuesday, May 01, 2007 3:36 PM
Posted To: microsoft.public.access.modulesdaovba
Conversation: Using VBA to create start up options in Access
Subject: Using VBA to create start up options in Access
What is the VBA code needed to change startup options for a specified
user?
I have a database where all the startup options are disabled for all
users
except the administrator (CR).
I want to turn these on if the administrator is logged on.
The following code will display the database window:
If strCurrentUser = "CR" Then
DoCmd.SelectObject acTable, , True
End If
What code is needed for the other six startup options?