Professional Web Applications Themes

Can't compact/repair Coldfusion db - Coldfusion - Getting Started

Hi, all. We've run into an issue when trying to compact/repair an Access db used by a ColdFusion MX application. It creates the compacted file (i.e., "db1.mdb"), but then can't replace the original. It says the original is read-only, even when the database is opened exclusively. We discovered it has to do with the LDB file. The solution we've found is to shut down the ColdFusion MX ODBC Server service, compact/repair, and then turn the service back on. Obviously, when that service is down, ColdFusion apps will not work correctly. Our question is this: Is there another solution to this? ...

  1. #1

    Default Can't compact/repair Coldfusion db

    Hi, all. We've run into an issue when trying to compact/repair an Access db
    used by a ColdFusion MX application. It creates the compacted file (i.e.,
    "db1.mdb"), but then can't replace the original. It says the original is
    read-only, even when the database is opened exclusively. We discovered it
    has to do with the LDB file.

    The solution we've found is to shut down the ColdFusion MX ODBC Server
    service, compact/repair, and then turn the service back on. Obviously, when
    that service is down, ColdFusion apps will not work correctly.

    Our question is this: Is there another solution to this? Has Macromedia
    released a patch/update to resolve this issue in a less manual fasion
    (shutting down the service)? We have to compact the database at least once a
    week, so suggestions will be deeply appreciated. Thanks.


    dw Guest

  2. #2

    Default Re: Can't compact/repair Coldfusion db

    This is not a Coldfusion issue, but rather an Access issue.

    When you attempt to edit or alter an Access db, it creates a separate .lck
    file that is read only, and you cannot remove or delete the original .mdb file.
    So , really , I dont know of a solution for it.

    And besides, you really should not be using an Access db , unless it is real
    small and is used very rarely. Access is not for production sites. You should
    use a SQL based db.

    Abinidi Guest

  3. #3

    Default Re: Can't compact/repair Coldfusion db

    Thanks, Abinidi. That was my feeling, too. If we had the time, we'd switch
    all the users to SQL Server or Oracle. Personally, I can't stand Access for
    these very issues :)

    "Abinidi" <webforumsusermacromedia.com> wrote in message
    news:d9gv7k$cnc$1forums.macromedia.com...
    > This is not a Coldfusion issue, but rather an Access issue.
    >
    > When you attempt to edit or alter an Access db, it creates a separate .lck
    > file that is read only, and you cannot remove or delete the original .mdb
    > file.
    > So , really , I dont know of a solution for it.
    >
    > And besides, you really should not be using an Access db , unless it is
    > real
    > small and is used very rarely. Access is not for production sites. You
    > should
    > use a SQL based db.
    >

    dw Guest

Similar Threads

  1. Compact code
    By anonymous in forum ASP.NET Data Grid Control
    Replies: 3
    Last Post: March 21st, 08:11 PM
  2. Compact and repair database
    By Kurt H Hanssen in forum ASP Database
    Replies: 2
    Last Post: February 12th, 08:05 PM
  3. Code for compact and repair on close
    By carlee in forum Microsoft Access
    Replies: 1
    Last Post: July 28th, 08:45 PM
  4. Compact & Repair Error
    By Elwin in forum Microsoft Access
    Replies: 2
    Last Post: July 21st, 03:29 PM
  5. Compact Privacy Policy?
    By charles in forum ASP.NET General
    Replies: 1
    Last Post: July 1st, 03:34 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139