V
Vern Hoppes
I have got an odd situation where the switchboard manager
worked fine and suddenly I can no longer create or view
switchboards. But it is not all databases, some older
Access 2000 databases don't have the problem, but more
recent ones do.Access 97 Databases are equally random,
connverted and non converted. When I open a switchboard I
get;
Run-Time Error '-2147024714 (800700b6)':
The operating system cannot run %1.
The problem at our location is unusual because certain
machines other then mine have the problem, then others do
not. when I go to debug the VB is breaking on;
Set con = Application.CurrentProject.Connection
The code for the switchboards that work has this code in
the Private Sub FillOptions();
Dim dbs As Database
Dim rst As Recordset
Dim strSQL As String
Dim intOption As Integer
The ones that don't have this code;
Dim con As Object
Dim rs As Object
Dim stSql As String
Dim intOption As Integer
A number of differences follow in the code, but this seems
to be the primary change. Why did it change and what do I
do? I have reloaded office, been everywhere in the
knowledge base I can find, even went to next version of
MDAC, what is wrong,,,, Help!
worked fine and suddenly I can no longer create or view
switchboards. But it is not all databases, some older
Access 2000 databases don't have the problem, but more
recent ones do.Access 97 Databases are equally random,
connverted and non converted. When I open a switchboard I
get;
Run-Time Error '-2147024714 (800700b6)':
The operating system cannot run %1.
The problem at our location is unusual because certain
machines other then mine have the problem, then others do
not. when I go to debug the VB is breaking on;
Set con = Application.CurrentProject.Connection
The code for the switchboards that work has this code in
the Private Sub FillOptions();
Dim dbs As Database
Dim rst As Recordset
Dim strSQL As String
Dim intOption As Integer
The ones that don't have this code;
Dim con As Object
Dim rs As Object
Dim stSql As String
Dim intOption As Integer
A number of differences follow in the code, but this seems
to be the primary change. Why did it change and what do I
do? I have reloaded office, been everywhere in the
knowledge base I can find, even went to next version of
MDAC, what is wrong,,,, Help!