Hi All,
I have upgraded an Access Back End to SQL Server 2000 with the front end still in Access 2000. This old line of code (that worked in Access BE) generates an "3146: ODBC Connection failed error" as the Connection timesout on the line when I try to set rstTemp = dbsTemp.OpenRecordset
It needs to possible to rollback the transaction also, which is why I was using the cloned workspace in the firstplace.
I'm just stumped and have had very little progress in solving this one on my own.
I would greatly appreicate any of your help or ideas.
Thanks,
strDBName = CurrentDb.Name
Set wspClone = Application.DefaultWorkspaceClone
wspClone.BeginTrans
fTran = True
Set dbsTemp = wspClone.OpenDatabase(strDBName)
' Get max rec from table
Set rstTemp = dbsTemp.OpenRecordset(strSQL)
I have upgraded an Access Back End to SQL Server 2000 with the front end still in Access 2000. This old line of code (that worked in Access BE) generates an "3146: ODBC Connection failed error" as the Connection timesout on the line when I try to set rstTemp = dbsTemp.OpenRecordset
It needs to possible to rollback the transaction also, which is why I was using the cloned workspace in the firstplace.
I'm just stumped and have had very little progress in solving this one on my own.
I would greatly appreicate any of your help or ideas.
Thanks,
strDBName = CurrentDb.Name
Set wspClone = Application.DefaultWorkspaceClone
wspClone.BeginTrans
fTran = True
Set dbsTemp = wspClone.OpenDatabase(strDBName)
' Get max rec from table
Set rstTemp = dbsTemp.OpenRecordset(strSQL)