Topics Search

Access 2010 - runtime error 3170 Could not find installable ISAM

Access 2010 - runtime error 3170 Could not find installable ISAM
Views: 78
I am running Office 2010 under Windows XP SP3 and I am getting the above error while exporting data from Access to Excel via a VBA routine. It worked fine in Access 2000 but since upgradingto Access 2010, I have started to get the erro "Could not find installable ISAM".

I am using a statement that starts DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3

If I change it to acSpreadsheetTypeExcel5 (or later) then it works fine but 3 or 4 brings up the installable ISAm error.
Sponsored Links:

Similar posts...

 

Problem linking dbf files to Access 2010

Problem linking dbf files to Access 2010 Icon
I'm using Windows 7 Professional (32bit) and the Beta version of Access 2010.

I have some Access 97 databases that include linked tables to dbf files. When trying to open the linked table I get the error message "Could not find installable ISAM". When Itry to link a new dbf file I get the message "External table is not in the expected format", regardless of whether I choose dbase 3, 4 or 5 as the file type.

I have also converted the Access files to the 2007 format and the conversion errors table has the description of "Microsoft Access was unable to refresh the linked table 'ACCOUNT' in database 'C:\Program Files\VISION\HOME\FERRO 1 July 2004' during conversion.

Try to refresh the links manually by using the Linked Table Manager command in the Database Tools group on the Database Tools tab".

Refreshing the tables just brings up the installable ISAM error again. Trying to add or open in the converted file also has the same errors as above. The dbf files open fine in Excel.
 

Could Not Find Installable ISAM

Could Not Find Installable ISAM Icon
I have an Access 2003 Front End that I am going to email out to 50 people and I want them to be able to push a button that will set the connection to the linked tables on the Back End. Below is the code I have but everytime I execute it I get "Could Not Find Installable ISAM"

Dim tbl As TableDef 'Refresh the ODBC links to Access Backend tables.
On Error GoTo err_RefreshTableLinks
CurrentDb.QueryTimeout = 60
Screen.MousePointer = 10
For Each tbl In CurrentDb.TableDefs
'Ignore local tables.
If tbl.Connect <> "" Then
'Debug.Print tbl.Name, SearchText(tbl.Connect & ";", "Database=", ";")
tbl.Connect = "Provider=Microsoft.Jet.OLEDB.4.0; DataBase=\\addfile00\Groups\Billing\Accomplishments\DERM CUSTOMER SERVICE_be.mdb; UserID=Admin; Password=;"
tbl.RefreshLink
End If
Next
RefreshTableLinks = True
Screen.MousePointer = 0
MsgBox "Tables Refreshed Successfully"
err_RefreshTableLinks:
RefreshTableLinks = False
Screen.MousePointer = 0
MsgBox Err.Description
 

Runtime access 2010

Runtime access 2010 Icon
I need a beginners tutorial on the use of Runtime - I have access 2010 installed - I think I downloaded and installed access runtime for 2010 - for the life of me I cannot find any references to runtime in access or in windows list of programs.

I tried to publish the DB but all I got was a accde extension not the accdr.
 

2010 Runtime ADODB Connection Failure

2010 Runtime ADODB Connection Failure Icon
I have a routine which connects to MySQL database with ADODB connection. This worked in 2003 and 2007 runtime but throws a 430 error on 2010 runtime. It works in full access 2010. Has there been a change of policy to restrict this type of connection in the 2010 runtime?

If I use a linked ODBC table instead of ADODB the runtime fails with "Runtime Error". It still works in full access
 

Runtime 2010 ADODB Connection failure

Runtime 2010 ADODB Connection failure Icon
I have a routine which connects to MySQL database with ADODB connection. This worked in 2003 and 2007 runtime but throws a 430 error on 2010 runtime.

Error 430: Class does not support Automation or does not support expected interface
It works in full access 2010. Has there been a change of policy to restrict this type of connection in the 2010 runtime?

If I use a linked ODBC table instead of ADODB the runtime fails with "Runtime Error". It still works in full access.
 

Runtime Error 3075 - Access 2010

Runtime Error 3075 - Access 2010 Icon
We use an access database for our Human Resources department. Recently we updated to Access 2010 on a couple of workstations. In Access 2010 we keep getting Runtime Error 3075 missing operator. I click debug and this is where the error is happening.
[CODE]
While playing with the code I noticed if I take out the "AND" in the bold line above. The error is removed within Access 2010; however, it creates the same error in Access 2007, 2003. We still have a couple users that utilize Access 2007 and need it to function properly in both instances.

This is a program that I have inherited and my programming skills are minimal at best.

I have worked on this for several hours already, or 2007; however, not in both.
 

Open a report from MS-Access 2010 runtime version in vb.net windows application

Open a report from MS-Access 2010 runtime version in vb.net windows application Icon
In VB.Net, I am trying to open a report from MS-Access 2010 runtime version. But it is throwing error.

The error is

Retrieving the COM class factory for component with CLSID {73A4C9C1-D68D-11D0-98BF-00A0C90DC8D9} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT:0x80080005 (CO_E_SERVER_EXEC_FAILURE)

But in the full version of MS-Access it is working fine. How to fix this issue in the runtime version of MS-Access 2010 to view the report?
 

Installable

Installable Icon
What should be the installable or .exe format to go with MS-Access when given to the user
 

ActiveX component cannot create object 429 Error Windows 7

ActiveX component cannot create object 429 Error Windows 7 Icon
I am getting a runtime error of 429. Am using MS Access 2010, it works fine on MS Access 2007 and MS Access 2010 on windows xp.

When I use the Windows 7 64 bit MS Access 2010 I am getting the runtime message. Does anyone have any ideas why this happens
 

Access 2010 Ribbon - Runtime

Access 2010 Ribbon - Runtime Icon
We are in the process of upgrading from Access 97 to Access 2010

The database admins have a full copy of 2010 and the general users will have a copy of the Access 2010 runtime installed.

The issue is that when a database is opened in the runtime, the ribbon disappears, this is preventing people from exporting datasheet views to excel etc.