Unable to Manipulate Records from datasheet view on users desktops

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zandiT
    New Member
    • Sep 2008
    • 48

    Unable to Manipulate Records from datasheet view on users desktops

    hello

    i have an access database which ive just put on a shared folder on the network for users to use. i tested it well, exported all the objects in a new database, converted to to an mde file, placed the mde version on the network and opened the database again just to make sure its working. but the problem is if a user opens the database, they cannot add delete or edit fields in certain tables.

    i have a particular from in datasheet view and i want the users to add records delete records or edit the existing record in the data sheet form. if i access the database from my computer it works, i can manipulate the form which ever way i want, but if any other user opens the form from their desktops, the tables in the datasheet view are readonly. what did i do wrong?
  • puppydogbuddy
    Recognized Expert Top Contributor
    • May 2007
    • 1923

    #2
    Most likely:
    1. Your users need read write permissions on the shared folder. If you don't have admin authority or don't know what to do (this is a Windows OS function), talk to the DB administrator.
    or
    2. You've loaded Access in exclusive mode instead of shared mode. Go to Tools>options>A dvanced Tab and set to shared mode.
    Last edited by puppydogbuddy; Oct 9 '08, 01:09 PM. Reason: typo

    Comment

    • zandiT
      New Member
      • Sep 2008
      • 48

      #3
      thankyou so much. its working now.
      thanks again

      Comment

      Working...