Greetings. We are Lab-Ally, a scientific data management company based in Columbus, Ohio, USA. We are working on a new project to integrate our 21CFR11 compliant scientific data, document and note taking solution with a client's MS access database. Our understanding is that they use Access to manage a list of chemicals and antibodies and other materials. Even though we have quite an experienced team of JAVA developers, slightly embarrassingly, we know basically nothing about MS Access and we are looking for an experienced user, or better yet a developer to help us. Naturally we can pay you for your time.
We are also looking for some creative suggestions from the community as to how we might easily try out a free or trial version so that we might better understand the scope of capabilities (of MS Access) and test some integration prototypes.
The client's request is relatively straightforward: they have a list of materials in MS access, and they want these to be painlessly imported and represented in the record keeping system that they bought from us. They would even settle for a way to simply reference the entries in MS access such that clicking something in OUR software would then open the appropriate record in MS Access.
Doubtless there might be other organizations using Access for whom this sort of functionality would be useful, so if your organization would like to integrate your access database with a 21CFR11 compliant system that captures the history of how items in your DB were used in the context of your processes and workflows, please contact us, we would value your input and we may have a solution for you.
This is our first post here, so feel free to school us on appropriate posting etiquette and maybe point us at the right sub-topic or related forum if you think this is not the right place for this request.