Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Join Date
    Apr 2010
    Posts
    9

    Unanswered: Error Number "3027" Cannot Update - Database or Object is readonly

    Recently, we have migratrd our Ms-Access 2000 version to 2007 and getting the follwoing error message while performing the below action.

    Can anyone help me please.

    DoCmd.TransferText acExportFixed, "test123", "Employee", "C:\temp\123.doc"

    Same action was working before migrating but now it is not working and throwing error message as "Err Num 3027.Database or Object is readonly".

    I have also included the DOC in the Extensions section in the registry.Still no luck.Please help me.

  2. #2
    Join Date
    Mar 2007
    Posts
    277
    Is everything in a trusted location? BTAB Development - A2K7 - How to enable code and macros
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  3. #3
    Join Date
    Apr 2010
    Posts
    9
    I added the location under the Trusted resources but not working as expected.

    Any other ides please....?????

  4. #4
    Join Date
    Mar 2007
    Posts
    277
    What OS are you using? Do you have a permissions problems with the OS?
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  5. #5
    Join Date
    Apr 2010
    Posts
    9
    Am using XP SP2...
    And am the admin...
    So definatrely i will have access to all the files n folders....

  6. #6
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Can you successfully open and manipulate the export spécification (test123) with Access 2007?
    Have a nice day!

  7. #7
    Join Date
    Apr 2010
    Posts
    9
    Yes.Am able to open and edit the Spec(Test123)....
    Using same spec with same structure am able to execute the line of code without any isues in Access 2003 .
    i am gonna get mad caz of this issue in Ms-Access 2007.

  8. #8
    Join Date
    Mar 2007
    Posts
    277
    I noticed you are still on SP2 of the OS. Have you applied all of the Office 2007 updates including the HotFixes?
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  9. #9
    Join Date
    Apr 2010
    Posts
    9
    certainly not...
    i am not aware of those patches an their significance....
    Can u help me little more....???

  10. #10
    Join Date
    Mar 2007
    Posts
    277
    When you say migrated, did you import the 2K db, convert it, or are you just running it with ac2007?
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  11. #11
    Join Date
    Mar 2007
    Posts
    277
    Office Update will get you most of the way there. Have you done that?
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  12. #12
    Join Date
    Apr 2010
    Posts
    9
    no, am just running it with 2007.
    Am done with all the office updates whatever i received..
    (Update names starts with KA....)

  13. #13
    Join Date
    Mar 2007
    Posts
    277
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  14. #14
    Join Date
    Apr 2010
    Posts
    9
    Just now installed the hot fixes and tried to execute the same code ...
    But no positive output yet.

    Any other ideas left out sir .....?????

  15. #15
    Join Date
    Mar 2007
    Posts
    277
    Well, at least you are up to date. Does the destination "C:\temp\123.doc" exist? delete it if so. also try "C:\temp\123.txt" as a test.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

Posting Permissions

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