Hi guys n dolls,

I have created an access database to help out with a little project we have going at work. I've got my pretty form going, all is well. EXCEPT the users have access to the tables. Instead of opening the form, a couple of people are opening the tables behind the form and editing that way. Pretty dangerous because the form has some important fields locked, but the fields are being updated directly to the table by dirty cheats.

I've never used access before. How can I stop this?

No can do, I'm a public servant. Cant do anything but use what is already available. Have a perfectly good DB2 server sitting there but not allowed to create schemas or tables. Not even an index.

At full speed I think we'll only get a max of 8 users, currently 4. I have a scheduled task taking backup copies every 4 hours. Thats the disaster mitigation plan in its entirity.

Ahh access will be fine for a small database. What you might want to do is lock the file so only the form can be accessed.

If you go to tools then startup you can make your form startup by default.

Then you can choose not to Display database window,

To get to this you can use the F11 key,

You can also de-select allow full menus

To get these hold shift whilst opening the database.

hopefully this will help.

-M

Thanks. Its definitely small. Only 2 tables, only 2013 rows. Will give it a shot tomorrow.