open a database programatically

[ziwacky]

Can I open another database programatically so that user will have two instances of Access open. What my program does is that it executes some changes in another database and I want to avoid the user to have to go and open the new database to see the changes reflected. Can I write my code so that it opens up automatically?

Thank you,

Z

 

[jgoodman00]

try the shell command

something like:

shell("Database path, name & openargs here"

James Goodman
j.goodman00@btinternet.com

 

[UncleJack]

See Help under OpenDatabase Method. Sounds like this is what you want. Either that or consider modifying your database so that the changes made in the other database are reflected in the current one so the user doesn't have to jump between applications.

Uncle Jack