Call Function In Secure Database

[tshillam]

I need some help from my Access collegues--a question for the security
experts. I have an Access database file with a public function (it uses
Access security). Meanwhile, I have another separate Access database
file (no security configured) with a function that calls a function in
the secure database file--it ain't workin right now.

I am trying to add a reference to the second file to the first (the
secure Access file). However its my notion life is not that simple;
that is, I apparently cannot add the reference to a secure Access file.
Note: I have an MDW file and Access User security is configured.

Thus my question; How can I call a function in the secure Access file
within a function in another database via VBA code?

Can somebody throw me a bone here? ADO? DAO? Oh...and its Microsoft
Access 97 I am working with here. In advance, thanks for the help.

Best regards,


Todd Shillam

 

[tshillam]

I need some help from my Access collegues--a question for the security
experts. I have an Access database file with a public function (it uses
Access security). Meanwhile, I have another separate Access database
file (no security configured) with a function that calls a function in
the secure database file--it ain't workin right now.

I am trying to add a reference to the second file to the first (the
secure Access file). However its my notion life is not that simple;
that is, I apparently cannot add the reference to a secure Access file.
Note: I have an MDW file and Access User security is configured.

Thus my question; How can I call a function in the secure Access file
within a function in another database via VBA code?

Can somebody throw me a bone here? ADO? DAO? Oh...and its Microsoft
Access 97 I am working with here. In advance, thanks for the help.

Best regards,


Todd Shillam

Never mind--I think I've answered my own question. For those that might
need a solution:

http://support.microsoft.com/kb/192919/EN-US/


Best regards,


Todd