MySQL Bugs: #14846: Problem with connecting with the root and then connecting as a Select User

Bug #14846	Problem with connecting with the root and then connecting as a Select User
Submitted:	10 Nov 2005 18:32	Modified:	28 May 2013 13:02
Reporter:	Nathaniel Hanks	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	3.51.12	OS:	Windows (Windows 2000 SP4)
Assigned to:		CPU Architecture:	Any

Description:
I just recently upgraded the mysql server to 4.1.14 and the connector to 3.51.12
I am using MS Access to do a couple things with the mysql server.
I run reports and upload data to the Server(using LOAD DATA LOCAL INFILE through an ado connection.)
On my computer I have a dsn to the mysql database.

I can run reports using this dsn until I run a upload from another database.
After that I have to use the Table Link Manager to Refresh the links
The upload always seems to run correctly as coded below.

cnServer.ConnectionString = "ODBC;DSN=ddr;Server=-leftblank-;DRIVER={MySQL ODBC 3.51 Driver};DATABASE=ddr;UID=root;PWD=-leftblank-"

cnServer.Open

 rsServer.Open "LOAD DATA LOCAL INFILE '" & EscapeBackslashes(strFileName) & "' " & _
                  "INTO TABLE ddr." & strTable & " " & _
                  "FIELDS TERMINATED BY ',' ENCLOSED BY '""' " & _
                  "LINES TERMINATED BY '\r\n'", cnServer

But after this code runs my access databases have to be relinked or access crashes. 

fyi
- The dsn id and password are different to the code above
- I have tried setting up another dsn to the database allowing an upload id ,but this caused access to always crash.
- I have tried dsnless connection but for some reason it doesnt want to work.
- I did have an upload id that I was using before the upgrades.  But I cant get that ID to work properly anymore.

How to repeat:
Not sure if this will work

Create a dsn to the Database using a Select ID
link tables to Access
Connect to the dsn using ado with the root id
run a query using one of the linked tables

Suggested fix:
dont know

Could you please write here any test case to reproduce the bug ?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.