References

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I go into the programming section in Access I go to tools and my
references are grayed out, but this only happens on certain machines. When I
log on to other machines my references are available. How do I add the MS
Access 9.0 object library?
 
The References option will be grayed out if there's code that's been stopped
in its execution. Try clicking on the Run menu, and see whether the End
option is enabled. If it is, click on it.

However, why do you feel it's necessary to add the MS Access 9.0 Object
Library? Assuming you're using using Access 2000, that reference should
already be set, and if you're not using Access 2000, you cannot use that
reference.
 
We are using Access 2000. There is a database this company uses where when a
user opens it a form to enter an ID and password pops up automatically.

There were users who entered their ID and password and the main menu form
would not come up, but if they logged on to another machine it would work
fine. What I noticed is that the machines that have "references" grayed out
are the ones that users cannot log on to the database...and vice versa for
the ones that do not have "references" grayed out.
 
You still haven't answered why you think it's necessary to add that
particular library.

Reference problems can be related to any particular library in the database.
If one reference is wrong, it can cause functions that exist in other
libraries to stop working, even though the other references are fine.

See whether using the technique I outline for reference problems for MDE or
runtime at http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
helps.
 
I clicked on the Run menu and the only options I have are continue, reset and
design mode. "Break" is grayed out. By the way, we're running Access 2000.
 
I'm assuming it's the MS Access 9.0 Object Library, but there are actually
more references involved. Machines where the database is working properly I
am able to view the available references. There are 5 references checked.

1. Visual Basic For Applications
2. MS Access 9.0 Object Library
3. OLE Automation
4. MS ActiveX Data Objects 2.1 Library
5. Acrobat Control for ActiveX

I am not very familiar with goes on behind these references. I thought that
perhaps the reason "references" was grayed out on some of our machines was
because no references were selected. I was hoping that if I can enable the
references option under the tools menu I can select these references and
check to see if this does the trick. Is there more to this problem that you
know of?
 
By any chance are the machines where it's grayed out using the Runtime
version of Access? You can't change references using the runtime.

References "live" in the MDB file. It should not be necessary to set them up
on each machine. What can cause a problem with the References collection is
one of the following:

1) A file that was referenced on the developer's machine doesn't exist on
the user's machine
2) A file that was referenced on the developer's machine is in a different
location on the user's machine, or is a different version.
 
How can I tell if it is a runtime version?

Douglas J Steele said:
By any chance are the machines where it's grayed out using the Runtime
version of Access? You can't change references using the runtime.

References "live" in the MDB file. It should not be necessary to set them up
on each machine. What can cause a problem with the References collection is
one of the following:

1) A file that was referenced on the developer's machine doesn't exist on
the user's machine
2) A file that was referenced on the developer's machine is in a different
location on the user's machine, or is a different version.
Click to expand...
 
Good question! I know that SysCmd(acSysCmdRuntime) will return True if it
is, but I don't think you can actually open the Immediate Window to run that
if it is the Runtime!

Can them make any design changes (as opposed to data changes)?
 
Yes, well...only users who have full control can make design changes. You
mean the design mode right?
 
Not sure what you mean by "users who have full control".

Unless you've applied Access Security, any user who has the full version of
Access (as opposed to the run-time) should be able to open a form or report
in Design mode. Users with the run-time will not be able to.
 
Back
Top