Page 1 of 2 12 LastLast
Results 1 to 15 of 29
  1. #1
    Karen H is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    21

    Question form is suddenly read-only

    In trying to work out another problem I have discovered that one of my forms is suddenly read-only.



    I have checked the design view and allow changes, edits, deletions are all marked yes.
    Last edited by Karen H; 02-10-2011 at 02:00 PM. Reason: attached to wrong post

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Why do you feel the form is read-only? Can you modify the RecordSource directly?

  3. #3
    Karen H is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    21
    I am not sure what "record source" means but I can modify the records under table view, cannot make any changes on the form. Any attempt to modify or enter data on a form results in a bell, no messages just a bell.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    On the property sheet for the form under the Data tab is a RecordSource property. If you press the "..." button on that property, can you then modify the RecordSource?

  5. #5
    Karen H is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    21
    Nope, that will not work either

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If it is a query then this link might help: http://allenbrowne.com/ser-61.html

  7. #7
    Karen H is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    21

    form is suddenly read-only

    I had originally created the table with 58 fields. I decided that I should separate some of the fields that would be rarely used so that I could access the basic data more quickly.

    Now, everytime I add the third table to the query it becomes read only.

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you looked at the link I posted in post #6?

  9. #9
    Karen H is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    21
    Yes, I did check out the link you sent, the only thing that it could be is the join could be wrong. This response was after I checked that out.

    I had originally created the table with 58 fields. I decided that I should separate some of the fields that would be rarely used so that I could access the basic data more quickly.

    Now, everytime I add the third table to the query it becomes read only.

  10. #10
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Access make the query read-only when the record is ambiguous. Take a closer look at how you joined the tables. Is there a PrimaryKey (PK) in one table and the same value in a field in another table as a ForeignKey (FK)?

  11. #11
    Karen H is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    21
    Yes, there is.

    When I split the data up, I copied the whole table again and deleted all the fields I did not need in each new table. I changed the PK to be an FK.

    Each of the FKs has the same id numbers that were in the original table.

    Also, on a related note, one of the tables won't hold the relationship. it will take it, I save the relationship window and exit and come back in and the relationship is gone.

  12. #12
    Karen H is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    21
    I fixed the relationship issue, when I said show all, there were 8 different sets of relationships for that table, after deleting all but one everything having to do with the relationships is ok, but everything is still read only.

  13. #13
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Let's try and eliminate corruption as an issue. *Import* your db into a new fresh db and see if the relationship issue follows: http://www.btabdevelopment.com/ts/impnew

  14. #14
    Karen H is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    21
    I followed the link you sent and imported the way they said to, I have just been copying and giving a new name. But, alas, still no change.

  15. #15
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Hi Karen,
    Is it possible to do a Compact and Repair and then zip up your db and attach it to a post here? Remove any sensitive data of course.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. the property is read only and cannot be set
    By darksniperx in forum Access
    Replies: 16
    Last Post: 11-02-2012, 02:48 PM
  2. Some Can Read; Some Can Write
    By cassidym in forum Security
    Replies: 3
    Last Post: 08-19-2010, 02:19 PM
  3. Editing forms suddenly gone wrong
    By twinfair in forum Forms
    Replies: 3
    Last Post: 02-19-2010, 07:48 AM
  4. Read only Access Database
    By Rameez in forum Access
    Replies: 7
    Last Post: 06-23-2009, 12:30 AM
  5. Replies: 2
    Last Post: 10-19-2006, 04:37 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums