Having trouble installing the Inventory Database?
Follow this guide to fix the problem.
Are you getting a "Query is Corrupt" message? This is caused by a MS Office security update on Nov. 12. Look for an email from us soon as we work out the fix for the problem - or call us: 855-468-8247.
Are you on a Windows PC?
Is MS Access installed?
All Inventory Databases run ONLY in Windows. Get the Resource Guide for instructions on Installing Windows on a Mac
Download the Free MS Access Runtime and install. After installing be sure to re-install dbPix. Click Here for Resource Guide.
- OR -
Ask your IT Staff to install MS Access 2010, 2013, 2016, 2019 / Office 365 on your computer. Be sure to know which version - 32 or 64 bit they are installing.
Are you getting any of these messages?
If you are still having issues then please call us at: 855-468-8247 (9am - 4 pm PDT) or
send us an email at : firstname.lastname@example.org
(Click on the image to go to the help message)
What is MS Access and How do I know if it is installed?
MS Access is a Database Application software that is part of the Microsoft Office package. (Not all installations of MS Office include MS Access - see below.) MS Access is only part of the Windows version of MS Office, it is not included in the Mac version of Office.
To see if MS Access is installed on your PC:
Windows 10 and Windows 8:
Click on the Windows button. Select All apps.
Look in the list - either under “A” for Access or “M” for Microsoft Office. Look for Access 2010, Access 2013, or Access 2016.
"A potential security concern has been identified"
This message is not an error - it comes up every time you open an Access Database with the Access Database Runtime program. There is no harm in opening the database. Click on "Open" to proceed with opening the database.
If this is a big concern for you or your IT Staff you can install the full version of MS Access and you will not see this message.
"Security Warning Some active content has been disabled."
This message tells you that the Macro Security settings are set too high. Click here for instructions on how to reset this.
If you have the database installed on a network this setting will have to be changed on all workstations that connect to the database on the network.
"Could not find file 'Theatre Inventory Database DATAONLY.accdb"
The Inventory Databases are actually two files. The database front end (forms, reports, etc) and a back end (data tables - called the DATAONLY file). When the database is installed the Inventory Database links to the DATAONLY. The Inventory Database expects to find the database in the folder: C:\Costume Inventory Resources\Theatre Inventory Database (or other database name) folder. If the DATAONLY file is not there you will see this message. It is very easy to relink the two files - you just need to know where the DATAONLY file is located. Click here for a Resource Guide to help you.
"There is no object in this control"
This is a bit cryptic but what it means is that dbPix (the image processing software that is installed with the database) has been un-installed or deleted from the computer. You can reinstall it easily following these steps:
Close the database and MS Access
Go to the folder - C:\Costume Inventory Resources
Find the database folder (Theatre, Pattern, Uniform, etc)
Look for the file dbPix30.exe (or some version of dbPix).
Double click on the file name and it will install. Accept all the defaults and finish the installation. If it tells you a new version is available - just ignore that proceed with the installation.
Restart MS Access and the database. The error message should not appear.
"There was an error compiling this function"
The most common reason for this error is that you are running a MS Access 32 bit version in a MS Office 64 bit installation. Most installations of MS Access are 32 bit but some schools and colleges are using MS Office 64 bit. Check out the notes below. If you still have questions, please contact us.
How do I know if I have the 32 or 64 bit version of MS Access (Office) ?
Click here for a Resource Guide which explains how to tell the version you have.
Trying to run an Office 32 bit database on an Office 64 installation ?
The Inventory databases are designed in MS Access - 32 bit version. This is the version of Office - not MS Windows (which is 64 bit). Most computers are running MS Access 32 bit but some schools and universities have installed MS Office 64 bit. The two versions (32 and 64) are not compatible (they won't play nice on the same computer). If your computer has the 64 bit version of Access, contact us so we can send you a link to download the 64 bit version. We do have a 64 bit version available but we prefer to only make it available to customers who have Office 64.
OK - I have Access (Office) 64 - what do I do ?
Contact us and we will send you a link to download the 64 bit version.
Call: 855-468-8247 (9 am to 4 pm Pacific Time)