Frequently Asked Questions

Quirks

• This database is in an unrecognized format.
  http://support.microsoft.com/?kbid=946205
  When you try to open a compiled database file (.accde or .mde) or a compiled project file (.ade) in Microsoft Office Access 2007, you receive the following error message:
  
  This database is in an unrecognized format.
  
  The database may have been created with a later version of Microsoft Office Access than the one you are using. Upgrade your version of Microsoft Office Access to the current one, and then open this database.
  This problem occurs if the compiled database file or the compiled project file was created on a computer that has the 2007 Microsoft Office suites Service Pack 1 (SP1) installed.
  This problem occurs when you try to open the file that you created, and the following conditions are true:
  
  You try to open the file on a computer that has the original version of Access 2007 installed.
  The 2007 Office suites Service Pack 1 is not installed on the computer.
  
  To resolve this problem, install the 2007 Office suites Service Pack 1 on the computer on which you are trying to open the file.
• Security Warning - this file may not be safe...
  When opening the tool in Microsoft Access 2003 and later, you might see one of several possible security warnings that the file may be unsafe. This is due to the Microsoft Access
  
  security level settings on your computer been set to High. Security settings restrict access to the database and are a result of new security features that were first introduced
  
  with Microsoft Access 2003.
  
  Really annoying, isn't it? To disable it;
  Access 2003 click menu options Tools > Macro. There's a Security flyout. Set the macro security to Low.
  Access 2007 has a better solution. You can specify trusted locations by using the Microsoft Office Trust Center (OTC).
  
• Cannot download install or upgrade (exe) file from website.
  This may be related to your internet browser, check if your security level is set to High.
  In Internet Explorer > Tools > Internet Options > Security Tab. Highlight Internet, click Custom Level, find File Download. If it's set to Disable, set it to Enable, click OK,
  
  then 'Yes' to the prompt asking if you're sure you want to change your security settings for this zone, then Apply, and OK.
  Or, if your slider is set to High,you could just move it down to Medium,if you don't want the Internet Zone set to High.
  
  All else fails I can send you a disc, but I prefer to avoid this option as it tends to be the computer security settings, and utimately, if the install cannot be downloaded you
  
  will have on going issues with downloading FREE upgrades.
  
• Access 2007 cannot recognize a custom shortcut menu bar in a form.
  From: http://support.microsoft.com/kb/942378
  
  The Microsoft Office 2007 Suite Service Pack 1
  Service Pack 1 fixes includes the following issue;
  
  - Access 2007 cannot recognize a custom shortcut menu bar in a form
  When you open a custom shortcut menu bar in a form in Access 2007, the shortcut menu is missing. Additionally, you may receive an error message that states that the shortcut menu
  
  does not exist when you open the database again.
  
  To download The 2007 Microsoft Office Suite Service Pack 1 (SP1) goto:
  
  http://www.microsoft.com/downloads/details.aspx?FamilyId=9EC51594-992C-4165-A997-25DA01F388F5&displaylang=en
  
  Note: The above link may change without waring. In this case google 'Microsoft Office 2007 Suite Service Pack 1' for download location.
  
• Attaching tables with URL.
  To connect to remote data you need to map a network path ( see instructions below ) as URI ( Universal Resource Identifier such as \\Asusz53\ ) are not recogised when trying to connect the data tables.
  Ensure that the folder is correctly set up for sharing on the remote computer.
  
  How To Map a Network Drive in Windows Using Windows Explorer
  Windows supports several different methods for mapping a network drive. A network drive is a file folder located on a remote computer that has been configured for sharing over a LAN (Local Area Network). These instructions explain the process to map a shared network drive using Windows Explorer.
  
  1. Open Windows Explorer or My Computer from the Windows Start Menu.
  2. From the Tools menu, click Map Network Drive. A new Map Network Drive window opens.
  3. In the Map Network Drive window, choose an available drive letter from the dropdown list located next to the "Drive:" option.
  4. Click Browse to find the correct folder by browsing available network shares.
  5. Click the "Reconnect at login" checkbox if this network drive should be mapped permanently. Otherwise, this drive will un-map when the user logs out of this computer.
  6. If the remote computer that contains the shared folder requires a different username and password to log in, click the "different user name" hyperlink to enter this information.
  7. Click Finish.
  8. If the Finish operation succeeds, the network drive will be mapped. If the network drive cannot be mapped, ensure the folder name is spelled correctly, that this folder was correctly set up for sharing on the remote computer, that (if necessary) the correct username and password have been entered, and that the computer network connections are functioning properly.
  
• Q. How do I disable 'Open File - Security Warning' when running downloaded files?
  A. Follow these instructions:
  1. Run gpedit.msc
  2. Go to Local Computer Policy >
  3. User Configuration >
  4. Administrative Templates >
  5. Windows Components >
  6. Attachment Manager.
  7. Enable 'Default risk level for file attachments'
  8. Enable 'Inclusion list for low risk file types'
  9. Add '.exe' to list of file extensions that you want to open without triggering message.
  Note: This action compromises your system security."
• Q. How do I download exe file upgrades from the website, what is the problem?
  A. On Internet Explorer menu go to Tools menu > Internet Options > Advanced tab, you have the check marks taken out of 'Enable install on demand' or 'Allow software to run or install'.
  
  This may be related to your internet browser, check if your security level is set to High.
  In Internet Explorer > Tools > Internet Options > Security Tab.
  Highlight Internet, click Custom Level, find File Download. If it's set to Disable, set it to Enable, click OK, then 'Yes' to the prompt asking if you're sure you want to change your security settings for this zone, then Apply, and OK.
  Or, if your slider is set to High, you could just move it down to Medium, if you don't want the Internet Zone set to High.
  Or launch Internet Options from Control Panel. Click the Security tab. Select the Internet zone. Click the Custom Level button. Scroll down to the Miscellaneous group. Find the item 'Launching Applications and unsafe files'. Is it set to 'Disable'? Then change it to 'Prompt' and click OK.
• Q. How do I download exe file upgrades when they are not downloading from the website?
  A. Click Internet Explorer. Choose Tools menu > Internet Options > Advanced Tab. Click the boxes for Enable Install On Demand or Allow Software To Run Or Install or Allow Software To Run Or Install Even If The Signature Is Invalid.
• Q. How do I stop the message 'Security Warning - this file may not be safe…'?
  A. When opening the tool in Microsoft Access 2003 and later, you might see one of several possible security warnings that the file may be unsafe. This is due to the Microsoft Access security level settings on your computer been set to High. Security settings restrict access to the database and are a result of new security features that were first introduced with Microsoft Access 2003.
  
  Really annoying, isn't it? To disable it;
  Access 2003 click menu options Tools > Macro. There's a Security flyout. Set the macro security to Low.
  Access 2007 has a better solution. You can specify trusted locations by using the Microsoft Office Trust Center (OTC)."
• Q. 'Not A Valid Win32 Application' -how do I work through this file download message?
  A. Often this error message will be similar to the below error message.
  C:\Program Files\myprogram\program.exe is not a valid Win32 application.
  Possible Cause:
  File is corrupt.
  If the file you're attempting to run is corrupt, Windows will be unable to execute the file properly and will generate this error message.
  If you downloaded the file, delete the file and try downloading and running it again. It's possible during the download that the file became corrupted.
  Finally, if the second download does not work, it is possible we mistakenly uploaded a corrupt version of the file. Let us know of the file and we will check it's condition."
• Q. I can't do my things with Vista - HELP! How can I work with Vista security?
  
  A. User Account Control (UAC) is a new application in Windows Vista to manage user privileges. This Service is the reason you get a question every time you to install or manage programs in Windows Vista.
  Like Microsoft say: 'UAC can help prevent unauthorized changes to your computer. We recommend that you leave UAC turned on to help protect your computer.'
  If you feel you can manage without this invasive input you can turn UAC On or Off with the following steps:
  Start menu > Control Panel > User Accounts > Turn User Account Control on or off.
  Clear the 'Use User Account Control (UAC) to help protect your computer' check box to turn off UAC, and then click OK."
• Q. Does your software work on Mac?
  A. Our products are developed using Microsoft Access 2007 or later. Microsoft, in their wisdom, does not include Access in Office for MAC, Access only exists in Windows format.
  Why Microsoft exclude this powerful tool from Mac usage is a mystery to me.

Undocumented features

• Error 3044: 'Y:\myfilename.mdb' is not a valid path...'
  Is there an issue with the Y drive at time of opening Price-Cracker? To test see if you can open Notepad to create and write a file to Y drive? It is possible a networked computer
  
  was off at time of trying to attach to the data. Creating and writing a text file to Y drive shows that the computer is on, the drive is networkrd ( may haver been disconnected )
  
  and that the user has the required permissions to operate from the Price-Cracker comuter to the Y drive.
  
  Also check the file Price-Cracker_be.mdb is still on the Y drive and has not been moved or deleted.
• Error 3027: Can't Update:Database or object is read only Database.
  Error 3027 is to do with permissions to some part of the application. If the datafile has been moved to a network location check the NT file permissions are set to allow
  
  modification of the file?
  Locate the datafile (default: C:\MemberBase\App\ Memberbase_BE.MDB) > right click file > Properties > Attributes… check Read-only is unticked.
  If this doesn’t work a screenshot often points towards the cause.
  Take a screen shot ( Prnt Scrn button top right of keyboard) and paste to a Word Document. Send Document to [email protected] to remedy this issue.
  
  OR
  
  Microsoft Office can be installed with a trial version of Access that allows a limited number of sessions. After the trial sessions expire Access becomes read-only. If this is the
  
  case with yourself then the solution is;
  Remove the Access component of the Office installation and install the FREE run-time Access available from my website.
  How to:
  Start > Control Panel > Programs and Features > Microsoft Office. Untick to remove the Access component of the installation.
  Go to my website and download Access run-time. and install. Note: SAVE download to computer and run from computer.
  Even if you have previously installed the run-time, the removal of the Office component will require you to re-install the run-time version.
  Let me know how you get on.
• Error 3073: Operation must use an updateable query.
  sAdminUpdateBoolean : adm_ShowReportMSG
  
  To add file and folder permissions on XP
  
  To allow another user on your computer (logged in under his or her own account), or on a computer connected to your network, to open or edit your files
  
  1. Click Start, and then click My Documents.
  2. Select the folder or files you want to set permissions for. To select multiple files and folders, hold down the CTRL key on your keyboard, and click each file or folder.
  3. Right-click the selected folders and files, and then click Properties.
  4. Click the Security tab.
  5. Click the user you want to grant permissions to.
  6. Select Full Control check box in the Allow column and click Apply.
  
  Now the people you specify will be able to open your files and modify your files.
  
  OR
  
  Microsoft Office can be installed with a trial version of Access that allows a limited number of sessions. After the trial sessions expire Access becomes read-only. If this is the
  
  case with yourself then the solution is;
  Remove the Access component of the Office installation and install the FREE run-time Access available from my website.
  How to:
  Start > Control Panel > Programs and Features > Microsoft Office. Untick to remove the Access component of the installation.
  Go to my website and download Access run-time. and install. Note: SAVE download to computer and run from computer.
  Even if you have previously installed the run-time, the removal of the Office component will require you to re-install the run-time version.
  Let me know how you get on.
• Error 287: Run-time error '287'.
  This is a result of application interacting with MS Outlook.
  While setting up the MemberBase email facility Outlook would have propmted;
  A program is trying to automatically send e-mail on your behalf.
  Do you want to allow this?
  If the user clicks no, the following error will occur: Run-time error '287'.
  A work around is on the MemberBase email setup screen, select from the 'Select Email Client' list Other.
  Enter the Other Email Client Settings. This will by pass Outlook.
  
• Error 3061: Too few parameters.
  This error was encountered when using our software on a computer with a Regional and Language setting that uses German.
  
  The value of ‘Wahr’ (not true) is passed as a Boolean value and broke the code. This is an issue of translation, as the software is expecting the English value of either True or False.
  
  Consequently we have discovered that our programs will function 100% only with Regional and Language options that use English.
• Error 3075: Syntax error (missing operator) in query expression.
  sAdminUpdateString - There is an apostrophe in the string value;
  "C:\Users\Bruce\Documents\APGC Secretary's Files\...
• Error 3271: Invalid property value.
  Error generated when query tried to update fields with data string >255 to a field size 255.
• Error 70: Permission Denied.
  Permission to Kill file is denied. Kill process errors as file is open. Call sKillProcess("Notepad").
• Error 55: File already open.
  Error 55 generally means a program or file associated with the program is being used and program does not have access to use it. Try closing all open programs and run program
  
  again.
  
  In our case it could be an attachment to the email is open, or a file did not close cleanly and is sitting in the computers memory, so as a mere mortal we think it is closed but
  
  the computer knows better.
  
  I recommend closing MemberBase and trying again.
• Error 42: Run as Administrator (Windows 7).
  Error 42 generally means a program or file needs to be run as administrator, this is your computer's way of asking you for more permission.
  Vista or Windows 7 is blocking execution. This error 42 .
  Here's what to do:
  Right-click file, choose Run As, or Run..., or Run As Administrator from the menu.
  Allow this or click Yes, then continue on with the activation.
  Right-click icon or StartApp.exe to initiate program.
  Permission is registered and program can be run from icon for subsequent usage.
• Error 2114: Run as Administrator (Windows 7).
  Doesn't support the format of the file 'C:\Documents and Settings\...JPG', or file is too large. Try converting the file to BMP format.
  
  Re the picture format I have two suggestions;
  
  1. Change the picture format to BMP.
  2. The path to the JPG image is rather long. One way to shorten this move images to C:\Price-Cracker\Images\
  In Price-Cracker+ you can edit the image path on the Recipes Datasheet screen. Using Ctrl + H you can Find ‘C:\Documents and Settings...\’ and Replace with ‘C:\Price-Cracker\Images\’.