B
Burnsie
I am having trouble getting the activeconnection to run. I am loading data
into an Access 2003 table(tblModules) but calling it from PPT 2003.
Sometimes it runs and sometimes it doesn't. I usually get the error
-2147467259 which basically tells me I have an invalid path. Here is my code:
m_strcnxTracker = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source =C:\WedgeManagement\Technical Management\Current
Development\" & _
"Database\Juice\WEdgeModuleTracker.mdb"
Set rstTrackerModule = New ADODB.Recordset
rstTrackerModule.Open "tblModules", , adOpenDynamic, adLockOptimistic
Several parts of the connection string are actually variables but I hard
coded it to see if it made any difference. No luck.
By the way, if I refer to the Northwind database in the customary folder,
the connection has never failed.
And can someone tell me the difference between using activeconnection and
just an open statement.
Thanks for the help.
Burnsie
into an Access 2003 table(tblModules) but calling it from PPT 2003.
Sometimes it runs and sometimes it doesn't. I usually get the error
-2147467259 which basically tells me I have an invalid path. Here is my code:
m_strcnxTracker = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source =C:\WedgeManagement\Technical Management\Current
Development\" & _
"Database\Juice\WEdgeModuleTracker.mdb"
Set rstTrackerModule = New ADODB.Recordset
rstTrackerModule.Open "tblModules", , adOpenDynamic, adLockOptimistic
Several parts of the connection string are actually variables but I hard
coded it to see if it made any difference. No luck.
By the way, if I refer to the Northwind database in the customary folder,
the connection has never failed.
And can someone tell me the difference between using activeconnection and
just an open statement.
Thanks for the help.
Burnsie