[AccessD] TrasnferSpreadsheet failing

Jim,
I think the problem has now been identified, but this is an interesting
one-liner for my tucker-box.
Thanks
Max


On 3/18/09, Hewson, Jim <JHewson at nciinc.com> wrote:
>
> 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.
>
> ################################################################################
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>