the final Touch for the database

[tarek_ta2ta2]

in the begining i would like to say thanks for every one in this form for the amazing support

i have my data base which consist of two tables and one form

now i want just the form to appear to the end user and not allow him to see the tables or even the access menus if this possible

in general i just the end user can't do anything except interact with this form

Note:
i'm a flash developer and this my first time in access
but because i need this so urgent i ask for help even i think this is not complicated as i think ... sorry

 

[twoplustwo]

Tools -> Startup -> Uncheck "Display db window" and uncheck the menus for toolbars etc.

 

[twoplustwo]

Oh, you'll prob want to create an MDE if you want to lock it down. Any stronger than that and I'm not your person to ask! I'm sure past splitting/creating an MDE/hiding the db windows somebody else can offer advice.

 

[tarek_ta2ta2]

Thanks for answering

but i work in access 2007 and i couldn't find this

Tools -> Startup -> Uncheck "Display db window" and uncheck the menus for toolbars etc.

 

[boblarson]

For 2007, it is the Round Office Button > Access Options > Current Database > Uncheck Navigation Pane and built in Ribbons.

 

[twoplustwo]

For 2007, it is the Round Office Button > Access Options > Current Database > Uncheck Navigation Pane and built in Ribbons.

That sounds rather fancy

 

[Pat Hartman]

You probably also want to create a custom menu that includes only the actions your users need and so you can get rid of the ribbon.

 

[tarek_ta2ta2]

Thanks ... and how to open my database in asignle window

thanks for the great help

but u encourage me to ask for more

if i want the user to just when he click the shortcut for my database program appear onlu window contain the form he will interact with it

or this not acceptable

 

[Pat Hartman]

There is no "Access" way to do that. you would need to use the Windows API. I don't have a code example but I have seen them posted here. Try searching for one.