Connect from one Secured Access DB to another, but different MDW f

[K Bare]

I've been looking, unsuccessfully, for VBA on how to connect from one mdw
secured database to another that has a different mdw file. Is this even
possible? I've found information to do this from VB, but not from VBA while
MS-Access is open with a different MDW file.

I just want to query data in another table that users have permissions to
read in another database.

Thanks,
- Kirk.

 

[Alex Dybenko]

Hi,
no, this is not possible, should be the same MDW.
Perhaps you can make some DLL on VB which will work as a bridge...

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

 

[K Bare]

Thanks Alex, That is what I had feared. I have no idea how to work with the
DLL process you suggest. If I do find out, you mention VB, will it work in
VBA?

 

[Alex Dybenko]

Hi,
yes, try to follow Chris advice, completely forgot about it, this is
undocumented object

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