473,320 Members | 1,832 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Finding an Installable ISAM

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


Nov 13 '05 #1
2 7254
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 warranties.
"DBQueen" <ir******@bellsouth.net> wrote in message
news:E_*******************@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 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

Nov 13 '05 #2
That did it...thanks so much for your help!

Andi Plotsky

"David Lloyd" <Da***@NoSpamPlease.com> wrote in message
news:lp*****************@bignews4.bellsouth.net...
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 warranties.

"DBQueen" <ir******@bellsouth.net> wrote in message
news:E_*******************@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 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


Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Brent | last post by:
Hi, my asp.net c# app is trying to connect to an Access database with a password and am I getting the error.. Could not find installable ISAM. . If I connect to one without a password it works...
1
by: Steve | last post by:
I get a "Could Not Find Installable ISAM" error on my objConn.open() statement. I suspect my connection string is bad. What I am trying to do is write to an Excel file on my local computer from a...
1
by: Karl Irvin | last post by:
In the module below, I get a "Could not find installable ISAM" error on the tdf.refresh link. The NewConnection refers to a valid database/table. My References include VBA, Access 9.0 Object...
0
by: rivka.howley | last post by:
I'm using Access 2003 and Excel 2003. All I'm trying to do is bring a sheet from an Excel file (defined by the user) into Access as a table, I dont care if it's linked or imported. However, I get...
2
by: Horst Walter | last post by:
I am using C# / ADO.NET to create an Excel sheet: This connection string works: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";" + "Extended Properties=Excel 8.0;"; This...
1
by: Guly | last post by:
Hi, i' ve the follow problem: the code below generate an exception.... private void btnElabora_Click(object sender, System.EventArgs e) { File.Copy(FileName, @"C:\\Paesi\\Paesi.xls", true); ...
6
by: Robert Lawson | last post by:
I continue to get the below error message when trying to load a aspx file. Could someone please point me in the right direction for solving this? I'm trying to access an access data base and I'm...
2
by: Henrik | last post by:
Hello I starting use ASP.NET and has created a new file to open a Access database I get these error and cant solve it - please need some help. I Use Windows 2000 (have also tried to put it...
1
by: Anatoly Kurilin | last post by:
Hi, each time I use that code for calculating a number of user connected to a data file, I get an error message: Could not find installable ISAM. What do I do wrong? Dim cn As New...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.