Overwriting db file

Discussion in 'Programming' started by elsinore, Mar 25, 2008.

0
  1. #1
    Hi,

    I am a newcomer to this forum as well as to coldfusion.

    I have uploaded a small database, however after adding additional information, I tried uploading and overwriting the original file, but it never takes the added information. It prompts me to overwrite, which I select, but the new info is not added.

    Some thoughts from you would be great ... since I am a novice at this
     
    elsinore, Mar 25, 2008 IP
  2. 3plains

    3plains Well-Known Member

    Messages:
    45
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    108
    #2
    What type of Database are you using?
     
    3plains, Mar 25, 2008 IP
  3. elsinore

    elsinore Peon

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I am using Microsoft Access
     
    elsinore, Mar 25, 2008 IP
  4. unitedlocalbands

    unitedlocalbands Well-Known Member

    Messages:
    246
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    128
    #4
    Look in the folder on your server where the database is stored and check to see if there is an access lock file. Access database, when opened, will create an access lock file to protect the database form being overwriten, or deleted when a user has it open. Sometimes this file will remain and keep anything from altering the database.
     
    unitedlocalbands, Mar 25, 2008 IP
  5. 3plains

    3plains Well-Known Member

    Messages:
    45
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    108
    #5
    Elsinore,

    I don't use Access anymore, but I used to have the same problem when I first hosted at readyhosting.com. Here is your solution:

    http://www.evolt.org/node/3644
     
    3plains, Mar 25, 2008 IP
  6. elsinore

    elsinore Peon

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Thanks Guys,

    I will try it.
     
    elsinore, Mar 26, 2008 IP
  7. elsinore

    elsinore Peon

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Well I tried, but with no positive result.

    I placed the snippet in a file called die.cfm, uploaded, typed the siteurl/die.cfm, it threw an error as expected, tried uploading the db file again, but the replacement file suggest that it is the same size as the former, which tells me it does not see or would not allow the additional info.

    I am back to square one... so was it me? Did I misinterpret the directions?
     
    elsinore, Mar 26, 2008 IP