Access and multiple user form - basic questions
Hello
I have posted this project in help on projects will excel or any other software but haven't received any advice as yet . On looking I want to have a user form that multiple users can fill in request and this gets saved into a spread sheet or DB
Can this be done in Access ? I have seen that a DB can be split into front end ( Access user form) and back end ( access DB) . The front end would have to be placed on the desktop of 40 networked pc .
Basic questions are :
- Do the 40 pc have to have access installed ?
- Only those that are collating the data would have to have the access lic ( its a $ issue ) is this correct ?
- can more than one user hit / access the form at the same time given the file is on the desk top
very introductory questions hope someone can provide guidance or where to find additional info
