Page 1 of 2 12 LastLast
Results 1 to 15 of 22
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Check Box Blows up Database (WIN97/ACC 97)

    Same story, different day.
    I have a form that has worked fine for a couple of years. It still does except that every so often when a user clicks on the only checkbox on the form, the checkbox goes gray and the database hangs.
    The only way out is Task Manager.
    Does any one know what could cause this?

    It doesn't happen every day - just occasionally.
    All other controls work fine.

    I have tried repair/compact.
    I have recreated the check box.
    I have imported it all into a fresh database.



    Please HELP !!

    Michael Abrams

  2. #2
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check Box Blows up Database (WIN97/ACC 97)

    More info please...
    What is the checkbox supposed to do?
    Are there any recognizable patterns of when this happens?
    Does it happen to you or someone else (or both)?

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check Box Blows up Database (WIN97/ACC 97)

    Simple check box - bound to Yes/No field in table.

    If checked = Yes
    Unchecked = No

    No pattern. I have 15 users - maybe 5 at the same time at any given time.
    Database is split - front end on individual PCs, back end on server.
    It happens to everyone at different times.
    If 4 of us are using the db at the same time, it may (or may not) happen to 1 of us, 2 of us or none of us.
    There is no combination of number of users or actual users that comes up more often than others. It seems to be random.

    For example, it just happened to user1, but I was fine and everyone else was fine.

    An hour from now, user1 will be fine as will we all.

    3 days from now user 2 and user3 may get jammed.

    No rhyme or reason (so it seems !!!)

    Thanks for taking the time to respond.

    Michael

  4. #4
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check Box Blows up Database (WIN97/ACC 97)

    Thanks, that's helpful.
    Have there been any new updates to the system?
    How long has this been going on?
    More users now?
    How large is the database (filesize) and how many records (ballpark) are we talking about?
    Are these records simultaneously 'being used elsewhere' , like in a spreadsheet?
    Just preliminary questions...but it helps get the ball rolling. <img src=/S/compute.gif border=0 alt=compute width=40 height=20>

  5. #5
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check Box Blows up Database (WIN97/ACC 97)

    No new updates.
    It's happened sporadically over the last month.
    (I even asked my Network folks on the days that this happens if the network "burped" at all that day. They say No.
    Same amount of users. 15 - with 5 max at a time. This happens regardless of the amount of users and happens to 1 or 2 users at different times. (Not the same users all the time)
    File is about 9 mb with about 10,000 records.
    Form is data entry form. Users only have access to this form.

    Thank again !!

  6. #6
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check Box Blows up Database (WIN97/ACC 97)

    Any new users?
    The last month...sounds suspicious when you approach it from the server side.
    There may not have been any network 'burps' but they could be running some new process.
    I would talk with them a little more and see what's new over on their end...especially within the last 30 or so days!!

  7. #7
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check Box Blows up Database (WIN97/ACC 97)

    Thanks jazman.
    No new users.

    I will have a little talk with the network guys again.

    Thanks !!

    Michael

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

    Re: Check Box Blows up Database (WIN97/ACC 97)

    Network guys tend *not* to understand anything about Access, and they will always tell you it isn't a network problem. The fact is that Access is particularly sensitive to the most fleeting network hiccups, things that Word or Excel can take in their stride. This is true with even a single user, let alone a multi-user setup.

    Are the users all running the same front end from the network or are they running local copies of the front end against a server-based back end? You also need to check the code behind your form to make sure that a network collision when the user is trying to write the value isn't throwing that particular workstation into an endless loop of trying to save the record when someone else has a lock on it.
    Charlotte

  9. #9
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check Box Blows up Database (WIN97/ACC 97)

    Thanks Charlotte - no kidding about the network guys/gals. That's why my original post mentioned possible 'burps',
    (probably should've used hiccup !!)

    Each user has his/her own copy on their workstation.

    I believe your suggestion is correct :
    "make sure that a network collision when the user is trying to write the value isn't throwing that
    particular workstation into an endless loop of trying to save the record when someone else has a lock on it."


    My question - Is there anything in particular I should look for in the code?

    An observation - nothing in the form is different, no updates to the database, no new users in
    3 months - this has only started a month ago. (Which is why I believe it is the NETWORK !!!) And it doesn't
    happen all the time, or to the same users.

    Again, thanks for your response - the post started slipping downward and your reply brought it back to life !

    Michael Abrams

  10. #10
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check Box Blows up Database (WIN97/ACC 97)

    OK - It happened again today - here is some more information that someone hopefully will say "Oh, I know why that is happening, here is how you fix it!!"

    User1 got the "Can't update.... due to ... locked by user
    MarySmith"...
    Now, I understand that Access locks 2 "pages" not necessarily the exact record. (The 2 users were not on the same record.

    The interesting thing, is that when it happens the other way around with these particular users, Mary Smith does not get this error message. It just hangs indefinitely.

    Can anyone suggest what is wrong and how to cure it?

    Thanks for all advice.

    Michael

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

    Re: Check Box Blows up Database (WIN97/ACC 97)

    Has it been happening more often with the more users using it, this could probably explain why it is happening more often these days.

    With page locking it depends how long the records are as to how many people could be theoritically locked, if they are short records it affects a lot of users at the same time.

    On the locked PC's you should notice the "No Smoking" sign ( a circle with a line through it), they will just have to wait till the user who locked the page unlocks it.

    If you can upgrade to Access 2000 you can employ real record locking which would do away with this problem.

    HTH
    Pat

  12. #12
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check Box Blows up Database (WIN97/ACC 97)

    patt:
    No pattern with number of users. There really isn't more than 3 or 4 users in the db at one time.
    The records are not very long.

    The original question is:
    The checkbox in question is the first control on the form. It is the only one that grays out if you try to click it.
    If you try to enter any other control on the form first, the other controls work fine. Only the damn check box grays out and then Access hangs.

    I have requested Access 2000 here at work and basically was told to be glad they even upgraded to 97 !!

    Thanks for the pointers patt !!

    Michael Abrams

  13. #13
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check Box Blows up Database (WIN97/ACC 97)

    Doesn't Access save its records in 'pages', isn't it 3 records per page on average?
    <font color=red>[Expert advice needed here]</font color=red>
    That supports your error message.
    As to why it blows up your system with the hiccup, I'm still befuddled.
    Let alone that it could be happening randomly on any hiccup,
    when two users are on the same page regardless of the checkbox control.
    I think the checkbox control just got an alibi.
    but ,maybe you 're running an event on that control...
    ALSO...
    Have you tried altering your refresh interval?
    That could avert a network packet collision <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15>

  14. #14
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check Box Blows up Database (WIN97/ACC 97)

    My refresh interval is currently 60.
    I have events on many of the controls. The checkbox is the only one that grays out and bombs !!

    Should I bump it up or down? What exactly does this do?

    Thanks jazman2001 !

    Michael

  15. #15
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check Box Blows up Database (WIN97/ACC 97)

    It alters the frequency in which you try to update records on networks.
    Sorry-(Lower value is a shorter time between refresh calls)

    YOU might look into futzing with the
    [update retry interval](1-1,000-millisec)
    -this alters the frequency at which the record locked by another user is tested again.
    or the...
    [number of update retries](1-10) for records locked by other users.
    BOTH seem like viable options in your case.

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
  •