Arguments against using SHELL for opening Access from VB6

[chris]

Are there any arguments against using SHELL command for opening Access from
VB6 ?

I will define full path of access, system.mdw path, user name and password
and database path to be opened.

I was not able to find another way for defining all these parameters together.

Thanks a lot in advance.

 

[Damian S]

Hi chris,

What are you trying to achieve?

Damian.

 

[chris]

Hi Damian,

I am thinking of having a small VB6 program for user to type user name &
password for the program. The info received will be validated against the
program's system.mdw, if it's correct it will try to create an access
application for opening an MDE (front-end) program with the program's
system.mdw, user name and password.

example:

SHELL("C:\program files\office\MSACCESS.EXE /wrkgroup c:\system.mdw c:\my
program\menu1.mde /usr user1 /pwd aa")

Small program in VB6 will check whether c:\my program\menu1.mde is open for
opening c:\my program\menu2.mde, otherwise c:\my program\menu3.mde. I have 5
menu.mde databases.