How to Open a different Database File Whithin another
Hi Eduardo,
As far as I know, from code, you still only can use SendKeys.
OpenCurrentDatabase etc. work fine with Automation but not from the database
where the code is executing. Try
SendKeys "%FO" & strInMDB & "~"
where strInMDB is the full path to the database you're trying to open.
HTH
--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------
:I've tried several things without success
:The only one is exiting msaccess completely but there must be anyway to
:close the current database file and open another one automatically.
:
:Can you please help me???
:
:Thank you very much
:Eduardo Daz
:Canary Islands, Spain.
:
:
:
:
