Access db not updating.

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default Access db not updating.

    My client moved to a new server now my asp code will not update his Access
    mdb. There are no error messages.


    Jsmithe Guest

  2. Similar Questions and Discussions

    1. MS Access Database not Updating
      Hi, I am working on creating dynamic home pages with Coldfusion MX on the server, Dreamweaver for developing and Microsoft Access as the backend...
    2. Updating MS Access Query
      Can you update a MS Access Query (its simply a join of two tables) using a form and <cfupdate>, or do you have to update the underlying tables. I...
    3. SQL not Updating Access Database
      Hi, I have an ASP page that updates an Access 2000 database. It doesnt seem to update the date field of the table. Here is the SQL: Update...
    4. Updating a remote web Access DB
      Here's one possible scenario: 1. Create an ASP page that allows the user to upload the datafile. 2. Create another ASP page that has a link...
    5. Updating Access DB in ASP
      I am trying to resolve the following error message when trying to update an Access 2000 database in ASP: Microsoft JET Database Engine...
  3. #2

    Default Re: Access db not updating.

    I think we'll need a little more information than that. There is an error
    somewhere, either a runtime error, a compile error, a server error, a setup
    error, a programmer error, or a user error.

    What does your relevant code snippet look like? Is it in a conditional
    statement? Are you using On Error Resume Next? What leads you to believe
    that the DB is not being updated? What leads you to believe that it should
    be?

    Ray at home

    "Jsmithe" <jr@jagat.com> wrote in message
    news:p0Keb.37028$nU6.6684837@twister.nyc.rr.com...
    > My client moved to a new server now my asp code will not update his Access
    > mdb. There are no error messages.
    >
    >

    Ray at Guest

  4. #3

    Default Re: Access db not updating.

    No on error resume next. Downloaded the db. It is not being updated. Asp
    can read the records. If I purposely create an error it shows up. Maybe it
    because we don't have write permission on the directory.
    >
    > "Jsmithe" <jr@jagat.com> wrote in message
    > news:p0Keb.37028$nU6.6684837@twister.nyc.rr.com...
    > > My client moved to a new server now my asp code will not update his
    Access
    > > mdb. There are no error messages.
    > >
    > >
    >
    >

    Jsmithe Guest

  5. #4

    Default Re: Access db not updating.

    If it were a permissions problem, you'd get an error.

    Let me ask you this. If you had an update statement like this, "update
    theTable set TheColumn='I''ve been updated.' where 1=2" and you execute
    that, would you say that the new server can't update the database? No. Or
    what about this:

    if 1 = 2 then YourADOObject.Execute "update theTable set TheColumn='value'

    Would you expect there to be an update there?

    What have you done to debug? Have you put any response.writes anywhere?
    WHAT IS YOUR CODE?

    Ray at home

    "Jsmithe" <jr@jagat.com> wrote in message
    news:M%Keb.37046$nU6.6714622@twister.nyc.rr.com...
    > No on error resume next. Downloaded the db. It is not being updated.
    Asp
    > can read the records. If I purposely create an error it shows up. Maybe
    it
    > because we don't have write permission on the directory.
    > >
    > > "Jsmithe" <jr@jagat.com> wrote in message
    > > news:p0Keb.37028$nU6.6684837@twister.nyc.rr.com...
    > > > My client moved to a new server now my asp code will not update his
    > Access
    > > > mdb. There are no error messages.
    > > >
    > > >
    > >
    > >
    >
    >

    Ray at Guest

  6. #5

    Default Re: Access db not updating.

    On Thu, 02 Oct 2003 00:08:53 GMT, "Jsmithe" <jr@jagat.com> wrote:
    >My client moved to a new server now my asp code will not update his Access
    >mdb. There are no error messages.
    >
    I just bought a thingiemabob "gajit" that goes "Boo" and when I press
    the button on the top it doesn't do anything. There are no error
    messages.

    How do I fix it?

    Please HELP me NOW!

    +DiamondEagle Guest

Posting Permissions

  • You may not post new threads
  • You may 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