securing forms

[Dim]

Newbie question

I designed a form where i edit some data in a table...
but now i want to restrict access to the table and MAKE user
to use this form. this means that i somehow must disable access to table
itself and my form Design mode,
so when database opens i get my form in Run mode right away and it stays
that way

Thanks from a newbie

p.s. using access 2000

 

[Allen Browne]

Choose Startup from the Tools menu.

Uncheck the box for Show Database Window.

Enter the name of your form as the startup form.

Now when you start the database, the database window is hidden, and the user
just sees your form. You can set the AllowBypassKey if you want to stop them
holding down shift to bypass these settings.

To prevent the user moving to Design view, create an MDE file (Tools menu).