Problem with access runtime...

Hi,

Got problem with runtime access. When i launch access for the first time, it
works ok. But if i need to open a new report in a second instance of access,
it tries to
open the database in the first access, not in the second.

And i can't getobject on access.application using the runtime access, i must
use the shell() command to launch access first, and then do a
getobject(dbname).

It seems that my problem is that getobject find only the first window of
access, not the second. As the shell command returns a double with the pid
process number in it, is there any way than i can do something like :

set x = getobject(PIDNumberOfAccess) ...

Maybe using hwnd property or something like that, PLEASE HELP !

Thx

 > And i can't getobject on access.application using the runtime access,

No, but can't you do
set obj = GetObject("report.mdb")

 > process number in it, is there any way than i can do something like :

I think the two easiest other methods are 1) You can de-register the
existing object. 2) You can change the window title of the existing
object, then use DDE to control the second object. DDE uses the
window title rather than the object ID to identify the object.

(david)

"Weby" <webpro DeleteThis @netforspeed.com> wrote in message
news:3f83dc30$0$2793$626a54ce@news.free.fr...
 > Hi,
 >
 > Got problem with runtime access. When i launch access for the first time,
it
 > works ok. But if i need to open a new report in a second instance of
access,
 > it tries to
 > open the database in the first access, not in the second.
 >
 > And i can't getobject on access.application using the runtime access, i
must
 > use the shell() command to launch access first, and then do a
 > getobject(dbname).
 >
 > It seems that my problem is that getobject find only the first window of
 > access, not the second. As the shell command returns a double with the pid
 > process number in it, is there any way than i can do something like :
 >
 > set x = getobject(PIDNumberOfAccess) ...
 >
 > Maybe using hwnd property or something like that, PLEASE HELP !
 >
 > Thx
 >
 >
 ><!-- ~MESSAGE_AFTER~ -->