all,

I created a dsn for one of my tables on a mysql database here in the last couple of days. Today, for some reason, I am getting a credentials popup everytime I try to open the table directly, or with a form. Here is my sub for creating the table through the DSN:

Code:
Private Sub LinkTable()

Dim db As Database, tdfLink As TableDef

Set db = CurrentDb

        Set tdfLink = db.CreateTableDef("tbl")
        tdfLink.SourceTableName = "tbl_be"
            'Identify its path
        tdfLink.Connect = "ODBC;FileDSN=c:\mysql5-1.dsn;"
        db.TableDefs.Append tdfLink
        
Set tdfLink = Nothing
Set db = Nothing

End Sub
Here is the actual DSN file that's being used:
Code:
[ODBC]
DRIVER=MySQL ODBC 5.1 Driver
[DATA SOURCE NAME] = mydb.db.addressnum.hostedresource.com (this is fine)
UID = username
PWD = password
OPTION=35
Database = mydb (this is correct)
SERVER = myip (this is also fine)
In the mysql connection dialog that pops up, I am checking the boxes 'don't prompt connect' and 'reconnect automatically'.



I did not have this problem recently, but today now I'm getting it. Any thoughts from the masterminds here???