
How to get Access 97 (built on a Windows 2000) to work on 95s and 98s
To do its job, Access (like most modern programs) makes use of various
external program and object libraries that provide functionality that may be
shared among applications. For example, Access always uses the
Visual Basic for Applications library, the version-appropriate Access Object Library, and
the OLE Automation library. References to the specific library files,
including their locations, are stored with your database. But these library
modules may not be in the same location on different machines, especially if
they have different versions of Microsoft Office or different OPERATING
SYSTEMS.
If you move a database from one machine to another, these references may be
"broken"; that is, one or more of the library files may not be where the
stored reference says it is.
When this happens, you need to take steps to let Access repair the broken
reference(s) ON THE COMPUTER WHERE THE FAILURE IS OCCURING.
Here are Doug Steele's instructions for how to do it:
****Quote****
Open any code module (or open the Immediate Window, using Ctrl-G, provided
you haven't selected the "keep debug window on top" option). Select Tools |
References from the menu bar. Examine all of the selected references.
If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.
If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in).
Just so you know: the problem will occur even if the library that contains
the specific function that's failing doesn't have a problem.
****Unquote****
So, follow those instructions and see if your problem goes away.
Quote:
> No one chanced to respond to this. I desperately need help. Do I need to be
> more specific here? Here it is again:
> ________
> I created an Access 97 database using Windows 95. I used to give my many
> users, how have Windows 95 and 98 and 2000 updates to my front end and they
> worked just fine.
> But I recently upgraded my computer to Windows 2000. Now, still using Access
> 97, the people with Windows 95 and 98 get all sorts of errors running any
> update done on my Windows 2000.
> I'm not very technical with this stuff but I have a good tech. So please,
> explain in as much detail as you can afford what I should do to get my updates
> to work on these machines. The errors begin with the Access's Startup menu.
> Is there some settings I need to adjust on 95 and 98 computers? Is there a
> list of things to do?
> By the way, is there a way to open Access without the startup window coming up?
> Thanks,
> Matt