• 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?
• What is your update policy?
• Will primary queries, keys/ indexes and foreign keys be converted as well?
• Is it possible to convert user defined data types?
• Why synchronization speed is slow?
• Where can I find operation log file when program completed conversion process?
• 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.


• 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?


• 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?

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/manual.php

  ---

   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.

  

---

 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 

  ---

• 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.

  ---

   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 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. Synchronization works on comparer basic, record-by-record and if your record contains, let us assume, 5 empty fields, of course, it will be processed much more faster than if your records has binary data.
  
  All we can recommend in this situation is to create filters for urgent synching and for example for "night" synching.
  
  Please find the tables that require more time for synching and separate their synching in another session.

  ---

   back to content 

  ---

• Where can I find "Operation log" file when program completed conversion process?

  You can get log file of the last operation at:
  
  "C:\Documents and Settings\User_Name\My Documents\DataConversions Logs\ "

  ---

   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 

  ---

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 

  ---

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)
  
  In case you don´t want to adjust settings of MySQL server, PHP and IIS 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 

  ---