View source for Errors

==General Errors==

===Error 52===
Error 52 - Bad file name or number

Similar to Error 53, it generally occurs when using EXE tags as the print job is sent directly to the LPT1 port. If using a printer on a different port such as USB, the printer needs to be shared and mapped to the LPT1 port. Once mapped, it will now accept traffic from the LPT1 port. This error is caused by trying to send the print file directly to LPT1 when it is not available or disconnected.

See [[Tags#Printer Mapping to USB|Printer Mapping to USB]] for more details.

===Error 53===
Error 53 - File not found. 

====Tag Printing====
When using EXE tags, the print job is sent directly to the LPT1 port. If using a printer on a different port such as USB, the printer needs to be shared and mapped to the LPT1 port. Once mapped, it will now accept traffic from the LPT1 port. 
See [[Tags#Printer Mapping to USB|Printer Mapping to USB]] for more details.

====File Browser====
When trying to use the file browser to add images or link data paths, the workstation needs to have MemCpy.dll installed to use the file browse buttons. 

To fix this, copy [[File:MemCpy.dll]] and paste it in your C:/Windows/System32 folder. This will need to be done on all computers experiencing the issue. For 64 bit machines, put it in the C:/Windows/SysWOW64 folder as well.

===Error 75===
Error 75 - Path/File Access Error
Tag Printing Path Issue, see [[Tags#Printer Mapping to USB|Printer Mapping to USB]] for more details.

===Error 76===
Error 76 - Path Not Found

====Opening Reports====
The reports startup is incorrect. Go to Maintenance->System->Store Setup and check the Reports Startup field. Refer to the following examples to correct the path. For custom installations, other paths may be required.

=====2008 Version, 32 Bit Computer=====
"C:\Program Files\Microsoft office\Office11\MSACCESS.EXE" /Runtime "C:\Executive\ExecutiveReports.mdb" /WrkGrp "C:\Executive\system.mdw"

=====2008 Version, 64 Bit Computer=====
"C:\Program Files (x86)\Microsoft office\Office11\MSACCESS.EXE" /Runtime "C:\Executive\ExecutiveReports.mdb" /WrkGrp "C:\Executive\system.mdw"

=====2007 Version, 32 Bit Computer=====
"C:\Program Files\Microsoft office\Office11\MSACCESS.EXE" /Runtime "C:\Program Files\Executive\ExecutiveReports.mdb" /WrkGrp "C:\Program Files\Executive\system.mdw"

=====2007 Version, 64 Bit Computer=====
"C:\Program Files (x86)\Microsoft office\Office11\MSACCESS.EXE" /Runtime "C:\Program Files\Executive\ExecutiveReports.mdb" /WrkGrp "C:\Program Files\Executive\system.mdw"

====Tag Printing====
Tag Printer Path Issue, see [[Tags#Printer Mapping to USB|Printer Mapping to USB]] for more details.

===Error 94===
Error 94 - Invalid Use of Null

A required field has been left blank. If printing something customer related, check the customer profile and ensure that the Customer Type is not blank. If it is blank, set it to Retail and try printing again. 

===Error 429===
Error 429: ActiveX component can't create object

This error can occur if one of the components needed by the program is not registered correctly or is missing. It may point to a component of Access that has been modified, such as by installing Office 2007 over top of Access 2003 Runtime.

Try the code below if it's believe to be a registry issue, if not, try using the [[Downloads#MS Access 2007 Runtime|Access 2007 Runtime]] instead as it may not have the same registry issues.
{code}regsvr32 scrrun.dll
regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.dll"
regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.dll"{code}

===Error 2001===
Error 2001 - The previous operation was cancelled

The ReportsExportPath column is missing in the setup file. This error generally comes up when trying to open reports. Find a correct setup file on a workstation that doesn't have this error, and then replace problematic setup file to resolve the issue.

===Error 2046===
Error 2046 - The command or action 'save record' isn't available now.

This is generally given after a message that a Job Bag is locked by a user/computer. To unlock the Job Bag, reopen and close it from that user/computer, then retry from the initial workstation.

===Error 2114===
Error 2114 - Error 2114: Microsoft Access doesn't support the format of the file "filename", so it can't load the picture.

The Microsoft Graphic Filters are required to view images in MS Access. If the workstation doesn't have Microsoft Office installed, the Graphic Filters need to be installed manually, see [[Downloads#Graphic Filters|Downloads]] for more information.

===Error 3027===
Error 3027 - Cannot update. Database or object is read only.

The file in use is being restricted to Read Only, but requires Read/Write permissions. Grant 'Everyone' Read/Write Access on this file (for example, ExecutiveReports.mdb), and reopen the file to ensure permissions are now correct. 

===Error 3043===
Error 3043 - Disk or Network Error

The network connection or drive mapping is not finding the data file on startup. Try going to Computer (My Computer in XP), locating the mapped network drive, and double clicking it. 
* If it connects without issue, try opening Executive again, as the connection should be restored
* If it fails, the server may not be turned on or something may be preventing connection such as a permissions issue
* If the mapped network drive isn't showing up, it will need to be remapped. See [[Mapping Network Drives]] for more information.

Go to Maintenance->System->Link Data and ensure that the paths are all correct, as they must be pointing at valid files.

===Error 3044===
Error 3044 - Item isn't a valid path

The network path is not finding the desired file. Refer to [[Errors#Error 3043|Error 3043]].

===Error 3051===
Error 3051 - The Microsoft Jet database engine cannot open the file (name). It is already opened exclusively by another user, or you need permission to view its data. 

====Compacting Data====
During data compacting, this means that the file is open on another workstation. Since compacting the data requires everyone to be out of the database, the other workstation must exit Executive before compacting the data. Log everyone off and try again.

====On Startup====
On startup, this error warns that permissions are not set up correctly. 
* Try logging onto Windows as Administrator. If the error doesn't appear, it is due to a user permissions issue.
* Ensure that the local Executive folder allows full read/write access to Everyone.
* Ensure that the server's shared folder allows full read/write access to Everyone for Executive files. For more information, see [[Mapping Network Drives#Sharing Server Folder|Mapping Network Drives]]

===Error 3075===
Error 3075 - Syntax error (name) in query expression

===Error 3086===
Error 3086 - Could not delete from specified tables

When encountered during startup, it generally points to a permissions issue, refer to [[Downloads#Error 3043|Error 3043]]. Once everything is set up properly, relink the data and restart Executive. 

===Error 3343===
Error 3343 - Unrecognized Database Format

When opening Executive, this error warns that the database may be badly corrupted. Backup your file and compact it, to confirm the corruption. Restore from your latest clean backup, as the file likely cannot be repaired.

This is typically caused when the Jet database engine was improperly shut down during the process of writing to disk, such as the program being shut down unexpectedly, power loss, or network loss.

==Other Issues==
===Desktop Shortcut not working===
If the desktop shortcut to open Executive isn't working, Right Click it and Click Properties. Find the Target field. May need to scroll left and right to read the entire thing. Compare it to the following paths and verify that the existing path is correct based on your setup.

====2008 Version, 32 Bit Computer====
"C:\Program Files\Microsoft office\Office11\MSACCESS.EXE" /Runtime "C:\Executive\Executive.mdb" /WrkGrp "C:\Executive\system.mdw"

====2008 Version, 64 Bit Computer====
"C:\Program Files (x86)\Microsoft office\Office11\MSACCESS.EXE" /Runtime "C:\Executive\Executive.mdb" /WrkGrp "C:\Executive\system.mdw"

====2007 Version, 32 Bit Computer====
"C:\Program Files\Microsoft office\Office11\MSACCESS.EXE" /Runtime "C:\Program Files\Executive\Executive.mdb" /WrkGrp "C:\Program Files\Executive\system.mdw"

====2007 Version, 64 Bit Computer====
"C:\Program Files (x86)\Microsoft office\Office11\MSACCESS.EXE" /Runtime "C:\Program Files\Executive\Executive.mdb" /WrkGrp "C:\Program Files\Executive\system.mdw"

If you are unable to find the error on this page, you may want to refer to http://www.iasonline.com/john/pcsa/fixes.html for similar Access Error explanations.