RECORDSET NOT UPDATABLE

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • cronept@msn.com
    #1

    RECORDSET NOT UPDATABLE

    Hi,

    I made a database and split it to one back end and one front end. I am
    using Access 2000. I put the front end db on my co workers' computers
    and the back end on the server. The problem is some of them are not
    working because of "recordset is not updatable". Looks like VB is not
    working. I don't understand on most of my co workers' computers, the
    same database is working fine. On 2 machines, the DB has the same
    problem. The Access they are using are all Access 2000, on Win 2000. I
    am tinking some of them have Access 2000 SR-1, some not. Is this the
    problem? THanks

    Jim
    Tags: None
    • prodirect
      #2
      Re: RECORDSET NOT UPDATABLE

      I'm not 100% certain, but I have gotten that recordset not updateable
      message also. I seem to get that message in 2 different circumstances. 1)
      when I'm referencing data that is using a crosstab query as it's source and
      2) when I open a form that references more than 2 tables (i.e. a query that
      pulls data from 3 or more tables). Could it be that your users were looking
      at different forms (hence why some can update and some can't?) Just a
      suggestion.


      <cronept@msn.co m> wrote in message
      news:23d556b6.0 402090901.373bd ebc@posting.goo gle.com...[color=blue]
      > Hi,
      >
      > I made a database and split it to one back end and one front end. I am
      > using Access 2000. I put the front end db on my co workers' computers
      > and the back end on the server. The problem is some of them are not
      > working because of "recordset is not updatable". Looks like VB is not
      > working. I don't understand on most of my co workers' computers, the
      > same database is working fine. On 2 machines, the DB has the same
      > problem. The Access they are using are all Access 2000, on Win 2000. I
      > am tinking some of them have Access 2000 SR-1, some not. Is this the
      > problem? THanks
      >
      > Jim[/color]


        Comment

        • cronept@msn.com
          #3
          Re: RECORDSET NOT UPDATABLE

          Yes, I am using the form references a query which pulls 2 tables
          together. I tested all dbs on different users, some can, some can't.
          One of the users reinstalled Access 2000 SR-1, still not working. It
          is weired.

          My 2 tables did not have primary key. I just changed that. Still not
          working.



          "prodirect" <prodirect@comc ast.net> wrote in message news:<c58288d45 135813dd68bb12a f6ab67b8@news.t eranews.com>...[color=blue]
          > I'm not 100% certain, but I have gotten that recordset not updateable
          > message also. I seem to get that message in 2 different circumstances. 1)
          > when I'm referencing data that is using a crosstab query as it's source and
          > 2) when I open a form that references more than 2 tables (i.e. a query that
          > pulls data from 3 or more tables). Could it be that your users were looking
          > at different forms (hence why some can update and some can't?) Just a
          > suggestion.
          >
          >[/color]

            Comment

            • fp
              #4
              Re: RECORDSET NOT UPDATABLE

              Just off the top of my head, make sure the non-working users have write
              access to the server location that the database resides.

              --
              *************** ***************
              Fred Parker
              Lynn Consulting Group, L.L.C.
              http://www.lynnconsultinggroup.com

              *************** ***************

              <cronept@msn.co m> wrote in message
              news:23d556b6.0 402090901.373bd ebc@posting.goo gle.com...[color=blue]
              > Hi,
              >
              > I made a database and split it to one back end and one front end. I am
              > using Access 2000. I put the front end db on my co workers' computers
              > and the back end on the server. The problem is some of them are not
              > working because of "recordset is not updatable". Looks like VB is not
              > working. I don't understand on most of my co workers' computers, the
              > same database is working fine. On 2 machines, the DB has the same
              > problem. The Access they are using are all Access 2000, on Win 2000. I
              > am tinking some of them have Access 2000 SR-1, some not. Is this the
              > problem? THanks
              >
              > Jim[/color]


                Comment

                • cronept@msn.com
                  #5
                  Re: RECORDSET NOT UPDATABLE

                  I am sure everybody get the correct path to the back end database. (I
                  splitted the DB to 2 DBs). The only difference I can see is that the
                  persons who get Access 2000 installed recently, on their computers,
                  the DB is working fine. The 2 persons have Access 2000 before, it is
                  not working. I checked the version, they are all Access 2000 SP-3, I
                  really don;t know what happened. One guy even tried uninstall Access
                  2000 and reinstalled using the CD I have, still not working.


                  "fp" <etickettwothou sand@hotmail.co m> wrote in message news:<7%kWb.107 91$%X3.7646@nwr ddc01.gnilink.n et>...[color=blue]
                  > Just off the top of my head, make sure the non-working users have write
                  > access to the server location that the database resides.
                  >
                  > --
                  > *************** ***************
                  > Fred Parker
                  > Lynn Consulting Group, L.L.C.
                  > http://www.lynnconsultinggroup.com[/color]

                    Comment

                    Previous template Next
                    Working...