Hi everyone,

Is there any way that makes MS access 97 up to display only a form when we double click on the access file? Any suggestion would be appreciated? Thanks a lot in advance.

Do you mean like a startup form. when the user clicks the access.mdb file; for it to open to a certain form?

If so,
open your database
--> select tools
--> Startup
Under Display form

select the form you wish to open when your database is used.

also look in other options available to you. Like hiding the database window.

FYI

Look up information for creating MDE database for access

Thanks jemacc. I can open the form and hide the database window, but I can't hide the background of MS access and the menu bar. Toolbars in Customize didn't allow me to uncheck the menu bar.

I want when a user clicks on a file, ONLY the display form will appear on the screen, nothing else, and the user can only use the button "find" to get information stored in the database, not add or delete a record. I did try the MDE and it worked well; however, since the menu bar is still there, the user can delete or add more record by choosing Edit on the menu bar. Do you have any idea?

Thanks again in advance.

Antoine

Try this:
http://www.mvps.org/access/api/api0019.htm

Steven

I am a loud man with a very large hat. This means I am in charge

However, There's a slightly easier option,

Have your startup form maximize on load, set it to be Modal, and the BorderStyle to be None

I am a loud man with a very large hat. This means I am in charge

Thanks a lot Steven. The easier option that you suggested works well. That's all I want to do with the file now. Thanks again and have a good day.

Antoine

Just as another option,
you might want to set the Shortcut Menu to No
This gets rid of the context menu when users right click

I am a loud man with a very large hat. This means I am in charge