How to create a Stand Alone menu

[Kijori]

I'm new to Access. I've created a simple table and some forms. What I want to do is to allow users to Add/Delete/Edit/View the database without opening MS Access. I don't want them to view the data in Table format. Sounds weird right?

What I did was create a Menu for the Users. Is there a way which I can save this Menu as a file and the users only need to click on this file to perform the necessary database operations? Meaning, they will be presented with the numerous Forms for data operations.

 

[chrissie1]

no not in acces
but there are 2 things you can do

1) rewrite in Visual basic or any other language

2) in access go to tools menu and then select startup unselect all checkboxes and you will see the next time you startup that the users cant change a thing, remember to set the menu form as startup form.
the next time you want to change you database open it while holding down the shift key "What a wonderfull world" - Louis armstrong

 

[Kijori]

will try this. thanks.