Access - Form

[Maria]

How can i protect the design of a form but allowing users to edit/enter a new
record?

 

[Danny J. Lesandrini]

convert your mdb into an mde

 

[Maria]

Please explain further.... Do I change the name of entire database from mdw
to mde..... Does this allow the users to edit and enter new records.....

 

[Damon Heron]

"You" don't change the name. Access has a procedure 'Convert to mde' . It
sounds like you need to bone up a bit on Access, though. Have you compiled
your db to catch any problems?

Damon

 

[Maria]

I am not very good with this part... I see where it converts it to an mde.
Can you explain what it does... Will it split the database??? Explain
please...........

 

[Albert D. Kallal]

How can i protect the design of a form but allowing users to edit/enter a
new
record?

You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you
do not have to bother setting up security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html