GKatReliable
Programmer
My VB app uses an Access 2000 mdb.
I have 3 processes (subs) in my program.
In each one, I try to invoke Access and get out the same way:
===========================
Dim objAccess as New Access.Application
Set objAccess = GetObject(mdbFile)
With objAccess
DoCmd.OpenTable myTable
blah blah blah
End With
objAccess.Quit
Set objAccess = Nothing
============================
When I run ANY of the 3 subs individually first, they work just fine. But when I click on the SECOND one, it bombs (no matter which one it is) with Run-time error 462 The remote server machine does not exist or is unavailable.
The file is sitting in the same mapped NT network folder as the app. No special servers or anything.
I must not be releasing something properly, but I thought the code above was all you needed to do.
What am I leaving out?
I have 3 processes (subs) in my program.
In each one, I try to invoke Access and get out the same way:
===========================
Dim objAccess as New Access.Application
Set objAccess = GetObject(mdbFile)
With objAccess
DoCmd.OpenTable myTable
blah blah blah
End With
objAccess.Quit
Set objAccess = Nothing
============================
When I run ANY of the 3 subs individually first, they work just fine. But when I click on the SECOND one, it bombs (no matter which one it is) with Run-time error 462 The remote server machine does not exist or is unavailable.
The file is sitting in the same mapped NT network folder as the app. No special servers or anything.
I must not be releasing something properly, but I thought the code above was all you needed to do.
What am I leaving out?
