Results 1 to 3 of 3

Thread: Access and MSDE

  1. #1
    Join Date
    Dec 2003
    Location
    Tasmania
    Posts
    58

    Unanswered: Access and MSDE

    Urgent - my project manager is looking dangerous !!

    I have MSDE 2000A on pc & an Access app.
    In VBA I can change data in the MSDE tables, but when any Access objects try to update data I get informed that it is a read only recordset.
    What permissions need to be set to handle this ??
    catkins

  2. #2
    Join Date
    Apr 2004
    Location
    penang island, malaysia
    Posts
    3
    have you specified the lock mode? try the lockbatchedoptimistic. should work though.

  3. #3
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    another possibility to look into:

    are your objcts queries or forms based on queries? If so, check the queries. certain types of relationships (particularly the ones with arrows) create queries that cannot be updated.

    generally speaking, access also has a"complexity limit" - if you pass that limit, it will become an un-updatable query.

    good luck

Posting Permissions

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