Results 1 to 3 of 3

Thread: TransferSpreadsheet Error - NOT!

Threaded View

  1. Oct 6th, 2003, 05:41 AM #1
    Mindcrime
    Mindcrime is offline

    Thread Starter
    Fanatic Member Mindcrime's Avatar
    Join Date
    Jun 2001
    Location
    Peterborough, UK
    Posts
    555

    Angry TransferSpreadsheet Error - NOT!

    I am having a problem with Access. If I make the filename more than 5 characters I get the error message...
    'Cannot Update. Database or Object is Read Only'

    ... 5 character filenames are a bit limiting these days!!!

    HELP!

    Code:
        DriveLetter = Left(Me.Application.CurrentProject.Path, 3)
    ChDrive DriveLetter
    ChDir DriveLetter & "Content Co-ordination\Price List Database\MailMerge"

    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, "qryMail", "XXXXX.xls"
    Last edited by Mindcrime; Oct 6th, 2003 at 05:44 AM.
    Mindcrime : )
    ICQ 24003332

    VB 5.0, VB 6.0 SP5, COM, DCOM, VB.NET Beta 2, Oracle 8
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width