access data base form question

[Glenwood]

Okay. I have 2 databases. One is password protected and is saved .mdb for my use only. The other is for all to use saved as .mde. There are forms .mde linked to tables in .mdb. I want it so that someone goes into .mde enters form info close database. That info flows to .mdb and stays. Next user opens .mde and form is blank they enter info, close out and again that new info flows to .mdb with 2 records now. So on and so on. Only time records are taken out of .mdb is when I do it with my password. So far i am linked but .mde shows each record previously entered and current user of .mbe could alter prior records. If I make a form that only allows a single entry (and does not show the rest) how do I design a form so that when the db is closed the infor flows out. I am a newbie with some classes. Thanks.

[Tigger]

Unless I am missing something, you can set the form attribute to Data Entry. The only time a previously entered record would appear would be during the same session.

Go into the Property Sheet at the form level and set Data Entry to Yes (default is no). You can also select whether or not you will allow Edits or Deletions.

[Glenwood]

that did the trick, someone told me that I had to make one of the databases an .mde, the one everyon would use, is that really needed, and what does changing it to .mde do? thanks again, that was the last little piece needed for my first access program.

[NTC]

Going to mde makes the FE not design-able. In the simplist sense.

A user will not be able to put any of the forms/objects into design view. It really is only an issue/recommendation if you have users that would do such a thing with some troublesome intent.

Some designers release mde as a matter of routine just to keep users out of it. Others never do because users aren't interested in the behind the scenes aspects.