> Hi

> I am working on the maintenance of an old app. in VB3 and Access 2.0
> and seem to have a fundamental problem.

> The following code fragment causes Access 2.0 to hang (i.e. when I
> press CTRL-ALT-DEL it is reported as not responding).

> Sub Form_Load ()
> a = Shell("c:\access\MSACCESS.EXE c:\mis\livedb\mis.mdb")
> End
> End Sub

> It doesn't matter what database I actually use - it still crashes -
> but works fine if I supply the name of a non-existant database (i.e.
> Access reports that the database doesn't exist and it doesn't hang).

> Grateful for any help.

> Adrian Sims

>> Hi

>> I am working on the maintenance of an old app. in VB3 and Access 2.0
>> and seem to have a fundamental problem.

>> The following code fragment causes Access 2.0 to hang (i.e. when I
>> press CTRL-ALT-DEL it is reported as not responding).

>> Sub Form_Load ()
>> a = Shell("c:\access\MSACCESS.EXE c:\mis\livedb\mis.mdb")
>> End
>> End Sub

>> It doesn't matter what database I actually use - it still crashes -
>> but works fine if I supply the name of a non-existant database (i.e.
>> Access reports that the database doesn't exist and it doesn't hang).

>> Grateful for any help.

>> Adrian Sims

>Have you tried opening c:\mis\livedb\mis.mdb in Access without using a
>shell statement? ie. clicking on the Access icon and then File | Open
>c:\mis\livedb\mis.mdb.  Do you have Access properly installed on your
>system?  Perhaps the database is corrupted or something.
>--
>To respond via e-mail, please remove what's between Eric and Goforth in
>my address in order to get my real e-mail address.