[AccessD] TrasnferSpreadsheet failing

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Tue Mar 17 17:25:55 CDT 2009


Jim:

Checked. No instances of Excel were open. 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----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




More information about the AccessD mailing list