Another thing to consider...

If you install the Management Studio (formerly Enterprise Manager) on your desktop box, in most cases Enterprise Manager will no longer open.  I found documentation about why...

Thanks for the advice.  I used the export wizard and sucessfully moved the database last night. 

I have done several restores of a SQL 2000 database to SQL 2005 and have never had any trouble.

You might check to make sure you don't have the compatibility mode...

Oh, good grief.  That's exactly what the problem was.  I feel stupid for missing that one.

Thanks!

I'm not sure what the difference is, but I switched the line:

DoCmd.TransferSpreadsheet acExport, SpreadsheetTypeExcel9,  "dbo.tblTempExport", filename

to:

DoCmd.OutputTo acOutputTable, "dbo.tblTempExport", acFormatXLS, filename, False

and it works now. 

Don't know why, but it works...

Thanks Mark,

That makes sense to me also, but when I tried that before I got an error that said "The table name you entered doesn't follow Chaplaincy object-naming rules". 

I...