mole999
Well-known Member
- Joined
- Oct 23, 2004
- Messages
- 10,524
- Office Version
- 2019
- 2016
- 2013
- Platform
- Windows
Up until two days ago this was working
work has been doing changes over the WAN moving all users from 2003 to 2007, and although I have a dual install i suspect that some of the changes are removing files from paths that still exist.
I cannot compile any longer this statement without getting
Compile error:
User-Defined Type Not Defined
The libraries look ok, a full shut down and restart hasn't cleared the problem.
Previously compiled and the code still works.
When I retype in 2007 I get to "Dim cnt As New" then ADODB is not an offered option, frankly i'm stuck.
Any other way that this could be written to retrieve data from an SQL database, speed isn't an object, just trying to work around our techs, until they understand what they are doing
I've searched the forum but not found an answer
Code:
Dim cnt As New ADODB.Connection
work has been doing changes over the WAN moving all users from 2003 to 2007, and although I have a dual install i suspect that some of the changes are removing files from paths that still exist.
I cannot compile any longer this statement without getting
Compile error:
User-Defined Type Not Defined
The libraries look ok, a full shut down and restart hasn't cleared the problem.
Previously compiled and the code still works.
When I retype in 2007 I get to "Dim cnt As New" then ADODB is not an offered option, frankly i'm stuck.
Any other way that this could be written to retrieve data from an SQL database, speed isn't an object, just trying to work around our techs, until they understand what they are doing
I've searched the forum but not found an answer