Alpha Video Training
Results 1 to 5 of 5

Thread: "Could not update the table..." when COMPACTING the database

  1. #1
    Member
    Real Name
    Don Walton
    Join Date
    Mar 2001
    Posts
    123

    Default "Could not update the table..." when COMPACTING the database

    I am getting this error when I try to COMPACT my database. I have tried everything i can think of: 1) delete the $$ files associated with the database using Windows Explorer 2)Copying the records in the table off to a NEW table and then bring them back using the OPERATIONS available 3)Adding a NEW record to the table and making sure the file closes 4)Close and RESTART the computer 5)Starting ALPHA 7 system and selecting and loading the database as opposed to loading the database directly from an ICON pointing directly to the database itself 6)Just a simple reloading of the database from Control Panel

    I did see Ohlen Cartmell's POST on 5/23 "Can't compact a file" and nothing I do seems to get rid of the problem. I dont want to delete the table as it is linked to many othe files!!! HELP!!!

    Don

  2. #2
    VAR
    Real Name
    Cheryl Lemire
    Join Date
    Jul 2003
    Location
    Pembroke Pines, FL
    Posts
    2,914

    Default

    Don,

    Did you try packing the table? Did not see that one mentioned.
    Cheryl
    #1 Designs By Pagecrazy
    http://pagecrazy.com/

  3. #3
    VAR
    Real Name
    John Lemisch
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    673

    Default

    create xbasic script with "a5_forceclosetables()" and run it

  4. #4
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default

    Don got it solved.

    See this thread:

    http://msgboard.alphasoftware.com/al...ad.php?t=61733

  5. #5
    Member
    Real Name
    Don Walton
    Join Date
    Mar 2001
    Posts
    123

    Default

    Cheryl

    I did not try packing first. If it happens again i shal try that first.

    Thanks

Similar Threads

  1. "Not an Open Index" with flattenquery update
    By Chris.Tanti in forum Alpha Five Version 7
    Replies: 12
    Last Post: 03-08-2006, 10:47 AM
  2. A5W "Contact us" page info populating a database table
    By KimberlyPatt in forum Web Application Server v7
    Replies: 5
    Last Post: 12-28-2005, 10:57 AM
  3. retreive database "form" w/linked field
    By Larry Bresnick in forum Alpha Five Version 5
    Replies: 2
    Last Post: 02-10-2005, 05:25 PM
  4. "The Table Lookup sample database...."
    By Bo Vandenberg in forum Alpha Five Version 5
    Replies: 3
    Last Post: 11-14-2003, 11:31 PM
  5. Database Compact - "Could not update"
    By drgarytraub in forum Alpha Five Version 5
    Replies: 4
    Last Post: 08-06-2003, 05:29 AM

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
  •