Use code to make a mde as reference

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Harry H - 17 Dec 2005 14:04 GMT

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.

Reply to this Message

Arno R - 17 Dec 2005 14:49 GMT

> 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

Reply to this Message

TC - 17 Dec 2005 16:45 GMT

You realize that an MDB can not reference an MDE?

HTH,
TC

Reply to this Message

Rick Brandt - 17 Dec 2005 16:51 GMT

> 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?

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

TC - 17 Dec 2005 17:07 GMT

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/default.asp?url=/archive/en-us/office97/html/p
rotectingyourapplication.asp

Yes? No?

TC

Reply to this Message

TC - 17 Dec 2005 17:09 GMT

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

TC

Reply to this Message

Rick Brandt - 17 Dec 2005 17:24 GMT

> 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.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Arno R - 17 Dec 2005 18:00 GMT

> 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

Reply to this Message

TC - 18 Dec 2005 07:34 GMT

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

Cheers,
TC

Reply to this Message