-
Apr 29th, 2005, 12:58 PM
#1
Thread Starter
Addicted Member
"Could not find Installable ISAM"
Im trying to import Data from an Access DB to an Excel Spreadsheet, the Code gives me the error
Run-time error '-2147467259(80004005)'
Could not find Installable ISAM
on the line cn.Open...
VB Code:
Dim cn As ADODB.Connection, rs As ADODB.Recordset, intColIndex As Integer
' open the database
Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
tstDBFullName & ";" & "UID=myuname ;PWD=xyzu "
Set rs = New ADODB.Recordset
-
Apr 29th, 2005, 01:12 PM
#2
Re: "Could not find Installable ISAM"
Your Access connectionstring should be without the spaces and pwd should be Password.
VB Code:
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & tstDBFullName & ";User Id=admin;Password=;"
Whats the value for tstDBFullName?
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
Microsoft MVP 2006-2011
Office Development FAQ (C#, VB.NET, VB 6, VBA)
Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
If a post has helped you then Please Rate it!
• Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
-
Apr 29th, 2005, 01:37 PM
#3
Addicted Member
Re: "Could not find Installable ISAM"
if you fail to plan, you plan to fail
-
Apr 29th, 2005, 02:17 PM
#4
Thread Starter
Addicted Member
Re: "Could not find Installable ISAM"
Originally Posted by Br1an_g
I had already gone through those steps on the page but thanks anyways.
The spaces and password did get me out of the ISAM error but now can anyone tell me how to incorporate a workgroupd file here for this authentication coz it says tht the workgroups information file is missing or opened exclusively by another user.
-
Apr 29th, 2005, 02:22 PM
#5
Thread Starter
Addicted Member
Re: "Could not find Installable ISAM"
nevermind the workgroup problem.....I fixed it by adding
Jet OLEDB:System database=C:\SYSTEM.MDW;" at the end
so its now
VB Code:
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBFullName & ";User Id=manektalau1;Password=;Jet OLEDB:System database=C:\SYSTEM.MDW;"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|