Copyright 2021  Costume Inventory Resources    www.costumeinventory.com
×
Menu
Index

C. Database errors and events

C.     Database errors or events
 
     Blank Reports and Results Screens
 
Most reports are designed to only print when the selected data is available to print.  If you do a search for All Costumes the Search Results report will print all records.  But if you do a search for “Costume Type” = “Belt” and Color = “purple” and you don’t have any purple belts then the Results screen will be blank.  Some reports may appear on the screen and be blank - that means that there is no data for that report at this time.
 
If you select to print a report of all costumes that need repair and no costume records are marked that they need repair - you will not get a report printed but a message that there is no data for that report and to try again.  This is not an error in the program - it is just telling you that there is no data for the selection you made.
    
     Receiving an Error Message     
 
We have tried to find and fix all bugs in the Theatre Inventory Database but occasionally we find a new one.  But there are several situations that can cause you to see a message from the program or MS Access - that may or may not be a bug.  In any case, please contact Costume & Theatre Inventory Resources to tell us the error so we can correct it as best we can.
 
Incompatibility issues:  The current version of the Theatre Inventory Database requires MS Access 2010 or 2013.  If you have MS Access 2007 it will not be able to open the database and display the forms.  Your data (Costume records, props records etc) is unaffected by the change and you will not harm the data by opening it in 2007 - you just won't be able to use the forms to get to it.  Contact us for more info on how to upgrade your MS Access.
 
Macro Error: This can be caused by two things - 1) there is an error in the program (the famous bugs!!)  or 2) the database has become corrupted and the code will not work.  This can happen if you open the database with MS Access 2007 and 2010. In either case contact Costume & Theatre Inventory Resources for an update or a database recovery.
 
New for Version 4 - if the program will not start the first time you try it and you get several “Macro errors” it may be that the dbPix30.exe file did not install properly during the program installation.  Often if your computer or network have a lot of security the dbPix program will not install automatically.  Go to the folder where you placed the database and double click on the file dbPix30.exe.  Follow the installation instructions.  Do not worry if you see it says “Evaluation copy”.  The software is fully licensed and the license information is embedded in the Theatre Inventory Database.
 
..... Scripts....  This error usually appears when the workstation has lost contact with the network - even for just a second or less.  They can usually be resolved by closing the database and reopening it.
 
“Theatre Inventory Database” is not a database  - this happens when the database gets corrupted.  The database can become corrupted by shutting down the computer before the database has finished closing down.  The Theatre Inventory Database is designed to do a Compact and Repair the data tables file every time you “Exit” the program.  This may take a few seconds or up to 2 minutes - depending on the size of the database file.  Please check the lower right side of the screen to see the progress of the query that compacts the database when it closes.  Please contact Costume & Theatre Inventory Resources to see if we can recover your data.
    
Records show #Deleted instead of data: This can be caused by the database losing connection to a network or being shut down while the record was being written to the hard disk.  Please contact Costume & Theatre Inventory Resources to see if we can recover your data.