I am using the following code to append a password protected paradox database
Dim dbs As Database
Set dbs = CurrentDb
Dim strTableName As String
strTableName = "Data-PL"
Dim tdf As TableDef
Set tdf = dbs.CreateTableDef(strTableName)
tdf.Connect = "Paradox 3.X;PWD=xx;HDR=NO;IMEX=2;DATABASE=C:\Data"
tdf.SourceTableName = strTableName
dbs.TableDefs.Append tdf
rst.Close
dbs.close
If the access database is closed and then reponed, any attempt to manually link to the table is propmted with a password prompt.
However if the database is not closed, a manual link to the paradox table is performed without promting for password.
I think that access is holding onto the tabledef connection string and reusing it for further connections to the same paradox database.
If this is the case, Does anyone know how to remove/clear the tabledef connection string ?
Smed
Dim dbs As Database
Set dbs = CurrentDb
Dim strTableName As String
strTableName = "Data-PL"
Dim tdf As TableDef
Set tdf = dbs.CreateTableDef(strTableName)
tdf.Connect = "Paradox 3.X;PWD=xx;HDR=NO;IMEX=2;DATABASE=C:\Data"
tdf.SourceTableName = strTableName
dbs.TableDefs.Append tdf
rst.Close
dbs.close
If the access database is closed and then reponed, any attempt to manually link to the table is propmted with a password prompt.
However if the database is not closed, a manual link to the paradox table is performed without promting for password.
I think that access is holding onto the tabledef connection string and reusing it for further connections to the same paradox database.
If this is the case, Does anyone know how to remove/clear the tabledef connection string ?
Smed
