You are welcome to post us your questions about our products and we enlighten them in our FAQ section.

• General FAQ Section


• What are the primary differences between DBConvert and DBSync series?
• Is it possible to run your product from the command line?
• Can I automatically run synchronization?
• What is Batch file and how to create it for DBConvert tools?
• Scheduled task doesn't work at all, even if the task is displayed in DBConvert built-in Scheduler. “Task has not been run” status is returned.
• I can’t configure Microsoft SQL Server 2005 Express. How can I overcome this problem?
• Does your product support Microsoft SQL Server 2008 EXPRESS?
• Does your program support Access 2007 file format (.accdb)?
• I discovered that the program doesn´t accept my registration info after restoring or updating. What is your update policy?
• I need to convert/synchronize my main database to the secondary databases. How many Licenses should I buy?
• What is 1 Site Wide License?
• What is premium support and what benefits it gives me?
• Will primary queries, keys/ indexes and foreign keys be converted as well?
• Is it possible to convert user defined data types?
• Why synchronization doesn’t work or gives an error?
• Why synchronization speed is slow?
• Data filtering is not working when I choose Drop synchronization option.
• Where I can find my logs and session files?
• Why my session is not stored?
• What maximum number of rows in one table can be converted?
• Do your converters allow to choose data fields?
• Do your converters synchronize in both directions?
• What types of DBMS are supported by your products?
• Everytime I run synchronization, it is not updating data which have been changed.
• I'm trying to connect to my remote database server via SSH Tunnel. I can't connect using an SSH tunnel created with Putty.
• My saved session doesn't synchronize a new table/row/column.
• How can I configure MySQL server for DBConvert?
• How should I configure permissions for MSSQL clients (machines) connections?


• DBConvert&DBSync for MS Access & MySQL FAQ Section


• DBConvert for MS Access & MySQL gives the following error: « Error 2003: Can't connect to MySQL server on 'localhost' (10061) »
• Error 1452: Cannot add or update a child row: a foreign key constraint fails.
• I get «Error 1005: Can't create table... ».
• I get «Error 1062 Duplicate entry '1' for key 1». What can I do?
• I get «ERROR 2013: Lost connection to MySQL server during query». How can I solve it?
• Runtime error 3044


• DBConvert&DBSync for MS Access & MS SQL FAQ Section


• How to connect to Microsoft SQL Server 2005 Express database


• DBForms from MS Access to PHP+MySQL FAQ Section


• How can I convert MS Access forms to a web-page?
• What additional software should I install for conversion with DBForms from MS Access to PHP+MySQL?
• Does DBForms from MS Access to PHP+MySQL support subforms and tabs?
• Why were the forms not converted?
• Does DBForms from MS Access to PHP+MySQL convert updated records in MySQL database?
• How can I create Front/Back Ends in order to remote users could log on to the MySQL database online?
• Error: «Member not found» in Access 97. What can I do?
• I get “Error No. 100 occured! MySQL connection failed! Please check your credentials! mysqlnd cannot connect to MySQL 4.1+ using old authentication” How can I solve it?
• Your program tries to process the non-existent queries in my database. How can I overcome this?


• DBForms from MS Access to ASP.NET + MS SQL FAQ Section


• What additional software should I install for conversion with DBForms from MS Access to ASP.NET + MS SQL?


• DBConvert for MS Excel & MS SQL/MySQL FAQ Section


• Conversion speed is slow when I convert from MS Excel file.


• DBConvert&DBSync for MS FoxPro Section


• When I convert .dbf tables, they are not displayed/displayed partially at the customization stage.
• I get a message dialog «There is an unknown exception oxd0000005 occurred in the application at 0x0c103d1p» every time I try to run the program to convert the free dbf files.

General FAQ Section

• What are the primary differences between DBConvert and DBSync series?

  All «DBConvert» versions convert data from source to destination database. If you don´t have a direct access to the server or have an ftp and PHP access through phpMyAdmin or other tools, «DBConvert» can create «Dump» and «PHP Script» files which contain database info inside and can be executed on the server for putting database there.
  
  You can find more details about conversion at:
  http://dbconvert.com/conversion.php
  
  «DBSync» versions can both convert and synchronize databases. It strictly needs the direct access to server. «DBSync» provides three types of synchronization:
  

  • Insert synchronization
  • Update synchronization
  • Drop synchronization
  
  You can find more details about synchronization at:
  http://dbconvert.com/synchronization.php

  ---

   back to content 

  ---

• Is it possible to run your product from the command line?

  Our converters guarantee an appropriate running and handling from command line. You should use the following example for DBConvert for MS Access&MySQL when running the program from the command line:
  
  Example:
  C:\Program Files\DBConvert\Access2MySQLPro\Access2MySQLPro5_Cons.exe /Session:"Session Name"
  
  Where /Session:"Session name" defines what precreated session should be used This option lets you run converter with the settings which have been stored as a session. All passwords are saved too. You can find more detailed info about command line using in our on-line manual at:
  http://dbconvert.com/help/access2mysql_pro/start.html

  ---

   back to content 

  ---

• Can I automatically run synchronization?

  You can automate running synchronization process by using built-in Scheduling stage. It allows executing reoccurrences in a specified time interval. Scheduling process runs automatically in the background mode without any further user intervention.

  ---

   back to content 

  ---

• What is Batch file and how to create it for DBConvert tools?

  A batch file is a file that contains a series of commands which the computer executes automatically. Batch files have .bat extension. Additional information about batch files you can find at http://en.wikipedia.org/wiki/Batch_file or at http://www.computerhope.com/batch.htm#01
  
  You can create .bat files in two ways:
  
  1) Automatically: using Built-in Scheduler that is performed in all DBConvert tools. In this case you don’t need to use shell commands. Our converter does it automatically when you add new task for scheduling. You can read a brief manual at http://dbconvert.com/scheduling_man.php?url=add-new-task
  
  2) Manually: by means of any text editor using command shell processor interface. Please, read more information at http://www.computerhope.com/batch.htm#11
  
  Below is a simple batch file example:
  
  c:
cd "c:\Program Files\DBConvert\Access2MySQLSync\"
@ECHO Run application
Access2MySQLSync_Cons.exe /Session:"SessionName"

  ---

   back to content 

  ---

• Scheduled task doesn't work at all, even if the task is displayed in DBConvert built-in Scheduler. “Task has not been run” status is returned.

  DBConvert scheduler's work is fully based on Standard Windows scheduler.

  1. Please make sure that you specified your Windows login and password in DBConvert Scheduler settings. Otherwise your task won't be executed.
  
  For this purpose, press "Edit task" option, choose "Settings" tab and fill in the username, password and confirm password fields with the info you use for logon in Windows system. Your password and confirm password must be the same.
  
  Pay attention that DBConvert products use standard Windows scheduler to create tasks for conversion/synchronization. Take a look at the example of .bat file creation:
  
  c:
cd "c:\Program Files\DBConvert\Access2MySQLSync\"
@ECHO Run application
Access2MySQLSync_Cons.exe /Session:"SessionName"
  
  If you have already created sessions you can just specify them in bat file.
  
  Note: Regarding the issue with Standard Windows scheduler MSDN says the following:
  "When you use the Scheduled Task Wizard to create a scheduled task on a Microsoft Windows computer, you must be a member of the Administrators group, the Backup Operators group, or the Server Operators group on the local computer.
  Additionally, you must type the user name and the password of a user account to schedule the task.When the scheduled task starts, it runs as if it were started by this user. Therefore, the scheduled task runs in the security context of this user account.
  If you type the user name and the password of a user account that belongs to a group that has more user rights than the group where you are a member, the task will not run as you expect, because the user name and the password are not configured for the task. However, a user may be able to use the “schtasks” command to schedule a task to run in the security context of a user account that has more user rights, including administrative rights."

  2. Except login name and password you should specify "end date" for your task.
  
  For this press "Edit task" option, choose "Triggers" tab and specify the triggers conditions for a task. Click on the "Advanced" button and check "End date" option.

  3. Also the reason of such scheduler behavior can be unchecked option in standard Windows Scheduler shown on the screenshot below.

  

  NOTE: If you use Windows Vista or Windows 7 you should disable User Account Control (UAC).

---

 back to content 

---

• I can’t configure Microsoft SQL Server 2005 Express. How can I overcome this problem?

  Regarding the problem how to configure MS SQL Express version please thoroughly analyze the manual attached. It is just an example for DBSync Access & MS SQL tool, but the rules for all DBConvert are common for all MS SQL related programs.

  It can help you to configure your MS SQL Express server for Windows Authentication in a proper way.

  Please download manual here.

  ---

   back to content 

  ---

• Does your product support Microsoft SQL Server 2008 EXPRESS?

  Please download the manual illustrating several SQL 2008 Express settings that must be preconfigured for successful connection establishing in DBConvert tool.

  Please download manual here.

  ---

   back to content 

  ---

• Does your program support Access 2007 file format (.accdb)?

  Yes, it does!

  ---

   back to content 

  ---

• I discovered that the program doesn´t accept my registration info after restoring or updating. What is your update policy?

  According to product License the Licensee is eligible for free minor and major upgrades within one year from the date of registration. Then the License may be renewed for additional 1-year period by paying a renewal fee to the Licensor.
  
  That means that you may not have to pay a fee for further updates and stay to use your current software version till the end of times.

  ---

   back to content 

  ---

• Will queries, primary keys/indexes and foreign keys be converted as well?

  Our products completely support Primary keys, Indexes and Foreign keys (relations) conversion and synchronization.
  Queries conversion is not supported by current versions of our products.

  ---

   back to content 

  ---

• Is it possible to convert user defined data types?

  Our converters support only standard data types. Composite or user specified data types are not supported.

  ---

   back to content 

  ---

• Why synchronization doesn’t work or gives an error?

  If you need to perform the synchronization, then the structure of synchronized databases should be the identical. Only in this case, the synchronization process will be simple and accurate.

  ---

   back to content 

  ---

• Why synchronization speed is slow?

  There are many factors that have an influence on synchronization speed. The most important is an availability of primary keys in synchronizing table, another one is a number of fields and records and the last critical issue that can slow down the speed is a data type.
  
  "Update" synchronization works by comparing record-by-record. And if your record contains, let us assume, 5 empty fields, of course, it will be processed much faster than if your records has binary data. "Insert" and/or "Drop" synchronization options compare Primary Keys' set but not each record.
  
  In this situation, we can recommend one of the following solutions:

  1. Create filters for urgent synching and for example for "night" synching.
  2. Find the tables that require more time for synching and separate their synching in another session.
  3. Please check if you have Primary key structure in your tables. If don’t, assign it. Notice, that you can check Pkeys on Customization stage.
  4. Before scheduling please check workability of your session. If session with synchronizing options ON works well schedule it.
  
  NOTE: Take into consideration that to bring your databases in compliance you can check "Overwrite database (table)" options on Customization screen. Each database element can be customized.

  ---

   back to content 

  ---

• Data filtering is not working when I choose Drop synchronization option.

  Filters can not be used for drop synchronization for the following reason:
  
  Drop synchronization is meant for deleting records in the destination that have been deleted in the source. As filters are applied only for source, we can not use them for the records that do not exist.

  ---

   back to content 

  ---

• I need to convert/synchronize my main database to the secondary databases. How many Licenses should I buy?

  You are required to buy only one license per your main machine, even if you need unlimited number of conversions/synchronizations. The product can be installed at any machine that has connects to the servers. In this case, you should use multiple sessions. See the picture bellow.

  

  ---

   back to content 

  ---

• What is 1 Site Wide License?

  1 Site Wide License is provided for a user who wants to install one program copy on a production server. This kind of licensing allows unlimited developers at a single physical address.

  ---

   back to content 

  ---

• What is premium support and what benefits it gives me?

  Premium support is provided to persons who have paid for it and is available as an add-on to a product purchase (“Maintenance” option). It entitles you the premium priority for technical support.

  ---

   back to content 

  ---

• Where I can find my logs and session files?

  In "Work folder" field, in the settings, you can browse a directory, in which the logs and sessions will be saved.
  
  But as default, a full DBConvert log file is stored at: C:\Program Files\DBConvert\Program name in LOG folder.
  
  Example:
  "c:\Program Files\DBConvert\Access2MySQLSync\LOG\Access2MySQLSync.log"
  
  Sessions are saved to C:\Program Files\DBConvert\Program name in Program name Sessions folder.
  
  Example:
  "c:\Program Files\DBConvert\Access2MySQLSync\Access2MySQLSync Sessions"
  
  In case you want to find the modified synchronization log, please follow the link: C:\Program Files\DBConvert\Program name\Program name Diffs
  
  Example:
  "c:\Program Files\DBConvert\Access2MySQLSync\Access2MySQLSync Diffs"
  

  

  ---

   back to content 

  ---

• Why my session is not stored?

  To store a session you need to have administration rights on the installation folder. Or change the folder for session storage. The new folder should have “Write” permission.

  ---

   back to content 

  ---

• What maximum number of rows and tables can be converted?

  The size of a database you attempt to convert can be limited by DBMS and restrictions related to the data types which are defined in DBMS. Conversion speed directly depends on database size, its structure complexity and hardware set on your PC.

  ---

   back to content 

  ---

• Do your converters allow to choose data fields?

  Our products convert such database elements as tables, fields and indexes. If you needn´t convert your whole database there is an option to convert certain table, field or index from a source database. You simply can customize your conversion settings.

  ---

   back to content 

  ---

• Do your converters synchronize in both directions?

  Our synchronizers can handle data in both directions but not simultaneously. At first, data is synchronized from source to destination database(e.g. from MS Access to MS SQL database ) and then vice versa. Synchronization can be executed in one direction with adding missing records in destination db (insert synching) or with editing records altered in source (update synching). If you need to fulfill bidirectional synching you can create 2 sessions arranging sequential synching from A to B and vice versa from B to A.

  ---

   back to content 

  ---

• What types of DBMS are supported by your products?

  Below the list of supported server types is presented:

  • PostgreSQL 7.4 and later
  • MySQL 3.24 and later
  • MS SQL 2000/2005
  • Beginning with Access 97 (except AccessForms2Web)

  ---

   back to content 

  ---

• Everytime I run synchronization, it is not updating data which have been changed.

  Database synchronization is based on the primary keys in table structure. For proper synchronization process your tables should have primary keys, so please make sure whether the primary keys are set in the table.

  ---

   back to content 

  ---

• I'm trying to connect to my remote database server via SSH Tunnel. I can't connect using an SSH tunnel created with Putty.

  The compehensive guide covering SSH options configuration with PuTTY for DBConvert tools are available here.

  ---

   back to content 

  ---

• My saved session doesn't synchronize a new table/row/column.

  To overcome this problem, please check "Automatic structure update in the session" option at the execution stage. This option enables you to update db structure in the session automatically. Before checking this option, save the current session and when you load this session the next time all new fields and tables will be converted without loss of information.

  ---

   back to content 

  ---

• How can I configure MySQL server for DBConvert?

  Please use the following manual for MySQL Server configuration for clients (machines) connection.

  Please download the manual here.

  ---

   back to content 

  ---

• How should I configure permissions for MSSQL clients (machines) connections?

  Please use the following manual for MSSQL Server configuration for clients (machines) connection.

  Please download the manual here.

  ---

   back to content 

  ---

DBConvert&DBSync for MS Access&MySQL FAQ Section

• DBConvert for MS Access&MySQL gives the following error: « Error 2003: Can't connect to MySQL server on 'localhost' (10061) »

  MySQL error 2003 means server does not have necessary permissions or access rights to the specified directory. Before connecting to MySQL server check your firewall settings or contact your system administrator. Or it may also be you have to reconfigure your MySQL server settings.

  ---

   back to content 

  ---

• Error 1452: Cannot add or update a child row: a foreign key constraint fails.

  This error occurred because of unregistered DBSync for MS Access&MySQL version usage. Foreign key structure can not be built correctly due to 10 records limitation.

  ---

   back to content 

  ---

• I get «Error 1005: Can't create table... ».

  MySQL server reports this error when:
  
  - The referenced table is not an InnoDB table
  - The referenced column in other table is not unique
  - The referenced column in other table has a different type to other id
  
  In MySQL prior to 5.0, this error can also indicate that:
  - No index has been defined on the column id

  ---

   back to content 

  ---

• I get «Error 1062 Duplicate entry '1' for key 1». What can I do?

  You should customize synchronization properties correctly by checking "Insert sync" and "Update sync" options for all tables. At the same time you need to have, at least, one unique primary key field per table you want to synchronize. Otherwise, synchronization works incorrect or doesn't work at all.

  ---

   back to content 

  ---

• I get «ERROR 2013: Lost connection to MySQL server during query». How can I solve it?

  This error occurred because the connection to MySQL Server during query is timed out. Please contact your server administrator for increasing time for queries execution.

  ---

   back to content 

  ---

• Runtime error 3044

  Error 3044 is returned by MS Access in case if Access db has linked tables which are not found according to the specified path.

  ---

   back to content 

  ---

DBConvert&DBSync for MS Access&MS SQL FAQ Section

• How to connect to Microsoft SQL Server 2005 Express database?

  There are 3 ways of connection with MS SQL. You can do it through :
  
  1. - TCP/IP
  2. - IPX/SPX
  3. - PIPE
  
  Our tool uses TCP/IP protocol for conversion process by default. You should open this protocol through MS SQL Configuration Tools. If you still can not connect to the server check firewall settings or reconfigure your MS SQL server using one of the ways described above. Also make sure that password field is empty if you log in as super administrator.

  ---

   back to content 

  ---

DBForms from MS Access to PHP+MySQL FAQ Section

• How can I convert MS Access forms to a web-page?

  The general idea of DBForms from MS Access to PHP+MySQL product is conversion of MS Access forms to web page. It may be needed when you want your users have access to data through web resource. Converted forms performed as php files are presented in web browser Exactly the way they were created in MS Access.

  ---

   back to content 

  ---

• What additional software should I install for conversion with DBForms from MS Access to PHP+MySQL?

  Before running DBForms from MS Access to PHP+MySQL you should have the following software installed:
  
  - MySQL server
  - PHP
  - Web server (IIS, Apache etc.)
  
  In case you don´t want to adjust settings of MySQL server, PHP and Web server working together we can recommend you to use «3 in 1» package products, such as:
  
  - WAMP
  - XAMP
  - Netserver
  - Denwer and many others.
  
  They require the minimum of user´s participation. After package installation these 3 components work together perfectly.
  
  Note: Pay attention to additional libraries supplied with web server that must be loaded for work with PHP. Please read PHP and Apache help files if you intend to configure them manually.

  ---

   back to content 

  ---

• Does DBForms from MS Access to PHP+MySQL support subforms and tabs?

  Our last DBForms from MS Access to PHP+MySQL converter version supports conversion of subforms and tabular controls.

  ---

   back to content 

  ---

• Why were the forms not converted?

  More likely, the problem is masked in unconnected MySQL database with PHP script language. Also you can check folders structure where converted form files must be saved. In case form conversion is committed successfully and the main problem is in uploading php files to local folder or FTP server you can find "Templates" directory. Usually it is placed at "C:\Documents and Settings\User_name\Templates". Here A2WebForms folder must be created. So all php form files can be simply copied from A2WebForm folder to your local folder specified at Upload setting stage.

  ---

   back to content 

  ---

• Does DBForms from MS Access to PHP+MySQL convert updated records in MySQL database?

  If you want to update your records in MySQL database you should use our DBForms from MS Access to PHP+MySQL + DBSync for MS Access&MySQL package where DBSync for MS Access&MySQL performs «Update» functionality.

  ---

   back to content 

  ---

• How can I create Front/Back Ends in order to remote users could log on to the MySQL database online?

  At the moment the program doesn't convert events for elements. You can add your event code in your forms manually. For this purpose, go to the folder where your resultant forms are located. Each form is converted to a separate folder which is named in the same way as the form. Choose the folder you need. In this folder you will find "UserFunction.php" file, which contains function header for buttons.
  Function name always has prefix "Button" followed by the name of this Button.
  For example:

  		function ButtonOrders(&$Fields)
  		{
  		   //TODO: Add your code here 
  		}

  NOTE!
  When working with this function remember that:
  1. the path to the folder where your resultant forms are saved is as follows: ./../
  2. the path to "FORMS" directory is as follows: ./../../FORMS/
  For example:
  You need the following functionality: You click at "View" button and "My_Form" is displayed.
  Your event code should be as follows:
  

  		function ButtonView(&$Fields)
  		{
  		   header("Location: ./../../FORMS/My_Form/My_Form.php");
  		   return FALSE;
  		}

  If you don´t want to add event code manually or develop Front/Back End web interface we can perform this service for extra fee.

  ---

   back to content 

  ---

• Error: «Member not found» in Access 97. What can I do?

  Unfortunately, DBForms doesn't support Access 97 but you can run your database in one of the later Access versions. It will be automatically saved in a new format. Then try to use your database in DBForms as a source.

  ---

   back to content 

  ---

• I get “Error No. 100 occured! MySQL connection failed! Please check your credentials! mysqlnd cannot connect to MySQL 4.1+ using old authentication” How can I solve it?

  Please follow the link below to overcome your problem: http://dev.mysql.com/doc/refman/5.1/en/old-client.html

  ---

   back to content 

  ---

• Your program tries to process the non-existent queries in my database. How can I overcome this?

  We had faced this problem and figured out where the core is. After queries and forms deletion from MS Access db the information about them is still there, it is not visible in the list of available elements but, be sure, it is left in your db structure. Unfortunately, this is the problem of MS Access only.
  
  As an advice you can create a new db and copy your db elements there.

  ---

   back to content 

  ---

DBForms from MS Access to ASP.NET + MS SQL FAQ Section

• What additional software should I install for conversion with DBForms from MS Access to ASP.NET + MS SQL?

  Before running DBForms from MS Access to .NET+MS SQL you should have the following software installed:
  
  - MS SQL server 2000 and higher versions
  - Windows based web server (IIS 6 and higher versions)
  - ASP.NET 2.0
  

  ---

   back to content 

  ---

DBConvert for MS Excel & MS SQL/MySQL FAQ Section

• Conversion speed is slow when I convert from MS Excel file.

  In order to increase the speed, you should uncheck "skip empty rows" option at the "Database structure configuration" window.

  ---

   back to content 

  ---

DBConvert&DBSync for MS FoxPro Section

• When I convert .dbf tables, they are not displayed/displayed partially at the customization stage.

  Such a situation usually happens due to the way the tables(.dbf files) were created. If you want your .dbf tables to be converted easily they must be free, not constrained within a database.
  
  Note: Regarding this problem please check the following details:
  
  - if you choose directory with .dbf files and tables do not appear on Customization stage :

  1. tables do not belong to FoxPro environment
  2. other applications occupy the tables
  3. there is no additional files belong to the tables, for example files needed for memo fields in the table
  
  - if you choose .dbc file as a source for conversion and tables do not appear on Customization stage:
  
  
  1. the 'lost' tables are not included into dbc file properly

  ---

   back to content 

  ---

• I get a message dialog «There is an unknown exception oxd0000005 occurred in the application at 0x0c103d1p» every time I try to run the program to convert the free dbf files.

  The conversion process will be executed if you moved the destination file to a different folder. You can NOT have the destination file in the folder where you are reading the dbf files from.

  ---

   back to content 

  ---