Having trouble installing the Inventory Database?
First please read this handout on Checking the Trust Center settings in MS Access. If, after you have updated the setting, you are still having problems - look at this guide.
Follow this guide to fix the problem.
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.
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 issue is that the Trust Center Settings have not been set. Click here for a Resource Guide on how to set them.
If you are using an older (prior to 2021) version of the database the reason for this error may be that you are running a MS Access 32 bit version in a MS Office 64 bit installation. MS Office 64 bit is now the default installation. If your IT dept has upgraded your computer recently this may be the problem. Check out the notes below. Please contact us to get the current version of your database that will work on your computer.
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 ?
Prior to 2021 the Inventory databases were designed in MS Access - 32 bit version. This is the version of Office - not MS Windows (which is 64 bit). Since the beginning of 2021 the Inventory Databases will work with both MS Access 32 bit and 64 bit. Please contact us to get the most current version of the database installed.
OK - I have Access (Office) 64 - what do I do ?
All the current versions of the databases will work with both MS Access 32 bit and 64 bit. Please contact us to get the most current version of the database installed.
Call: 855-468-8247 (9 am to 4 pm Pacific Time)