I have an application that uses two programs, both written in the same version of VB6 (SP5), The first program opens up an access database, whilst this is open, a shell and wait executes the second program, which also opens up the same database.
On win 2000, this sequence works well
On Win XP (Pro) this sequence does not work, Second program complains with a -2147023782 error code (Catastrohic database error)
To further complicate this, if the second program is run on it's own than this also works, in other words, it only fails when it is shelled to, and only on win xp
On win 2000, this sequence works well
On Win XP (Pro) this sequence does not work, Second program complains with a -2147023782 error code (Catastrohic database error)
To further complicate this, if the second program is run on it's own than this also works, in other words, it only fails when it is shelled to, and only on win xp