Use code to make a mde as reference

[Harry H]

Hi all, I have a mdb and a mde file. I need to use vba on the MDB to code
the mde as a reference to the mdb. Is this possible and example. Thanks in
advance.

 

[Arno R]

Hi all, I have a mdb and a mde file. I need to use vba on the MDB to code
the mde as a reference to the mdb. Is this possible and example. Thanks in
advance.

Application.References.AddFromFile "C:\YourDirPath\YourRef.mde"

Arno R

 

[TC]

You realize that an MDB can not reference an MDE?

HTH,
TC

 

[Rick Brandt]

You realize that an MDB can not reference an MDE?

Huh? How could one make an MDE that references another MDE if one doesn't start
out with an MDB that references an MDE?

 

[TC]

I haven't tried it myslf, but I was under the impression that you can
not /save/ an mdb if it references an mde. But you can set the
reference for the sake of generating the mde.

I was going from "Saving a Database That References Another Database as
an MDE File", here:
"http://msdn.microsoft.com/archive/d...s/office97/html/protectingyourapplication.asp

Yes? No?

TC

 

[TC]

Ooo, perhaps I misread that & it says that you can not save an /mde/
which references an /mdb/ ?

TC

 

[Rick Brandt]

Ooo, perhaps I misread that & it says that you can not save an /mde/
which references an /mdb/ ?

TC

Okay, that one I believe I have heard as well. I was pretty sure that I had
MDBs in the past that used Stephen Lebans' report-to-RTF MDE as references
without a problem.

 

[Arno R]

Ooo, perhaps I misread that & it says that you can not save an /mde/
which references an /mdb/ ?

TC

If you have an mdb (as the OP has) and want to set a reference to an mde (as the OP says he wants) than you can try:
Application.References.AddFromFile "C:\YourDirPath\YourRef.mde" as I have said in my post.
e.g. I have a codelib (saved as mde) that I reference this way in a production mdb (just to protect some code I am using).

Or am I misreading the question here??

Arno R

 

[TC]

No, I think that I was the one who misread/misunderstood it.

Cheers,
TC