473,320 Members | 1,859 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

What is a Library mde/mdb?

Jeff Pritchard's current thread on stopping a library mde being used
made me realize I don't have a clue what he's talking about. I would
have asked there, but didn't want to hijack his thread.

What is a library mde? Is this like an add in of some sort? I have
considerable "libraries" of functions I use over and over again in
different apps, but these are more in the realm of remembering I've done
something similar before and copying over the procs or even a full
module from one or more previous apps into the current app.

Thanks in advance.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Dec 21 '05 #1
9 1811
On Wed, 21 Dec 2005 09:58:15 -0330, Tim Marshall <TI****@PurplePandaChasers.Moertherium> wrote:
Jeff Pritchard's current thread on stopping a library mde being used
made me realize I don't have a clue what he's talking about. I would
have asked there, but didn't want to hijack his thread.

What is a library mde? Is this like an add in of some sort? I have
considerable "libraries" of functions I use over and over again in
different apps, but these are more in the realm of remembering I've done
something similar before and copying over the procs or even a full
module from one or more previous apps into the current app.

Thanks in advance.


If you maintain all your reusable code in an mde file, this file can be set as reference in another mdb/mde.
Copy your library mde to a location of your choice and in the mdb, in the code window select Tools/References from the
menus. Browse to the location of your library file and select it. A reference is now set to the mde.

Any subs/functions contained in the library can now be called directly from your mdb as if the modules existed in the
mdb.

The modules from the library are not visible in the db window of the mdb and the routines from the library cannot be
edited.

They are very handy for routines that you use in most databases you create.
Wayne Gillespie
Gosford NSW Australia
Dec 21 '05 #2
"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> schreef in bericht news:do**********@coranto.ucs.mun.ca...
Jeff Pritchard's current thread on stopping a library mde being used
made me realize I don't have a clue what he's talking about. I would
have asked there, but didn't want to hijack his thread.

What is a library mde? Is this like an add in of some sort? I have
considerable "libraries" of functions I use over and over again in
different apps, but these are more in the realm of remembering I've done
something similar before and copying over the procs or even a full
module from one or more previous apps into the current app.



Hi Tim,

An mde can be referenced. The code inside the mde is available then, but not visible for 'the world'.

I asked similar questions about the possibility of hiding code when delivering mdb's.
(I have clients that just want or demand to get mdb's delvered)
I also use some (sometimes a lot of) common code in all my databases.
Did not want to 'give that away' just like that.
So I decided to use a codelib.mdb compiled as codelib.mde to protect the code.
I did not even think of protecting the use of the mde but I might reconsider this.

Arno R
Dec 21 '05 #3
I don't wish to criticize those who use mdes, librarys and such. There
are probably many good reasons for doing so and, clearly, many fine
developers find them useful.
I don't use mdes or librarys, just mdbs and adps. Typically everything
I write is public and can be examined, used and copied. I try to hide
only db logins and passwords.

Perhaps I've had something stolen; perhaps I've even complained but I
can't remember any such times now so they must have never occurred or
else they were inconsequential or, perhaps, I've had a bit too much egg
nog, or maybe the code is just crap and nobody wants it! Maybe all of
the above.

All those great general functions? When I need one I go to Copernic
Desktop search, find it (them actually cuz I've usually written
everything in several different ways) and copy one of them into a
module. Inefficient? Maybe. When one gets paid by the hour or byte one
cannot afford to be TOO efficient.

Just some idle thoughts Tim, so that you realize that there are other
ways of looking at these things.

Dec 21 '05 #4
On Wed, 21 Dec 2005 15:13:26 GMT, Wayne Gillespie
<be*****@NOhotmailSPAM.com.au> wrote:

c:\program files\common files\<your company name> Shared
would be a better choice than most.

-Tom.
<clip>
Copy your library mde to a location of your choice

<clip>

Dec 22 '05 #5
Sky
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:kh********************************@4ax.com...
On Wed, 21 Dec 2005 15:13:26 GMT, Wayne Gillespie
<be*****@NOhotmailSPAM.com.au> wrote:

c:\program files\common files\<your company name> Shared
would be a better choice than most.


Perhaps on your development computer, but NOT on the deployed user's
computer. If you have multiple front-end applications using a library
database, and you update the library, you probably also need to update the
front end, and you absolutely must update the front-end if you use a
compiled Mde.

You don't want to update one application with its library, and break another
application.

- Steve
Dec 22 '05 #6
Its because of the security issue that I don't use a library. On the
other hand, I don't want to be re-typing code that I've previously
written.

I have an mdb that contains nothing but a series of modules, calandar
form, date selection form and a few other bits and pieces that I use
often. This sits on my development machine.

When I want one of my little gems, I simply either import the form,
module etc or goto my storage mdb and copy the code I want, then past
it to my current project.

No matter how smart the pirate is, they can't hack what they can't see
and use what isn't there. Makes my apps smaller too.

Dec 22 '05 #7
"Sky" <sk*@NOSPAMstanleyassociates.com> wrote in
news:A9rqf.785$2B5.256@trnddc01:
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:kh********************************@4ax.com...
On Wed, 21 Dec 2005 15:13:26 GMT, Wayne Gillespie
<be*****@NOhotmailSPAM.com.au> wrote:

c:\program files\common files\<your company name> Shared
would be a better choice than most.


Perhaps on your development computer, but NOT on the deployed
user's computer. If you have multiple front-end applications using
a library database, and you update the library, you probably also
need to update the front end, and you absolutely must update the
front-end if you use a compiled Mde.

You don't want to update one application with its library, and
break another application.


Not only that, but putting it in a subfolder of the %PROGRAMS%
folder means that users have to run with administrative logons, or
that special permissions have to be set on the folder to allow
regular users to write to it. This is not necessarily an issue for
installation, but if you're pushing out regular upgrades
transparently, it will fail for non-administrative users.

In my opinion, it's a bad practice to place Access apps in the
%PROGRAMS% folder hierarchy.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Dec 22 '05 #8
Reading you comments, in a multi user environment, or even a single user, I
wonder what is wrong with simply placing a copy in the same location as the
front-end. Sure, if you have multiple applications installed that use it you
have multiple copies on a workstation, but who cares. I have done this for
years and never have a problem with a broken reference. Access always looks
in the current location and always resolves the reference.

Jeff

"David W. Fenton" <XX*******@dfenton.com.invalid> wrote in message
news:Xn*********************************@127.0.0.1 ...
"Sky" <sk*@NOSPAMstanleyassociates.com> wrote in
news:A9rqf.785$2B5.256@trnddc01:
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:kh********************************@4ax.com...
On Wed, 21 Dec 2005 15:13:26 GMT, Wayne Gillespie
<be*****@NOhotmailSPAM.com.au> wrote:

c:\program files\common files\<your company name> Shared
would be a better choice than most.


Perhaps on your development computer, but NOT on the deployed
user's computer. If you have multiple front-end applications using
a library database, and you update the library, you probably also
need to update the front end, and you absolutely must update the
front-end if you use a compiled Mde.

You don't want to update one application with its library, and
break another application.


Not only that, but putting it in a subfolder of the %PROGRAMS%
folder means that users have to run with administrative logons, or
that special permissions have to be set on the folder to allow
regular users to write to it. This is not necessarily an issue for
installation, but if you're pushing out regular upgrades
transparently, it will fail for non-administrative users.

In my opinion, it's a bad practice to place Access apps in the
%PROGRAMS% folder hierarchy.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Dec 22 '05 #9
Sky
"Jeff" <je************@asken.com.au> wrote in message
news:43***********************@per-qv1-newsreader-01.iinet.net.au...
Reading you comments, in a multi user environment, or even a single user, I wonder what is wrong with simply placing a copy in the same location as the front-end. Sure, if you have multiple applications installed that use it you have multiple copies on a workstation, but who cares. I have done this for
years and never have a problem with a broken reference. Access always looks in the current location and always resolves the reference.

Jeff


That is fine and that is what I do. What I discouraged was the suggestion of
distributing a single shared library in a single common location, referenced
by multiple front-end applications. It is better for each production
front-end application to have its own distinct copy of the library.

- Steve
Dec 23 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Tee | last post by:
Hi guys, I have a problem with my VS project, it keeps saying COM Interop registration failed. Could not find a type library for assembly 'Class1'. If I choose to continue, everything still work...
13
by: SailFL | last post by:
I have read threads here and there and I have looked at MS but I can not get a clear understanding of what .Net acutally is. I understand that C++ and Vb and other languages are being out a .Net. ...
2
by: santa19992000 | last post by:
Confusing th eword with "library", "shared library" and how to use these things in real C project, is there any small example I can take a look. Thanks.
26
by: Lasse Edsvik | last post by:
Hello I'm trying to build a simple COM+ app in vs.net using C# and i cant register it in component manager..... what more is needed than this: using System; using...
126
by: ramyach | last post by:
Hi friends, I need to write a parallel code in 'C' on the server that is running SGI Irix 6.5. This server supports MIPS Pro C compiler. I don't have any idea of parallel C languages. I looked...
14
by: copyco | last post by:
Can anyone tell me what the purpose is to adding items such as a VBScript file or HTML document to your VB.NET project? Once you have these things added, how to you access them and use them in...
12
by: David | last post by:
Does anybody know what language computer game programmers use? can you program games with visual studio .net? would they be of good quality?
24
by: Massimo Soricetti | last post by:
Think for a moment: IF you were Bjarne Stroustrup in 1985 (or whenever he were doing it) writing down C++, and knowing all you know NOW of the C++ language, (pro, cons, features of today...
0
by: tony | last post by:
Hello! I have one solution file that consist of three project. One project that build the exe file called A One project that build a user control dll. In this user control we have a class...
12
by: Benjamin B. | last post by:
Hi everyone, in this thing I inherited there's a statement like this: a &= ~b; where a is an int and b has been declared this way: const b = 0x0002;
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.