Hello all. please advise. My problem:

i have one table and a form which are related. you input stuff into the form it puts ot on the table. plus i have a menu sytem that has 3 main parts. main menu - which gives you the option to veiw data or add/amend data and one to exit access.

if you choose the add/amend data it will take you to the "input form" (mentioned above) but i would like to password protect that form so that only people with a password can add/amend the data without having to creating different profiles.

also i would like that when you click on the veiw data i would like it so that you cannot change the data on the table. eg read only. but if (which i cant find out how to) i made the table read only that means the input form would not work.

now Nomme suggested to get round my second problem i created a query and put all the fields in the query and then make that the "view data" option. but i cant figure out how to make the query read only.

does any on have any ideas??

when you have created the form and query, goto Design view of the form, and go to Properties.
In the All section, there's "Allow Edits", "Allow Additions" and "Allow Deletions" options. Set these to No, and job's a good un!

Re: password
AFAIK, you can only set a password on the database when it opens up, not on individual screens.
You may be able to put one on if you know any VBA, but I'm not sure at all.

do your databases in Access and your frontends in VB... doing forms in Access is really sucky... you cant get nowhere near the functionality you can in VB

True, but it's not really worth learning VB just to do 1 database.
I think Access should be suitable for this instance, if Fletch is ok with the password thing.

As a 'VB Veteran' yes, it's what you use for 'professional' systems but for prototypes and systems being developed by end users Access is more than adequate in most erspects.

You can only use the Access built in password functionality on databases as a whole.

To protect a form the easiest (though not foolproof) way is to have a bit of VBA code that runs on the Form Load event.

I'll have a little play and see if I can do something....

Joe