Code define
- Thread starter dr223
- Start date
LPurvis
AWF VIP
- Local time
- Today, 16:50
- Joined
- Jun 16, 2008
- Messages
- 1,269
OK, I haven't got time to check the status of your other thread - as to whether this one is still active or the other. (As I too believe if they're the same topic only one should be followed through with).
Are you using linked tables now?
The querydef creation line can be used directly analogously with a local database object
i.e. instead of
Set qDF = cON.CreateQueryDef("", strSQL)
using
Set qDF = db.CreateQueryDef("", strSQL)
where db has been defined and created as usual
Dim db as DAO.Database
Set db = CurrentDb
If you're not wanting the ODBC Direct connection method then you could remove all workspace and connection code.
I can't recall where you're at though.
Cheers.
Are you using linked tables now?
The querydef creation line can be used directly analogously with a local database object
i.e. instead of
Set qDF = cON.CreateQueryDef("", strSQL)
using
Set qDF = db.CreateQueryDef("", strSQL)
where db has been defined and created as usual
Dim db as DAO.Database
Set db = CurrentDb
If you're not wanting the ODBC Direct connection method then you could remove all workspace and connection code.
I can't recall where you're at though.
Cheers.
