MySQL Forums - Microsoft Access

Help converting an Access database (no replies)

Jennifer Murphy — Mon, 25 Aug 2025 03:17:15 +0000

I have a fairly large Access database for my LP collection. It has about a dozen tables plus a bunch of forms and queries. The main table, tblAlbums, contains about 700 records and 33 fields. I want to add some features better either impossible or difficult in Access. I've been meaning to learn MySQL for a while. I think this will be the motivation I need to do that.

Can anyone point me to a very good tutorial for converting an Access database over to MySQL?

I'd also love to have suggestions about an introduction to MySQL tutorial.

Thanks

PS: I am running Office 365 on Windows 11. I meant to put that in my signature, but I couldn't find where to do that.

erreur réservée -7745 (1 reply)

Jean-Michel Lequeux — Sat, 23 Sep 2023 12:10:19 +0000

I have installed ODBC drivers "mysql-connector-odbc-8.1.0-winx64.msi" on Windows 10 and tryed a connection with Microsoft Access 2016. Connection to the database is successfull and I can see the tables on it. But when I try to get the tables, I received an error "erreur réservée -7745 which is not documented. My database is small, and the driver is supposed to be up to date. The database seems OK with phpmyadmin. Can you help me?

import rows into MYSQL (no replies)

dave wilson — Tue, 14 Feb 2023 00:33:06 +0000

I have an ACcess frontend to a remote MYSQL. ALso an EXCEL tool that parses text into rows, that we'd like to get these Excel rows now into the MYSQL db.

We figured it would make sense to maybe interface directly with MYSQL from Excel, rather than passing the data to Access, then to MYSQL.

The user signs into the Access front end and authenticates with MYSQL.

Can I link from Excel to this open Access Front end to grab the password? (after storing in variable after the Access front end login)

Or better maybe to have Excel pass the rows to Access, and have Access put them up to MYSQL, as user has already been authenticted in the Access front end?

Microsoft Access ODBC call failed MySQL client ran out of memory #2008 (no replies)

Stephen Rigo — Wed, 16 Nov 2022 14:41:38 +0000

Hello all,
I have been using AWS MySQLfor large databases for many years and have done analysis using Microsoft Access as a front end on my computer using MySQL ODBC Connector. Recently I upgraded to My Connector 8.0.31 32 Bit. I am losing connection to the database when I try to run queries on Large datasets with linked tables.

In testing I found that I can run query that returns 9 months of data without a problem. When I change the query to return 10 months I get the error below.

My error is ODBC call failed
MySQL ODBC 8.0(a) Driver mysqld - 5.7.12 MySQL client ran out of memory #2008

Is this a server configuration, parameter, or resource issue?

Or is this a Connector issue that needs some parameters changed?

Or is this my Computer running out of memory?

Access Forms won't add or update records (no replies)

philippe pons — Tue, 21 Jun 2022 07:50:15 +0000

Hi,
I have a problem using an Access front end connected to a MySql Database.
I test UPDATE on one small table with a VBA procedure, using DAO
sql = "UPDATE tblFormateur "
sql = sql & " SET Prenom = 'Werner' "
sql = sql & " WHERE Nom='HEISENBERG' "
The first time I run the query, it's ok.
But if I run the same query, without changing the value,(keeping Prenom = 'Werner')
I get an error message saying that the query has not been executed,
due to a lock violation.
If I run the query again, but with a different value, e.g Prenom = 'Peter',
the query is executed without error.

On the other hand, If I do the same experiment with ADODB,
I do not get any error.

One can say: let's go with ADODB!

The problem is that the Access front-end Forms use DAO, not ADODB!
So all the forms won't be able to either add new records or update records.

Did you experienced the same issue?
Are there some parameters of the ODBC driver that needs to be set?

Thank's advance for any help.

Windows 1
Access Office 365
ODBC connector 8.0 CE

odbc administration utility could not be found (12 replies)

Richard Vizcarra — Thu, 19 Jan 2023 13:43:14 +0000

Trying to migrate an MS Access db to SQL Workbench using the Wizard but can't get past this error message. I've tried everything I can think of and no luck. I'm using Windows 11 64bit OS and Workbench 8.0 Community version. Using MS Office Pro Plus 2016 with Access included.

Thanks

return solid block charctor in mysql query (7 replies)

dave wilson — Wed, 25 May 2022 16:39:59 +0000

I'm trying to find the equivalent for creating a string of Solid Block charactors. This works in Access - String(30,ChrW(9608))
How might i get that in mysql query?
thnaks!

Link Breakage using MS Access as frontend to MySQL server (2 replies)

Bryce Larsen — Mon, 17 Jan 2022 23:58:19 +0000

Hello,
So I'm writing because I'm experiencing a bit of an issue. I have running a MySQL Community 8.0.25 server which at present houses 1286 rows of data. This data is primarily accessed for human consumption via a Microsoft Access 2007 linked table which uses the ODBC connector (also version 8.0.25) although it is read/written by a couple of other applications as well on a regular basis. This setup has been working well for me for about five months now, at least until about three days ago. Previously I was able to view and filter the entire database without issue, yet now when using most methods to view any of the last 16 rows of the database Access loses its link to the DB (all boxes show '?NAME' which does not go away when hitting the 'refresh all' button). The exception to this is if I use the equals filter on a VARCHAR column, in which case I can view/edit data from the last several entries. Other filters which would return result sets that include those last several rows incite what appears to be the same loss of connection.
In attempting to diagnose and solve this issue I have verified that those last few records do exist and are visible via queries through other types of connection (including the Dotnet & Python connectors as well as the MySql application on the server). In my ODBC connector settings, I have attempted to correct the problem by enabling 'allow big result sets', 'use compression', 'enable automatic reconnect', & 'Enable safe options' each one at a time and in several combinations thereof. I have via ODBC created both a trace file and a debug log yet I can see nothing visibly wrong in the debug log (no errors listed and all queries listed simply as 'executed') and I lack the skills to parse the trace file.
So that's my dilemma. Thanks for taking the time to read it through, any assistance would be hugely appreciated.

Convert Access Latin1 to utfmb4 problem (1 reply)

Preston Hardison — Sat, 23 Jan 2021 18:41:48 +0000

I have a problem converting legacy Access databases to MySQL. Access ported over multiple generations and in .accdb format. I assume they are encoded in Latin 1 case insensitive accent sensitive. I am wrestling with early poor decisions Access allowed me to make and I was too naive to know better.

The main field is a varchar field 255 char ("Title") with a unique index and contains text strings. The database is a long annotated list of single words and phrases. Most are short, but hundreds of thousands of entries are over 191 characters. I need them to be unique and accent sensitive (e.g. Aché are indigenous peoples in Paraguay. ache is to hurt).

If I import to utf8mb4, the maximum index length is 191 characters. I don't really need universal character and emoji capability in the Title field, but I do with others. I can create a "tiebreaker field" (188 char + 3 char tiebreaker unique index), But then I have the problem of identifying all the duplicates beforehand, and imports to MySQL drop hundreds of thousands of records.

I spent many hours trying to find documentation of this issue on the web. I've not encountered comprehensive treatments of these kinds of collation issues. I'm even only guessing at Access collation, since I haven't found a way to get Access to reveal it's exact encoding.

Any links or search terms I can use that are not so generic I just get hundreds of pages on collation-free descriptions of performing ideal transfers?

convert to uppercase or just display? (2 replies)

dave wilson — Wed, 20 Jan 2021 02:49:48 +0000

I have varchar() fields on an access form, and want them to be uppercase.

should i convert on the access client on entry?
or on remote MYSQL server?
or neither,, and just display/format them for viewing on access form or reports?

thanks!

get odbc error info (3 replies)

dave wilson — Fri, 05 Mar 2021 23:58:03 +0000

i'm testing my login to remote mysql, and want to show message if invalid user/pwd. I first got a generic 3151, then added and checked DBEngine.Errors - still get a generic message (same message for network down or invalid user/pword)

where/how could the specific error message such as "authenticaton failed"?

thanks!

Trouble with Generated Column (2 replies)

Ron Mittelman — Mon, 17 Aug 2020 18:28:15 +0000

Not sure if this is correct forum for this issue.
I'm trying to migrate a Microsoft Access back-end database to MySQL, and having problems with generated columns. Couldn't get migration assistant to work properly, so used a 3rd-party tool to migrate my tables. This created the tables but I have to fix some things before populating data.

In Access I have some calculated columns. For example, the 'Heading' column is a combination of title (Mr & Mrs, etc.) and names and spouse names.

Here is calculation in Access to build a heading:

IIf([UseTitle],[Title] & " ","") & IIf(IsNull([DonorFirstName]),[DonorLastName],[DonorFirstName] & IIf(IsNull([SpouseName])," " & [DonorLastName],IIf(IsNull([SpouseLastName])," and " & [SpouseName] & " " & [DonorLastName]," " & [DonorLastName] & " and " & [SpouseName] & " " & [SpouseLastName])))

(In Access, IIF is same as MySQL IF function)

So if I'm supposed to use a title, put that in.
If first name is null, add last name (that's how this database denotes a company name). Otherwise, add first name. If no spouse name, add space and last name. If spouse, add " and " plus spouse first name. Then add last name. So now you have "Mr. & Mrs. John and Jane Doe". In case the spouse has a different last name, it will instead build a string like "Mr. & Mrs. John Doe and Jane Smith".

I tried doing this in MySQL generated column, but it keeps erroring out. It seems to work, then when I go into the table designer in Workbench, it says Error parsing DDL. When I view the DDL, the calculated column shows the error on the Heading column:

`Heading` varchar(509) CHARACTER SET utf8 COLLATE utf8_general_ci GENERATED ALWAYS AS (concat(if(((`UseTitle` = 0) or (`Title` is null)),_utf8mb3'',concat(`Title`,_utf8mb3' ')),`DonorFirstName`,_utf8mb3' ',`DonorLastName`)) VIRTUAL,

The squiggly red line is at _utf8mb3'', right under the ''. It says "Syntax error: extraneous input found - expected 'comma'".

This is using a very simple generated field for a test, trying to combine only 2 or 3 columns.
It's very strange that the DDL will create a new table, then give me a syntax error when I try to open the table designer in Workbench.

Is there a better way to accomplish this rather than a bunch of contats with IF statements like I'm doing?

Thanks...

Query transform / pivot (2 replies)

Galilea sanchez — Sun, 03 May 2020 23:49:17 +0000

Hi, I'm new on this, I'm traying to do a Query that works in Access, but not in MySQL.. can anybody help?

This is my Query:

TRANSFORM Sum(Total) AS SumOfTotal
SELECT Client, Sum(Total) AS Sum_Total
FROM Remission
WHERE (((Year(DatePay))=2020) AND ((Month(DatePay))=1))
GROUP BY Client, DatePay
PIVOT DatePay;

Thanks in advance!

move a simple db from access to web (1 reply)

stefano capasso — Thu, 09 Jan 2020 22:08:27 +0000

Hello i have a very simple database in access, a kind of anagraphic, name, date of birth, geneder, nationality and so on
I would like to be able to have a similar application online, so that users can insert data and make simples query(all male, all male from nationality ecc)
I don't need to take the orignal application in access, i would just need to be able to import the records..about 1500

I make this for an Onlus, little momney available, would be great if there is a free solution on line, or maybe a wordpress plugin, in any case not much programming hopefully

Thanks a lot

SQL Error: 1168"): error calling Python module function DbMySQLRE.reverseEngineer Failed (no replies)

Deepak Tiwari — Thu, 05 Dec 2019 09:46:19 +0000

Hello All,

I am Trying to migrate on Sql Server which is running in windows to Linux and getting error as below. Anyone please help me out.

- Retrieving table ahrs.email...
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_mssql_grt.py", line 266, in reverseEngineer
result = execute_query(connection, "SHOW CREATE TABLE `%s`.`%s`" % (escape_sql_identifier(schema_name), escape_sql_identifier(table_name)))
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_mssql_grt.py", line 43, in execute_query
return get_connection(connection_object).executeQuery(query)
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\db_utils.py", line 364, in executeQuery
raise QueryError("Error executing '%s'\n%s"%(query, error), code, error)
workbench.db_utils.QueryError: Error executing 'SHOW CREATE TABLE `ahrs`.`email`'
Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist.
SQL Error: 1168

Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_progress_page_widget.py", line 197, in thread_work
self.func()
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration_schema_selection.py", line 183, in task_reveng
self.main.plan.migrationSource.reverseEngineer()
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration.py", line 364, in reverseEngineer
self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)
SystemError: QueryError("Error executing 'SHOW CREATE TABLE `ahrs`.`email`'
Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist.
SQL Error: 1168"): error calling Python module function DbMySQLRE.reverseEngineer
ERROR: Reverse engineer selected schemas: QueryError("Error executing 'SHOW CREATE TABLE `ahrs`.`email`'
Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist.
SQL Error: 1168"): error calling Python module function DbMySQLRE.reverseEngineer
Failed

Is there a generator or frontend for MYSQL databases for crud operations like in Microsoft Access? (1 reply)

pedro gonzalez — Thu, 05 Dec 2019 19:46:20 +0000

Hello,

You know that good old Microsoft Access database: On Windows, you can create forms with subforms, views, etc. You can browse trough all the records using forms, edit data, etc.

It is easy and straightforward; So, I'd like to achieve similar functionality with my MYSQL database on my apache website; Is there some web-form generator or frontend to generate similar interface like Microsoft Access, but in web pages residing on my 'contracted' linux web server with apache on it ? (if it's also responsive it would do better).

I'm Looking for a semi-automated tool; I don't want to develop the whole thing myself.

I imagine that something have to exist that, let's say, generates a basic form from table CUSTOMERS, and then you can edit it in a web-based form designer...

And I suppose, as MYSQL is so popular, that it MUST EXIST, and that it shoud be free alternatives there... Am I wrong ?

Thanks !

Linked tables (no replies)

Fred Mwanje — Sun, 08 Sep 2019 19:10:45 +0000

Hi,
I have a working msaccess Database but recently I rebuilt the tables in MySQL. On linking the tables, the fields that had primary keys(auto increment) in MySQL are now in number data type in access 2016 instead of AutoNumber, and I can't change them.
Any help will be much appreciated.
Fred

Using Access Linked Tables (no replies)

Irvin Vaughan — Mon, 01 Jul 2019 01:03:45 +0000

Help me please!

I have an MS Access 2010 application that has 25 or so users. Due to corruption issues, I have converted it to MySQL and it is working fine with one exception. The first time one of the "Linked" tables is accessed anywhere in the application, the screen pops up to have the login info entered. I would like to add code to log in from the VBA front end to access each of the linked databases with the user ID and Password before any of the tables are accessed. I can't seem to get the right VBA code to accomplish this.

Thanks

ACCESS 2003 and MySQL - problems with linked tables (no replies)

Efrat M — Sat, 27 Apr 2019 17:18:47 +0000

Hi,
I have an application developed via MS-ACCESS 2003.
I migrated the data (ACCESS tables) to a MySQL 5.7.25.
Then, I linked the MySQL tables to the ACCESS.
Most of data works correctly (viewing the tables content and accessing the data via the Forms).
I have a problem with 2 table:

1. Table contains list of activities (5 fields per record): up to 210 records, all works fine. After adding record no. 211, there is a problem:
when opening the table in ACCESS in view mode, I get the "ODBC - call failed" message, and only 86 records are displayed, where all fields have "#Name?" value.
But, when accessing the table data from the Forms, the data is OK.

2. Table contains list of people details (name, address, etc.): In case of few records in this table, all works fine. But when using the full data (197 records), there is a problem:
In view mode in ACCESS, I can see all data correctly. But I cannot access the data from my Forms. The table and fields are not recognized in the code.

Hope you can help me with these issues. THANKS!

Migration from Access to MySQL (2 replies)

Regev Hindi — Tue, 02 Apr 2019 17:24:46 +0000

I have MS Access for Office 365. I am trying to follow the instructions on how to migrate using MySQL Workbench Migration Wizard.

I thought that I needed a 64 bit ODBC driver for Access, but according to a tech from Microsoft, there is only a 32 bit driver, but since the 32 bit driver is located in c:\windows\SysWOW64, then it should work. However, when I click on "Open ODBC Administrator" and got to the Drivers tab, there is no Access driver listed.

Can anyone point me to a step-by-step tutorial as I am completely lost.

Migration failing (no replies)

Rodney Ort — Wed, 27 Mar 2019 13:36:02 +0000

I'm following the steps to migrate the databae but I keep getting an error at reverse engineer source step

Starting...
Connect to source DBMS...
- Connecting...
Connecting to ...
Opening ODBC connection to DSN=Employee19...
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_msaccess_re_grt.py", line 701, in connect
return MsAccessReverseEngineering.connect(connection, password)
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\db_msaccess_re_grt.py", line 152, in connect
con = db_driver.connect(connection, password)
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\db_driver.py", line 95, in connect
connection = library.connect(connection_string, password=password)
pyodbc.Error: ('HY000', 'The driver did not supply an error!')

Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_progress_page_widget.py", line 70, in run
self.func()
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration_schema_selection.py", line 168, in task_connect
if not self.main.plan.migrationSource.connect():
File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration.py", line 199, in connect
self._rev_eng_module.connect(self.connection, self.password or "")
SystemError: Error("('HY000', 'The driver did not supply an error!')"): error calling Python module function DbMsAccessRE.connect
ERROR: Error during Connect to source DBMS: Error("('HY000', 'The driver did not supply an error!')"): error calling Python module function DbMsAccessRE.connect
ERROR: Exception in task 'Connect to source DBMS': SystemError('Error("(\'HY000\', \'The driver did not supply an error!\')"): error calling Python module function DbMsAccessRE.connect',)

Failed

VBScript working with new MYSQL DB, but I can't update changes via ODBC (no replies)

Peter McConnel — Sun, 27 Jan 2019 19:35:01 +0000

Hello,

I have successfully migrated my Access databases to MYSQL 5.7 using Workbench 8.0 on a winServer 2012 machine. The pages are showing data and I'm going about changing the connect scripts in hundreds of pages of a site that I built in 1999.

I'm sticking with VBSCRIPT for now (One big change at a time ;-). The problem is that I can't get rs.update to work when I try to update db from the web. I get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.20-log]Build WHERE -> insert_fields() failed.

This is my conn script connecting to three tables:

<%Set Conn_Main = CreateObject("ADODB.Connection")
Conn_Main.Open "DSN=vpa_main;"

Set rsP = CreateObject("ADODB.Recordset")
rsP.CursorLocation = 3
rsP.Open "SELECT * FROM people ORDER BY name_last" , conn_main, 3, 3

Set rsS = CreateObject("ADODB.Recordset")
rsS.CursorLocation = 3
rsS.Open "SELECT * FROM schools ORDER BY name" , conn_main, 3, 3

Set rsSU = CreateObject("ADODB.Recordset")
rsSU.CursorLocation = 3
rsSU.Open "SELECT * FROM su ORDER BY name" , conn_main, 3, 3%>

Then the script in the page opening the "schools" table as a dataset:

Set rsUser = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT * FROM schools WHERE ID = " & SID
rsUser.open SQL, conn_main, 3, 3

I'm connectiong using the ODBC Data Source Administrator (64-bit), Unicode.

The user is root with all permissions.

I'm stuck!!

Any help would be great!

Peter

Access not displaying new rows in linked table (3 replies)

Matthew Bennett — Sun, 27 Jan 2019 19:50:52 +0000

I have successfully made a linked table from access to my MySQL database and it successfully writes changes made in one to the other. However, if I add a new row to my MySQL table is does not show up in access. How can I get the new row to be displayed automatically?

Access to MySql (1 reply)

PK Odendaal — Tue, 26 Jun 2018 19:48:02 +0000

I wish to convert from MS Access to MySql in my VB6 programs.

I am using Access now with DAO and wish to change my VB6 programs to use MySql with the minimum of changes.

1. Can I connect via say ODBC directly and update and edit directly with recordsets from my VB6 program as I do in DAO or even ADO or do I have to use PHP?

2. Does MySql have individual files which I can copy from computer to computer like Access or is it a total installation which is needed to function as a database.

Thanks.
PK

SQL & substring function (2 replies)

Robert Tulloch — Sun, 08 Apr 2018 14:20:26 +0000

Odd situation:

This works fine stand alone test in php MyAdmin SQL:
select concat(substring(forename, 1,1),'bwm' ,substring(lastname, 1, 1)) from users where user_id = 152;

Output WbwmW for example.

However when same code included as parameter for placeholder:

Error Warn Log:

[Sat Apr 7 19:13:06 2018] update_tables.cgi: insert statement = 'insert into users (user_id,username,password,pin,position,forename,lastname,business,address1,address2,city,state,zip, email, phone_home, phone_cell, MJ, MD, DD, DP, comments) values ((SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='users'),CONCAT('bwm', (SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE()AND TABLE_NAME='users')), ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)' at update_tables.cgi line 973.

$value = $sth->execute ($password_1, (select concat(substring($forename_1, 1,1),'bwm' ,substring($lastname_1, 1, 1))), $position_1, $forename_1, $lastname_1, $business_1, $address1_1, $address2_1, $city_1, $state_1, $zip_1, $email_1, $phone_home_1, $phone_cell_1, $MJ_1, $MD_1, $DD_1, $DP_1, $comments_1) or die "Unable to execute query: " . $sth->errstr;

[Sat Apr 7 19:13:06 2018] update_tables.cgi: Undefined subroutine &update_tables::substring called at update_tables.cgi line 979.

Undefined subroutine. Strange.

ALTER TABLE FOREIGN (3 replies)

Robert Tulloch — Sun, 08 Apr 2018 00:56:16 +0000

Hi:

Three tables. users, users_initial and users_dues

Trying to set relation form users_dues to users_initial in php MyAdmin SQL

SQL query:

ALTER TABLE users_dues
ADD FOREIGN KEY (user_id)
REFERENCES users_initial(user_id)
ON DELETE CASCADE
ON UPDATE CASCADE;

MySQL said: Documentation
#1146 - Table 'bwmjcmus_mem_mgr.users_dues' doesn't exist

The table does exist. Don't understand

bwmjcmus_mem_mgr

Procedures
Tables
Tables
sessions
users
users-dues
users-initial

Also, why isn't there an ON INSERT CASCADE?

Stored Procedure And Corsor (10 replies)

Robert Tulloch — Mon, 02 Apr 2018 15:48:16 +0000

Hi:

Want to use SP. Send it unique record id number, use that in a fetch and return the unique record id number of the record the cursor has moved to. Use that returned unique record id to load that corresponding record into form fields.

Question: Cursor is non-scrollable. You can only fetch rows in order determined by
select statement. So if I have two SP's, one with a SELECT DESC and another with a SELECT ASC, depending on which one I call, I can scroll back and forth using the two procedures.

Is that a correct assumption before I spend time on this?

Thanks.

Beginning and end of table (6 replies)

Robert Tulloch — Thu, 29 Mar 2018 13:00:37 +0000

Is there a flag I can read which will tell me if the pointer is at the beginning or end of a table irrespective of order?

Problem starting MySQL (5.5.16) Workbench (no replies)

Mukul chadha — Tue, 13 Dec 2016 12:14:15 +0000

Full and fresh install of MySQL 5.5.16. MySQL Workbench started ok.
After computer restarted, running MySQL WorkBench has encountered a problem, and I should close (or report the bug).
Information received in the dialog window:
Access to the path 'C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.35\db_utils.pyc' is denied. Sexless marriage

How to repeat:
Click MySQL Workbench CE 5.2.35. The same error occured.

No Schemata Listed for Access Migration (1 reply)

G Raja — Mon, 12 Dec 2016 09:23:39 +0000

I've exact same symptoms as described in http://forums.mysql.com/read.php?65,646707,646707#msg-646707.

OS: Win 10 64 bit Professional
MySQL:
MySQL Workben: 6.3.7 build 1199 CE (64 bit) Community Edition
Access Product: Not Installed
Access ODBC Driver: 14.00.7010.1000 64 bit

As mentioned in above post: Documentation shows Access as an option in Database System combobox but I've not Access option so chose Generic RDBMS.

Database System: Generic RDBMS
Connection Method: ODBC Data Source
DSN: Valid DSN

Below is log from Fetch Schema List screen:

Starting...
Connect to source DBMS...
- Connecting to source...
Connecting to ...
Opening ODBC connection to DSN=BTLicUpd...
Connected
Connect to source DBMS done
Check target DBMS connection...
- Connecting to target...
Check target DBMS connection done
Retrieve schema list from source....
- Checking connection...
- Fetching catalog names...
- Fetching schema names...
- Fetching schema names from D:\Dev\BTechSoft\Received Files\BTLicense - Upd.accdb...
- Finished
Retrieve schema list from source finished
Finished performing tasks.

Now, clicking Next takes me to Schema Selection screen but there is no schema listed and the Next button is disabled.

I wrote a little PowerShell script and connecting to same DSN and it successfully lists all the tables. So, obviously the Access file itself is good; the DSN is good too. Something is amiss in MySQL Migration Utility.

PowerShell Script:

$conn = new-object System.Data.odbc.odbcconnection
$conn.ConnectionString = "DSN=;Uid=Admin;Pwd=;"
$conn.Open()
$schema = $conn.GetSchema("Tables")
echo $schema

Please help. Our ability to use MySQL in place Access hinges on successful migration of current Access db. Thanks.