Execute Only Database

[mbrinser]

I have finished my first database and I would like to create an execute only database in order to disable a lot of the functions. I have a login screen that allows the user to select who they are, however in the execute only database when i select the user and hit "enter" nothing happens, what am I doing wrong?

 

[mbrinser]

I have finished my first database and I would like to create an execute only database in order to disable a lot of the functions. I have a login screen that allows the user to select who they are, however in the execute only database when i select the user and hit "enter" nothing happens, what am I doing wrong?

 

[Poppa Smurf]

I would like to create an execute only database in order to disable a lot of the functions.

What do you mean by the above?

In your execute only database is the functions menu items or code? If it is code these your execute only database will not work.

In your Login screen, do you have an event to trigger when you click the Enter button if so, step through the code to see if the code works.

 

[HiTechCoach]

Are you using 2007?

 

[mbrinser]

I was able to get get rid of the shortcuts, however somewhere along the way I also got rid of the access options button and now I can't get to some of the functions I would like to touch up a few things. What is the keyboard shortcut to get that back?

 

[Lightwave]

In access 2003 you hold down Shift key when the database is opening up and you get into the database window.

Unfortunately users can do this as well

 

[oumahexi]

In access 2003 you hold down Shift key when the database is opening up and you get into the database window.

Unfortunately users can do this as well

That's why it's always advisable to give users a compiled version of your db.

 

[vbaInet]

In agreement with oumanhexi, you should package your solution making it a runtime database if it's a single user db. Google how to deploy ms access database.

In access 2003 you hold down Shift key when the database is opening up and you get into the database window.

Unfortunately users can do this as well

You can disable this function by creating an application property with code.

 

[mbrinser]

Thank you for all those posts, I'm just about there. I've created a custom ribbon showing the filter and sort options, however, the options to sort are grayed out and I can only filter, what am I missing?

 

[vbaInet]

Where are the options? On the ribbon?

If you have included idMso's they will only became available when the function can be used, so maybe you need to rethink your approach.

 

[mbrinser]

Yes the options are on the ribbon, how else can I allow the user to sort the data?

 

[vbaInet]

If you are referring to the standard filter then your form has to be in Datasheet view.

 

[mbrinser]

So I can't do a sort in a report?

 

[vbaInet]

No. If the button is not enabled, then you can't use it for that particular view. The only reason why you can perform some filtering is because Access hides the rows that do not macth the filter. For a sort to take a effect, the recordset must be changed (with the new sort) and the report reopened.