[AccessD] TrasnferSpreadsheet failing

Jennifer,
Have you tried to shell out and kill the app?  Then you wouldn't have to
reboot.
I put the following in a sub on the form that runs excel, either to quit
the app or to reset the form.

        Shell "Taskkill /f /im Excel.exe", vbHide

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jennifer
Gross
Sent: Tuesday, March 17, 2009 5:30 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] TrasnferSpreadsheet failing

I often times cannot get the ghost of Excel to end, so it requires a
reboot.  One quirky thing I have found with exporting to Excel from
Access is that if I do it over and over again and close the Excel mother
ship each time then I will get an error and this ghost I cannot get rid
of.  If I only close the spreadsheets themselves, leaving Excel open,
then I all works fine.  Don't know what that's about, and probably not
related to your issue.

Jennifer

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hewson, Jim 
Sent: Tuesday, March 17, 2009 3:05 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] TrasnferSpreadsheet failing


In my experience, it means the spreadsheet is already open. When this
occurs I have found there is a ghost instance of Excel still open with
the Spreadsheet tied to the ghost. Close all instances of Excel, then
open task manager and see if an instance of Excel is still running. If
it is, end the process, close Access and start over. Sometimes, I have
had to shell out to kill app to prevent this from happening.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Tuesday, March 17, 2009 4:57 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] TrasnferSpreadsheet failing

Dear List:

 

I am trying to export data from a query to a spreadsheet.

I get the error 3027 Cannot update. Database or object is read only.

The line is: DoCmd.TransferSpreadsheet acExportDelim,
acSpreadsheetTypeExcel9, "qryExportMailingList", varFileName, True

varfilename has the full path, name and extension.  

 

Any ideas what I'm doing wrong?

 

MTIA

 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 

 
########################################################################
########
If you have received this message in error, please contact the sender
immediately and be aware that the use, copying, or dissemination of 
this information is prohibited. This email transmission contains 
information from NCI Information Systems, Inc. that may be considered 
privileged or confidential and is intended solely for the named 
recipient.
########################################################################
########

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.0.238 / Virus Database: 270.11.17/2007 - Release Date:
03/17/09 10:18:00


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
################################################################################
If you have received this message in error, please contact the sender
immediately and be aware that the use, copying, or dissemination of 
this information is prohibited. This email transmission contains 
information from NCI Information Systems, Inc. that may be considered 
privileged or confidential and is intended solely for the named 
recipient.
################################################################################