By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,099 Members | 2,156 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,099 IT Pros & Developers. It's quick & easy.

Quick Question about Missing References

P: n/a
I have noticed that when I move my database onto a different
computer, I often get a message about some reference missing. So I go
into the reference list, and find the one that says "Missing," and I
uncheck it.

Everything appears to work fine after that, however, this raises
two questions in my mind.

1. Does simply unchecking the missing reference cause me to lose any
functionality? I haven't noticed any yet, but that doesn't mean it
hasn't left an error waiting to happen.

2. If I create an MDE file from my database, (which if I am not
mistaken removes access to the code), will I still get the missing
reference errors?
Thanks,
Jody Blau

Mar 2 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"jodyblau" <jo******@gmail.com> wrote in message
news:11**********************@j33g2000cwa.googlegr oups.com...
I have noticed that when I move my database onto a different
computer, I often get a message about some reference missing. So I go
into the reference list, and find the one that says "Missing," and I
uncheck it.

Everything appears to work fine after that, however, this raises
two questions in my mind.

1. Does simply unchecking the missing reference cause me to lose any
functionality? I haven't noticed any yet, but that doesn't mean it
hasn't left an error waiting to happen.

2. If I create an MDE file from my database, (which if I am not
mistaken removes access to the code), will I still get the missing
reference errors?
Thanks,
Jody Blau


Which references are coming up as missing? Do you know for sure whether
they are needed or not? My general policy is to use as few references as
possible. If I am going to hand the application over, I always choose late
binding over early binding so for example if I write code to automate
writing Word documents, my code will be:
Dim wdDoc As Object (rather than As Word.Document)
in this way, I can remove the reference to Microsoft Word and I no longer
need to worry if my customer changes his/her version of Word.
Before you hand anything over, you should make sure it compiles. If you are
providing an mde, then you will have to be able to compile the mdb first.
Remove all but the essential references and make sure it compiles (this
might only be 3 references).


Mar 2 '06 #2

P: n/a
1) You should remove the reference and recompile. If Access doesn't choke
at that point then you don't need the reference.

2) Yes. Compiling into an MDE does nothing to fix missing reference
problems.

Because of the strange way in which Access handles references you should:-
keep the number of references down to a minimum
ensure you distribute any non-builtin referenced files (and there
supporting files)
check in code that your references are valid when starting

You may see reccomendations to use late binding, this is not a fix for
missing references, it merely obscures the fact that you have a references
problem and can just hide potential bugs in your code.

There are occassions where using late binding is required, the notable ones
are when automating Microsoft applications due to the (often stupid) choices
made by Microsoft development over the years regarding maintaining
compatibility.
--

Terry Kreft
"jodyblau" <jo******@gmail.com> wrote in message
news:11**********************@j33g2000cwa.googlegr oups.com...
I have noticed that when I move my database onto a different
computer, I often get a message about some reference missing. So I go
into the reference list, and find the one that says "Missing," and I
uncheck it.

Everything appears to work fine after that, however, this raises
two questions in my mind.

1. Does simply unchecking the missing reference cause me to lose any
functionality? I haven't noticed any yet, but that doesn't mean it
hasn't left an error waiting to happen.

2. If I create an MDE file from my database, (which if I am not
mistaken removes access to the code), will I still get the missing
reference errors?
Thanks,
Jody Blau

Mar 3 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.