Converting ODBCDirect to 2007 code

[SJ]

Hi all,

i've noticed that Access2007 doesn't like to use ODBCDirect workspace stuff.

We have quite a large App, about 800 forms etc. with a SQL Server backend
2000 - 2005 tables are ODBC linked.

We use the ODBCDirect workspace connection method frequently when we want to
execute SQL code or run a Stored Proc which quite often might return a
recordset.
But that doesn't work now.

So the question i'd like to ask is this,

Given all the new Data Access Methods over the last few years, what should
we be looking at in order to upgrade our App to run under 2007.


we might use code such as

strSQL = "exec some stored procedure"
Set conMain = OpenConnection() ' this opens a connection against
an ODBCDirect Workspace
conMain.Execute strSQL
conMain.Close

OR
we have a procedure that returns a recordset from a temp querydef

SQLScript = "select * from sometable" 'usually not quite that
simple, quite often a stored proc that returns records
Set qdf = conMain.CreateQueryDef(, SQLScript)
Set rst = qdf.OpenRecordset(dbOpenForwardOnly)
Set rstObject = rst


So we have to consider those 2 scenarios...

thanks in advance...