Switching databases

[Nick]

I won't to be able to switch from one database to another using VB. I was
relatively happy using SendKeys but, having installed Access2007, now find
this fails.

I've yet again looked at RunCommand acCmdOpenDatabase to no avail, just get
a 'This command is not available now' message. Using OpenCurrentDatabase
opens the database but doesn't switch to the database.

Any thoughts greatly appreciated.

 

[Alex Dybenko]

Hi,
there is an addin for access 2000, perhaps it will work for 2007 also, you
can try
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=8

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com