creating an MDE file when the MDB file references another database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul James - 31 Oct 2004 07:02 GMT

In Access 2002 Help, under the topic "Improve perfromance of an Access
database," there is a section on MDE files, in which it says:

"To save a database that references another database as an MDE file, you
must save all databases in the chain of references as MDE files."

What does it mean to say that one database "references" another database?
Are they referring to linked tables? If so, I'm puzzled, because I've
created mde files out of front ends in split databases, but did not convert
the mdb back end into an mde file, and it seems to work just fine.

So what does Access Help mean when they refer to one database as
"referencing" another database?

Thanks in advance,

Paul

Reply to this Message

Jeff Boyce - 31 Oct 2004 12:32 GMT

Paul

Consider the situation in which you've created a "library" of routines.
Rather than importing these into your front-end, you could elect to
"reference" the library by going into a code module and selecting Tools |
References and browsing to the library you created.

Note that this is also how you'd reference the Excel object model, if you
needed functions already available in Excel, or the Outlook object, if you
want to use it to send email, or ...

Signature

Good luck

Jeff Boyce
<Access MVP>

> In Access 2002 Help, under the topic "Improve perfromance of an Access
> database," there is a section on MDE files, in which it says:
[quoted text clipped - 13 lines]
>
> Paul

Reply to this Message

Paul James - 31 Oct 2004 22:07 GMT

Ok, that explains what they mean by "referencing" another database.

Thanks, Jeff.

Paul

Reply to this Message