Hi all.
I need to build a database application for my office, but it has to be done in Access with no VB or other environment, in other words using the forms in Access.
The database will be accessible to only a few people over the office network, and will be a place for everybody to upload data via an input form, or view reports.

The questions I have are about the architecture. I've only ever made Access databases for individual use.

How can I have the central database in a location where people can't see it, but still have access to the data, both read and write? Would it be one central database and then an individual database for everybody else? How would I link them, or have one point to the other? How could I password protect the central db so that people don't open it and damage the data tables, and at the same time still have the local access not reveal that password somewhere in the VBA?

If I have it all wrong, just ignore the above questions.
Basically, I need a central database, limited access by multiple users over the network, and the forms in Access as the interface.

Can somebody give me the broad strokes?

Thanks.