Missing references / Network error

J

janet

Hoping someone might be able to help with this. Was working in Access on a
module I couldn't get to work. While I was doing that, I got an error that
said the network connection was not available (program is on a shared drive)
and I could not save the changes I'd made. Now am missing all the basic
access functions, so none of my queries work. I did some searching and found
that it appears the references are not working, but all the solutions that I
found do not seem to fix the problem. Can anyone offer any suggestions?
Thank you!
 
6

'69 Camaro

Hi, Janet.

Is this the error you received? "Error accessing file. Network connection
may have been lost." Are you running Access 2K with some application from
Office XP also loaded on the same computer? You wrote that you couldn't get
a module to work, so it's likely that you weren't able to compile the
application before closing it. Did you also import or copy a form, report
or module from another database before this happened?

If so, there's bad news. Please see this Knowledge Base article concerning
this nasty bug:

http://support.microsoft.com/default.aspx?scid=304548

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
 
J

janet

Gunny,

This sounds a lot like what happened. Yes, I was trying to import from
another database. And it does give me the error that you mentioned when I
try to view the modules now. The first thing I noticed wasn't that,
though... the error said that it could not find a function "format", which
should be available, right? So do you think this might be 2 separate
problems?

Thanks for your help! Janet
 
6

'69 Camaro

Hi, Janet.

Access's inability to find a VBA function is symptomatic of the inability to
compile due to the incompatible VBA libraries in the two different versions.

Do you have Service Pack 3 installed for Office 2K? That will prevent the
problem I described if your computer has the incompatible version of the
VBE6.DLL file. The default directory for this file is: C:\Program
Files\Common Files\Microsoft Shared\VBA\VBA6. Find this file and open up
the Properties dialog window and select the "Version" tab. You'll see the
version number of this file listed. If you see 6.3.91.8 or 6.03.9180 for
the file version, then you've been bitten by this nasty bug.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
 
Top