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???