Microsoft SQL to Access FAQ |
| [Product's Homepage] [Download] [Buy] |
On this page you can find the most frequently asked questions regarding MSSQL-to-Access converter. If your question is not answered here, please contact us via Feedback Form
What kind of Microsoft SQL data is converted into MS Access format?
MSSQL-to-Access converts table definitions with all necessary attributes,
records and indexes. It does not convert triggers, foreign keys and stored
procedures. Demo version converts only 50 records per table.
Go to Top
What are system requirements of MSSQL-to-Access?
The product requires Microsoft SQL environment (server or client components
of MS SQL must be installed on the same machine where you run MSSQL-to-Access
from) and installation of Microsoft Access. ODBC drivers or any other middleware
is not required.
Go to Top
What versions of Microsoft SQL server and MS Access
are supported?
MSSQL-to-Access works with all versions MS SQL including Azure SQL.
The program can generate output in one of the following formats:
MS Access 95/97, MS Access 2000 and MS Access 2007/2010.
Go to Top
How can I rename column name in the resulting MySQL
database?
You can modify column name converting contents of the corresponding table
as result of SELECT-query. See Using
Queries article for the further information.
Go to Top
Does MSSQL-to-Access support automation?
MSSQL-to-Access converter does not support automation directly. However, there
is console version of the program m2sagent.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
m2sagent.exe.
Go to Top
All table names include schema name as a prefix.
How can I avoid it?
By default the program lists all tables found in the database. Because
different schemas could contain tables with the same name, MSSQL-to-Access compose
full table name as [schema name].[table name] to guaranty that it is unique.
If you need to work with tables owned by the user specified, select
"View tables owned by the user" checkbox on "Select Databases"
wizard page. This will force the program to not include schema name as prefix.
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 Microsoft SQL table name in the query above.
Go to Top
Is it possible to connect to Azure SQL from
MSSQL-to-Access?
Yes, it is possible. See How to connect to
Windows Azure SQL article for related information.
Go to Top
I don't see all tables of the database. Why?
Please check "View tables owned by the user" checkbox on "Select
Databases" wizard page. When it is selected the program only displays tables
owned by the specified user. To view all tables of the database you should
unselect this checkbox.
Go to Top
How to uninstall MSSQL-to-Access converter?
If you need to remove MSSQL-to-Access product from your
computer, you can use "Add or Remove Programs" option in the
Windows Control Panel.
Go to Top