A good report tool, but I've seen it buckle too many times under load and user gaffes (security issues).
Is there any chance of a MySQL database which you can secure, then use Access or VB as the front end?
Another common failing is getting a design spec in writing.
I need some guidance!
We are planning on undertaking an Access project for our organization and are interested on what people think the best route to go is.
The database is stored on network drive where all persons involved in the process will have access.
The package is started:
The person?s personal information and specifics for package is entered into an Access table via form.
Access Report is generated (templated document where the above entered information is entered in the document)
Report is printed and physically signed
The above signed document along with the other supporting documents are scanned and placed on the network drive under the individual?s subdirectory
Now the package is complete and ready for review. Scanned files linked to Access automatically? Via VB perhaps?
Reviewing authority inputs specifics for authorizing endorsement (Access report)
The above, generated final endorsement is forwarded electronically (pdf?)
Authorizing Official electronically signs forwarded endorsement and fwds package back to originator