DevintheDude
Board Regular
- Joined
- Jun 8, 2007
- Messages
- 153
NOTE: FOR SOME REASON WHEN I TRY
DIM CONN AS NEW ADODB.CONNECTION
ADODB IS NOT AVAILBLE TO ME AS AN OBJECT WHY IS THAT?
dbdir = getdir(ActiveWorkbook)
partsdb = dbdir & "Product_PriceDB"
set dbspartslist = OpenDatabase(partsdb, , true)
set rstTemp = dbspartslist.OpenRecordset("CommonAssemblyname",dbOpenTable)
with rstTemp
//do something
end with
HOW DO I CONVERT THIS TO ACCESS THE SAME DATABASE JUST ON SQL SERVER?
DIM CONN AS NEW ADODB.CONNECTION
ADODB IS NOT AVAILBLE TO ME AS AN OBJECT WHY IS THAT?
dbdir = getdir(ActiveWorkbook)
partsdb = dbdir & "Product_PriceDB"
set dbspartslist = OpenDatabase(partsdb, , true)
set rstTemp = dbspartslist.OpenRecordset("CommonAssemblyname",dbOpenTable)
with rstTemp
//do something
end with
HOW DO I CONVERT THIS TO ACCESS THE SAME DATABASE JUST ON SQL SERVER?
Last edited: