mml
10-13-2020, 10:58 PM
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
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