|
On this page you can find the most frequently asked questions regarding
Access-to-MySQL converter. If your question is not answered here, please contact
us via Feedback Form or contact us at
Why convert Microsoft Access databases into MySQL format?
1. Performance. According to many benchmarks MySQL shows one of the best
performances among DB2, Oracle and SQL Server 2000. MySQL is used by lot of
organizations that demand high performance and stability.
2. Cross-Platforming. One of the most advantages of MySQL is its
cross-platform capabilities. You can develop your database on a Windows
laptop and then deploy on Windows or Linux server. It gives you incredible
flexibility when choosing server platform.
3. Multiple users access. Microsoft Access supports data sharing but
it has not enough power to handle many simultaneous users. This application has
been designed as data manager for local use and that is what it is good for.
MySQL is a real client-server database environment that can handle many
simultaneous connections.
4. Security. Although Microsoft Access provides some capabilities to protect
the data, they are optional and it is easy to bypass them. MySQL provides
strong security system and anyone willing to access the data must know MySQL
user name and password.
Go to Top
What kind of Microsoft Access data is converted to MySQL?
Access-to-MySQL converts table definitions with all necessary attributes,
records, indexes, relationships and queries. It does not convert forms,
embedded functions that are not complied with ANSI SQL and Visual Basic
scripts. Demo version converts only 5 records per table and
does not convert relationships between tables.
Go to Top
Does Access-to-MySQL require ODBC drivers?
No, Access-to-MySQL converter does not require ODBC drivers or any other middleware software.
The converter connects to source and destination databases directly and this is the reason of
its high performance.
Go to Top
What versions of MySQL are supported?
Access-to-MySQL works with all versions of MySQL.
Go to Top
Does Access-to-MySQL support automation?
Access-to-MySQL converter does not support automation directly. However, there
is console version of the program a2sagent.exe in the installation directory.
It supports command line arguments and can be called from any script. So,
it is possible to write a simple batch script and execute it recurrently using
Windows Task Scheduler. Please refer to
'Command line' article of the product documentation to learn more about
a2sagent.exe.
Go to Top
How to change destination table name?
You can convert contents of the table as result of SELECT-query with custom name.
Click "Add Query" button on "Select tables" wizard page and
compose simple query as follows:
SELECT * FROM <original table name>
Then store it with the name you wish to assign. Of course, you need to place
actual MS Access table name in the query above.
Go to Top
How to bypass error "The program does not support
authentication protocol requested by server..."
MySQL 4.1.0 uses the authentication protocol based on a password hashing algorithm
that is incompatible with that used by Access-to-MySQL. You can use OLD_PASSWORD
function to make the certain account compatible with Access-to-MySQL. Login to MySQL
server with administrator privileges and run the following queries:
mysql> USE mysql;
mysql> UPDATE user SET Password = OLD_PASSWORD('some_pass')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
Of course, you should place actual values instead of 'some_pass', 'some_host' and
'some_user'. Now you can use 'some_user' account with Access-to-MySQL.
Go to Top
How to uninstall Access-to-MySQL converter?
If you need to remove Access-to-MySQL product from your
computer, you can use "Add or Remove Programs" option in the
Windows Control Panel. If this option is not available for some reason,
you can call uninstall procedure running the following command line
from the installation folder:
UNWISE.EXE acc2sql.log
Go to Top
|
