I received a "Could Not Find Installable ISAM" error (#3170) when using
Docmd.TransferDatabase to export a table from one database to another -
Set wrkDefault = DBEngine.Workspaces(0)
DBEngine.CreateDatabase strFileName, "c:\Database\"
DoCmd.TransferDatabase acExport, "Microsoft Access", _
"C:\database" & strFileName, acTable, "tblBatchTEMP", _
"tblBatchARCHIVE"
I suspect this is due to having just upgraded my version of Access2000 with
Update Rollup1 for Windows2000 SP4.
According to the Microsoft Knowledgebase
(http://support.microsoft.com/default...;en-us;209805), I probably
have a dll file containing the Import/Export ISAM for Microsoft Jet. It
lists -
Msrd2x40.dll for the ISAM for import/exporting for Microsoft Jet 2.0
Msrd3x40.dll for the ISAM for import/exporting for Microsoft Jet 3.0
I assumed there should be a file called Msrd4x40.dll for the ISAM for
import/exporting for Microsoft Jet 4.0.....but I don't have one. Am I
assuming correctly that this is the problem?
And, if so.......
Does anyone know where I can download this from? Is that probably all I
need to do (and the requisite REGISTRY KEY adjustments as described in the
KnowledgeBase solution for this error).
Thanks.
Andi Plotsky