Frequently Asked Questions – Access Databases

Trial Version

The trial version of the software provides a better idea of the software operation before being purchased. Trial version has all the functionalities like the unrestricted version. Note: Trial version is restricted to raise five records and reports.

You can download a trial version instantly by pressing the Trial button from the site. No personal information is required. You can save the trial database in your hard drive (shared) like any other Access database before use.

Note: It is recommended to delete the trial version before using the unrestricted version in order to avoid any possible confusion.

Trial version has the restriction to raise five records. We believe this limitation is fair to test the functionalities of the software. If you would find the software is useful and fits your purpose, you may purchase the unrestricted version from the site with affordable one time cost.

We will be happy to demonstrate the hands on software operation if that is preferable to you. Please let us know your preferred time and location. We can organize a webcast presentation for you.
Although the trial versions have the complete set of functionalities as those of complete versions, trial database can not be modified. Those are compiled databases with .mde extension. On the other hand, the complete versions (.mdb) can be modified through reprogramming after being purchased. No other limitation applies.

General Software Operation

The development team of Lean-Q software has long years of industry experience specially on the quality and compliance systems for the life science industries. All lean-q software applications have built in features such as strong user authentication, record change management, audit trail, electronic signatures with real time stamping, capable to hold large database, separation of duties by authority etc. For details of the Lean-Q systems GMP compliance please refer to the link GMP Compliance.

Lean-Q team will be delighted to adapt all constructive suggestions to make the software applications more GMP compliant within the scope of the industry.

Absolutely. The records and reports generated through Lean-Q system are permanent, and retainable for the complete life cycle of the application. The reports generated by the software are accurate, reliable and can be converted to commonly known document formats (such as pdf) and exported to local hard drive easily in a single click.

Lean-Q software applications are designed to document investigational information which were collected and analyzed in real time. The built in electronic signature management capacity can authenticate the investigation information and the electronic records. Consequently, the records and reports can be used for GMP audit purposes.

The software will work in a network environment. Each unrestricted version of the database is split into two files. For example, when you will download the Out of Specification investigation database, you will receive two files. One as CCM-be.mdb file and the other is CCM.mdb file.

These two files MUST be kept in the same folder in order for the linked tables to work.

CCM-be.mdb is the backend of the database that contains the tables only.

The CCM.mdb is the front end which is linked to the backend tables where the records are kept.
The splitting of the database is recommended when a database is used in a shared environment. This also makes it possible to use the software in a network environment.

After the software being downloaded, unzip the files (CCM-be.mdb and CCM.mdb), copy and save the files together into two separate locations. For example, one set should be saved in a backup folder as a backup and the other set should be in a shared location from where every user will access the software.
 
The database is designed to replicate the working file data into the back up copy as long they are kept in the same network environment. In case, the file in the shared network (working) will get lost or be corrupted, the back up data will be allow to continue to work.
Yes. You must keep both _CCM-be.mdb and CCM.mdb files in the same folder for running the programs. Follow the same for oher databases.
 
 
.mde files are compiled version of the software. In order to keep the trial database project secure and protected from unauthorized changes, the trial databases are compiled into .mde format. This is extremely useful for running the software without unwanted error.
 
 
The default administrator password for all database is ‘newuser’ to start with. It is strongly recommended to change the Administrator password as soon as the software will be activated.
 
 
Yes. The password length must be between 6 to 12 characters. Password must contain a combination of letter and number in the format. It is highly recommended to keep the Administrator password secure and retrievable.
After changing the password for Administrator, the next step is to setup new users. Admin must setup new user adding their first name, last name, work position and a password. Without a password the new user will not be able to access the database.
 
Users are strongly recommended to reset their password which was initially set up by the Administrator. The new user password will replace the initial password and will remain anonymous to Administrator.
 
In case the user would have difficulty to remember their password, the Administrator can set up a new password for the user which can be changed again by the user.
As opposed to individual Access databases, the Lean-Q system integrated module is developed in MS.NET environment.
 
Lean-Q integrated quality systems software is a strongly GMP validated application where all modules are integrated into one single interface. The modules are Product Complaint Management, Deviation Management, Change Control Management, Corrective and Preventive Action, Out of Specification Management. Lean-Q integrated software is fully compliant to FDA 21 CFR Part 11 requirements. The software is only available for subscription. The evaluation version is available to download from the site http://www.lean-q.com/Trial.html
Once a record or part of a record is signed and saved, the record locks itself and can not be edited further until the user sign off for the change of the records. This is designed to keep the authenticity of the record and forces the user to perform due change management before changing a GMP information.
 
In order to change a record, please go to the Change window located at the top of the application, select the name of the section where you want to make the change and Submit. A sign off window will appear. Write your comment on reason for the proposed change and press OK. The section off the record will unlock for edit.

No, you can not delete a user from the system. We have found the option to delete a user may compromise the accountability of a GMP record. In order to maintain the GMP records with proper authenticity, users name and credentials should be kept on the system for the time a GMP record should be legally retained.

Only the Administrator has the privilege to delete a record. From time to time, records may be raised in duplicate or deemed unnecessary. In those situations, it may be necessary to delete the blank record from the system. As a result, we have designed to give Admin the permission to delete the unnecessary record.
 
 
Audit Trail keeps the workflow history/log of a record. This is generated as a stand alone report for any single record selected including the comments for completing a step, comments for record change, the user’s name, date and time of signatures who has performed the action on the record.
 
Audit Trail is the second report from the top of the reporting section of each module.
The Lean-Q software systems are copyright protected under the trade name license of Lean-Q ® and Gmpqualityup is the sole owner of the intellectual property of the Lean-Q systems.
 
It may be a violation of copyright protection in the case of modifying, unauthorized sharing and duplicating the system or use of Lean-Q system for any kind of unauthorized activities with an intention to benefit commercially without the written expression of the sole owner Gmpqualityup.
 
For more copyright restriction please visit our site at http://www.lean-q.com/Termsofuse.html

Purchases and Payments

You can purchase an unrestricted version directly from our site shopping cart. The software files are available for instant downloads as soon as the payments are made successfully.

You can purchase more than software by adding those in our shopping cart. All files will be instantly downloadable as soon as the payments are made successfully.
No. A single copy of the Access database can be used by as many users as any single entity has. Purchasing more than one copy is not necessary.
Due to the nature of the electronic files we do not have a return policy to reverse a transaction unless there is a reasonable explanation for refund. We would suggest the potential user should test the trial version into their systems before attempting to purchase the complete version of the database. Hence, the chance of mishandling of the files will be reduced.
 
However, there is always unhappy buyer or some buyer may change their mind after purchase. We would suggest those buyers to notify us their true concerns. We may try to organize a refund.
We accept Paypal as our primary payment method. The purchased databases are instantly downloadable when purchased through paypal. Payment through credit card without using Paypal is also possible. In that case we will raise an electronic invoice and email to your address. You will be able to pay securely by coming to our site. When the payment is successful, we get instant notification of the payment and send you the complete version over the email.
 
On special circumstances we also accept payments made through wire transfer or by cheque.
Regretfully, some countries are still not listed in Paypal. Users in those locations can not make payments through Paypal. In such cases we can raise electronic invoice as described above. Bank wire transfer or cheques are also acceptable.
 
 
Payment through credit card without using Paypal is possible. In that case we will raise an electronic invoice and email the invoice to your address. You will be able to pay securely by coming to our site. When the payment is successful, we get instant notification of the payment and send you the complete version over the email.
Sometime payments can not be made successfully by credit card. In many cases credit cards have limitations imposed by the card issuing authority. Please contact your card issuer for such instances. Also please notify us for an alternative way of payments.
We accept wire transfer as long the fees are adjusted in the final payments.
In general the download links remain active for 5 days. We expect the user will be able to download the files within that period. If you would find the download link has expired and you were not been able to download the file, please let us know by going to our contact page quoting the transaction ID. We will send you another link as soon as possible.
We need to know your transaction ID before sending a replacement file. However, for the sake of security of your data, it is always prudent to keep adequate back up files which would cover your back at the time of need.

General Troubleshooting

Please let us know as soon as possible. We will try to resolve. If the trial version would run without an issue in your machine, so will the complete version.
Please notify us possibly with screenshot of the error message as soon as possible. Although, no stone unturned during our testing of the databases, we can not 100% guarantee that there will be absolutely no error. However, we can assure you that there is no error in the existing version that will prevent the applications from working. If there is evidence of error in the system, we will rush to upgrade the database for all future users and send you the updated version immediately.
Of course, we will fix any problem or bug in the software which you might encounter while running the application. As we have mentioned earlier if the trial version would run without an issue in your machine, so will the complete version.

The answer is yes. We will be delighted to get a customization requirements from you and work to change the software only for your use. Customization cost can not be covered by the price stated in the website. There will be reasonable development cost depending on the degree of customization.

Of course you can contact us either by email or phone. Our preferred way is to communicate through email. Our dedicated team will answer your query in less than 24 hours.