Hello all, is it possible to access an "MS Access" mdb via OLEDB using SPT ?, I've managed it with ADO but would prefer to use SPT if possible, I tried it with the code below but this resulted in a dialog prompting me for a DSN
cConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\myserver\sys\apps\data\mydata.mdb"
nHan = SqlStringConnect(cConnStr)
Regards,
Peter J. Kane
Pete