Hi im in the process of starting a small project to be used at work. Basically I want an Access DB which will be used by about a dozen people, accessing it over a network drive. I want them to be able to do the standard create/edit/delete records and wotnot in different tables of the DB and also want some reports and search functions.

In the future I want room to make more advanced things in it.

Would I be best to do this all in Access with forms and reports, or maybe use VB for a frontend or even something else?

Dont have much experience with Access outside of the standard DB records stuff, will security and multi access be a problem with Access?

cheers