Using MS Access 2000 I can link to Notes views using the Access client link tables feature no problem.
I have tried to implement a relink feature so that the Access app can be distributed a little easier (uses NotesSQL and SQL Server DSNs) however after apparently successfully relinking a notes view using
Set tdf = db.CreateTableDef(!LocalTableName, dbAttachSavePWD, !SourceTable, !connectstring)
db.TableDefs.Append tdf
(where the variables/parameters are all correctly defined) Access crashes with no specific error. (produces Dr Watson log)
I have tried all sorts of combinations of the connect string from the full to just ODBC;DSN=blah; to just ODBC; in order to invoke the select DSN dialog.
As I say the notes view links OK, its just that Access crashes immediately afterward. On restart the linked table is there all OK.
The access app also uses SQL Server linked tables and the relink feature works perfectly well for them.
MDAC, Jet, MS Office and Win2K are all up to date on service packs and NotesSQL is 3.02
Any clues?
thanks
Paul