Making a form uisable by different people

[deb0and]

Hi

I have created a form that I would like to use, I remember years ago I could save the form as a program and send it to people to use. How do I do this in 2007. I would like to be able to send the DB to user and them to click on it, open it up and be able to fill out the details but I remember I used to do this witout having all the tabs and ribbons showing it was just the form that was visible.

Many Thanks

Andy

[rpeare]

the easiest way is to capture the username and use that to determine usage but you'd have to have a table within your database that stores the username and the access they are allowed to have.

UserName = Environ("USERNAME")

[June7]

If you want to disable the ribbon tabs, navigation pane, shortcut keys, that can be done with project settings.

Office button > Access Options > Current Database > select options as desired

Be aware that holding down shift key when opening db will override most of these optional settings.

If you want to publish the db as a runtime version that doesn't even show the Access application window, I think that involves fairly complex code.