Opening an Access db within vba

[Jim Franklin]

Hi,

Can anyone tell me the best way of opening an Access db from within the vba
code of another Access db? The db I want to open is protected by user-level
security with a .mdw file.

Basically I need to circumvent the usual Logon Name / Password process when
opening a workgroup-protected .mdb and replace it with a single form,
non-protected Access file which opens the new db with correct user name and
password parameters. At the moment I am doing this by executing a Shell
command within the vba, but I wonder if there is a better way to do this.

If there isn't, can anyone tell me if there is a way of knowing if the Shell
command executed successfully?

Many thanks,

Jim

 

[Daniel Pineault]

As for 'If there isn't, can anyone tell me if there is a way of knowing if
the Shell command executed successfully?', you can use the code found at the
following url to return the output from the Shell command to the user...

http://www.j.nurick.dial.pipex.com/Code/VBA/vbPerlish.htm
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.