Access is a multi user system, the number of users it can support withiout problems varies (with system design, data storage mechanism and may other things). if you are going to support only 6 users then standard Access shoudl be fine
however table edits could be a problem, I'd suggest you use a form for this purpose. I'd also suggest you tie everything together with a menu or swicthboard so your users are not encouraged to dabble with things they shouldn't
I'd suggest you deploy the application in two parts. the back end contains all the tables, the front end contains all the user interface forms, queries & reports. I'd suggest the front end is deployed as an MDE (MDE means they users can't make changes). You probably also ought to deploy the live data as an MDE aswell. if you do go down the MDE route then make sure you keep your working copies of your MDB's as that how you make changes in the future (changes in MDB, export user copies as MDE).
There are some things you should do to each users copy of access, in the settings turn on record locking (NOT table, page or optimistic)
Im sure others will have some suggestions as well
if you want to test how access wors with multiple users, start another instance of Access either on your own machine or another and see what happens
I'd rather be riding on the Tiger 800 or the Norton