Run Time Error 3011

[Guest]

I have an Access form that allows a user to select a table or query, then
click a button that executes the following code that exports the selected
object to an Excel spreadsheet:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, Me.cboTables,
Get_Path & Me.cboTables, True

On 99.9999% of the computers this task is performed on, it works fine. On
one users systems, it displays the error "Run time error 3011; Microsoft Jet
database engine could not find object". If I try to export the table
manually by right-clicking the table and selecting "export", it displays the
error message "too many fields defined". There's only five fields in the
table.

Any suggestions?

Thanks!

 

[Allen Browne]

The 2nd symptom sounds ominous. Suggestion:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database:
Tools | Database Utilities | Compact

Do you still have the 2nd problem?