On Oct 7, 4:47*pm, Chuck <libb...@schoollink.netwrote:
I've been having problems with Access and Excel talking to one another.
In the process of trying to add features (programs) to Access 97 I have lost
the ability to export an Access query to an external file in Excel 97 format.
It was there yesterday, but it's gone today. *Other formats are also gone. *I
have found the Value Pack on the original Office 97 Pro CD. *It looks like I
can install drivers directly from the value pack. *There is an awful lot in the
Value Pack. *I would appreciate any suggestions on what I should install and
where I should install it. *MSAccess.exe is currently installed in
C:\Windows\Program Files\Microsoft Office\ * There are many sub-directories
under Microsoft Office.
Chuck
I remember having a similar problem some years ago - one day I
couldn't import Excel files. A cry for help here got me this info:
I recommend re-registering the following two files. Note that the path
to
each file may be different on your PC. To do this, click on Start >
Run. Then
copy each of the statements shown below, one-at-a-time, and click on
OK:
Regsvr32.exe "C:\program files\common files\microsoft shared\dao
\dao360.dll"
Regsvr32.exe "C:\program files\common files\system\ado\Msado15.dll"
Optional, but won't hurt is to make sure that dao350.dll is also
properly
registered:
Regsvr32.exe "C:\program files\common files\microsoft shared\dao
\dao350.dll"
If a library is marked MISSING, click the Browse button, and locate
the correct file for the library. The table below lists the files for
the crucial libraries of your version of Access.
If the library is not even shown, you may need to re-register it.
Click the Windows Start button, and choose Run. Enter regsvr32
followed by the full path of the library file. Include quotes if the
file name contains spaces, e.g.:
regsvr32 "c:\program files\common files\microsoft shared\dao
\dao360.dll"
Occasionally, the problem is not solved until you unregister the
library and re-register it. Uncheck the missing library in Access.
Close Access. Issue this command, and then the one above to re-
register it:
regsvr32 -u "c:\program files\common files\microsoft shared\dao
\dao360.dll"
Re-register it (as above). Open Access, and select the library
reference again.
********THE FOLLOWING IS WHAT WORKED FOR ME********
"Sounds like your DAO library got un-registered somehow. (Office 97
installation doesn't register it properly in the first place, so
re-installing is no help.)
Go to Start menu|Run, type the following, and click OK:
regsvr32 "C:\Program Files\Common Files\Microsoft
Shared\DAO\dao350.dll"
You can also check to make sure your references are ok (open any code
module, go to Tools menu|References, and make sure nothing is marked
"MISSING").
If I remember rightly this came from a wonderful lady named Martha and
it saved my sanity!
HTH
Jeff B