That did it...thanks so much for your help!
Andi Plotsky
"David Lloyd" <David@NoSpamPlease.com> wrote in message
news:lpjPe.6349$Ma3.5070@bignews4.bellsouth.net...[color=blue]
> The second parameter to the CreateDatabase method takes a locale parameter
> which refers to the collating order for the database. If you correct this
> parameter, you will not receive the 3170 error. Below is an example that
> works without error in Access 2003:
>
> Dim strFileName As String
> Dim wrkDefault As Workspace
>
> strFileName = "H:\Documents and Settings\david\My Documents\db4.mdb"
> Set wrkDefault = DBEngine.Workspaces(0)
> DBEngine.CreateDatabase strFileName, dbLangGeneral
> DoCmd.TransferDatabase acExport, "Microsoft Access", _
> "H:\Documents and Settings\david\My Documents\db4.mdb", acTable,
> "Test1", _
> "Test1ARCHIVE"
>
> --
> David Lloyd
> MCSD .NET
>
http://LemingtonConsulting.com
>
> This response is supplied "as is" without any representations or[/color]
warranties.[color=blue]
>
>
> "DBQueen" <irisinfo@bellsouth.net> wrote in message
> news:E_5Pe.34570$XM3.33076@bignews5.bellsouth.net. ..
> 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[/color]
with[color=blue]
> Update Rollup1 for Windows2000 SP4.
>
> According to the Microsoft Knowledgebase
> (
http://support.microsoft.com/default...;en-us;209805), I[/color]
probably[color=blue]
> 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
>
>
>
>
>[/color]
