Bug #65482 ODBC MS Access 2010 link table, table name with underscore and > 16 chars
Submitted: 1 Jun 2012 7:17 Modified: 1 Jun 2012 12:04
Reporter: stievy dude Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:5.1.11 OS:Windows (7)
Assigned to: Bogdan Degtyariov CPU Architecture:Any
Tags: Access 2010, MyODBC, windows 7

[1 Jun 2012 7:17] stievy dude
Description:
If you have a table with a name with an underscore in, and a tablename with a lengt greater than 16 characters, and you try to link the table in MS Access 2010 with odbc-connector version 5.1.*, MS Access 2010 crashes.

If you link the tables with odbc-connector 3.51.30, it doesn't crash.

I haven't tried it on another Windows or Access.

How to repeat:
1. Have a database with a table with an underscore in the name and the length of the tablename has to be more than 16 characters. Example: pktest_testtable
2. Make an odbc-connection via odbc data source administrator.
3. Open a new or an existing db in MS Access 2010, go to external data, ODBC Database.
4. Select linked tables and select your odbc-connection you created in step 2.
5. Select your database (pktest_testtable) and press ok. Now MS Access 2010 crashes.

Suggested fix:
Fix it so that longer tablenames with an underscore in it can be linked.
[1 Jun 2012 9:40] stievy dude
Seems to happen when the tablename is long.
I just created a new database "testdatabase"
and following tables:
pkutestdatabaseblablabla
pk_testdatabaseblablabla

I can't seem to connect to both of them.
[1 Jun 2012 9:41] stievy dude
Seems to happen when the tablename is long.
I just created a new database "testdatabase"
and following tables:
pkutestdatabaseblablabla
pk_testdatabaseblablabla

I can't link both tables.
[1 Jun 2012 11:04] Bogdan Degtyariov
This is a duplicate of bug 
http://bugs.mysql.com/bug.php?id=65200

The patch is in review now, but you can apply it to the existing sources 
and build the driver yourself.
[1 Jun 2012 12:04] stievy dude
How do I apply the patch to the driver?