Access Security

[High_D]

Someone at work here created a large DB in access and wants to share it on the network. He created a form to allow easy manipulation of the fields, but now I need to try and lock it down so people can't enter Datasheet view, or modify the tables.

Can this even be done while still allowing the user to modify fields?

[Deniz]

yeah, you can, even in access... it involves creating forms, macros and what have you but its not recomended (ie in my opinion they are a very amateur way of doing it)

Get a copy of Visual Basic and just use one of the wizards to make a simple application. It'll do all the coding for you and you dont need to be a rocket scientist to do it.

Make sure you use legal software.