Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Users not allowed to edit records on a form (Access 97)

    I have 3 users in a non-secure db that can't edit records in a form. The users try to change data on the form and it says recordset not updateable. The users can edit the underlying query. The users just received new pc's with access 97 and access 2000 installed on them. Their old pc's had 97 only and they were able to update this form. I recieved the same type of new pc with only access 97 installed and I can edit the form with no problem. All users with only 97 can edit the form as well. Is anyone familiar with this? Thanks..

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Users not allowed to edit records on a form (Access 97)

    The users with A2000 will only have read-only access to the DB unless it was converted to A2K in which case the A97 users could not read it at all.

    Without a FE/BE set up you can't solve this one. You would need A97 at the BE tables and A97 or A2K at the FE forms, reports etc. The performance for A2K users would probably be a dog as well.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Users not allowed to edit records on a form (Access 97)

    That isn't exactly true. They have read-only access to the *objects* in the 97 database, but they can, in fact, edit data because 2000 can handle 97 tables. However, the query engine changed somewhat between Access 97 and Access 2000 and some queries that were updateable in 97 are not updateable in 2000 without tweaking. Often it can be just a case of adding the DISTINCTROW keyword to the SQL of the query, but not always. One big difference is that the 2000 query engine usually wants all the key fields on tables in the query to make it updateable. Some queries have to be totally rewritten to work in 2000.
    Charlotte

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Users not allowed to edit records on a form (Access 97)

    Are you saying that the users can edit the data directly in the query but not from a form based on the query?
    Charlotte

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Users not allowed to edit records on a form (Access 97)

    That's right Charlotte.. Sorry to take so long to answer this.

Posting Permissions

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