Page 1 of 2 12 LastLast
Results 1 to 15 of 26

Thread: Quirks? (2003)

  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Quirks? (2003)

    This is just a general question regarding something I have noticed in Access. Does it have a propensity to switch to read-only for no apparant reason? The other day, I did a Compact & Repair on our Database, and suddenly 2 Forms became read-only, ie, you could no longer add or edit records. I restored a 'Previous Version' from Shadow Copy, and it worked again. No change was made to the Database, ie, the SQL Statement was exactly the same before and after the Compact & Repair, yet every time Access opened these Forms, no edits or additions could be made.

    Similarly, a user using a different database (believe it or not, both the Front End and Back-end are stored in the same location on a Network Drive) opened an Access Database on her computer and worked away. She walked over to her new colleague's PC to show her how to use it, and she got an Error Message from Access requesting a Parameter Value (a Subform based on a Query that obviously selects a Record where the parent ID equals the Child ID, yet Access wanted the Parent ID????? The User walked back to her PC and opened the same database from the exact same mapped location, and it worked OK? Both users have Access 2003.

    I'm just wondering if these are quirks with Access that you just have to put up with, or can anyone think of any reason why these inexplicable things happen? The 2nd one really has me stumped?! Do these kinds of quirks happen to other people out there, or am I alone on this?

    Thanks in advance for all feedback & help supplied. [img]/forums/images/smilies/smile.gif[/img]

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Quirks? (2003)

    Although Access does have its quirks, I haven't seen either of the problems you mention.

    About the first one: did you check the Allow Edits, Allow Additions and Recordsource Type properties of the forms that had become read-on;y before you restored the older version?

  3. #3
    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: Quirks? (2003)

    Do both PCs have the same Service Packs installed?
    A2003 without SP1 was a dog IMHO - it threw several weird errors on a db of mine which worked fine in A2000 (particularly errored with sub-forms) (and it crashed regularly). SP1 basically fixed it.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  4. #4
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Quirks? (2003)

    Hi Hans . . . yes, I did check those things. It happened on 2 seperate Forms, and I checked both. I've seen something similar a couple of times with Queries, ie, sometimes they open Read Only, and other times, they will allow you to make edits to the data in the Query?

    Steve, we did all have MSO fully patched, but we recently got a new Server, and GPO forced all the PCs to get MSO redeployed, so there are undoubtedly unpatched versions on our Network.

    The 2nd, unrelated problem could be that the 2 PCs have different patches.

    Thanks for the feedback. Have a great day.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Quirks? (2003)

    The problem could be caused by a permissions problem. If a user doesn't have full permissions on the folder containing the database, the database could be read-only for that user.

    Another potential cause is database corruption. If a table's indexes are damaged, this could prevent multi-table queries involving that table from being updateable.

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Quirks? (2003)

    Another problem could be the server is full. Any file Access tries to open for example the .ldb file will fail and Access will then run read-only.

  7. #7
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Quirks? (2003)

    To be honest, I think it must be corruption, although it happened immediately *after* a Compact & Repair operation?????

    Everyone has full access to the Folder the DB is in, and the Server has plenty of room (brand-new). It's a real pain, though. I presume these kinds of things wouldn't happen if it were upgraded to SQL?

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Quirks? (2003)

    If a problem occurred during the Compact and Repair, that could cause the problem you describe (indexes are recreated from scratch during Compact and Repair, if this didn't finish correctly, a table might end up without a valid index).

    SQL Server is more robust than Access, but it's not infallible either.

  9. #9
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Quirks? (2003)

    Thanks, as always, for your reply, Hans.

    Happy Easter. [img]/forums/images/smilies/smile.gif[/img]

  10. #10
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Quirks? (2003)

    Hi guys

    I decided to check this out properly. I emailed myself a copy of our Company DB to my home PC. I relinked the Tables and then opened the Database. Our DB contains a section called Communications. I opened this Form and, sure enough, I can add records. I then performed a Compact & Repair, and now I can't add records. I re-extracted the Emailed DB and checked again. Once again, I can add records. Performing a Compact & Repair is definitely the cause of the problem. Is there any way I can fix this? Or can we simply never perform a Compact & Repair again? [img]/forums/images/smilies/sad.gif[/img]

  11. #11
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Quirks? (2003)

    OK, well done for identifying the issue. I would start by creating an empty Access database and then importing each database object into it from the old, start with the tables, then the queries then the forms, macros and then modules. I would then try a compact and repair and see what happens. Obviously keep a copy of the old one <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Let's just hope it is just the database shell that is broken. Start with that and report back.
    Jerry

  12. #12
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Quirks? (2003)

    Thanks. I tried that, but the error imports, ie, I can't add records to the Communications section. [img]/forums/images/smilies/sad.gif[/img]

  13. #13
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Quirks? (2003)

    Can you add records to the table or query that acts as record source of Communications after a Compact and Repair?

  14. #14
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Quirks? (2003)

    OK, here is another idea in addition to Hans. I am not quite sure how long this will take as you do not mention how many tables you have. How about copying each table as "Structure Only" recreating the relationships. Back the new DB up and then try to do a compact and repair and see if you can add records then. I want to see if there is any issue with the indexing on the table keys
    Jerry

  15. #15
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Quirks? (2003)

    Hi Hans

    Yes, I can add Records to the underlying Table, but not the underlying Query.

    Jerry, there are quite a lot of Tables. I was thinking of upgrading the Database to SQL. I'm not familiar with it yet, but perhaps now is a good time to learn! [img]/forums/images/smilies/sad.gif[/img]

Page 1 of 2 12 LastLast

Posting Permissions

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