Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2003
    Posts
    4

    Unanswered: Access 97 - Padding cells

    Dear all,

    I would like to know:
    - how can I measure the amount of memory that a record in my table allocates so I can pad it up with 'X's to reach the desirable 1024 K? (By this way I suppose each record will use a whole memory page of 2K?)
    - Is the above technique successful?

    For your information:
    I am currently trying to overcome the common problem of page-locking used by Access 97. I have around 30 users trying to pick and edit a random record from a table of 5,000 recs. It still seems that 2 or more users have conflicts very often.

    Thank you in advance

    Panos - call center programmer

  2. #2
    Join Date
    Nov 2002
    Posts
    150

    Re: Access 97 - Padding cells

    Yeah, Access's record locking is a pain. Turn it off and let the last to edit be the winner.

  3. #3
    Join Date
    Nov 2002
    Location
    Sacramento, CA
    Posts
    34
    I have record locking issues too.
    Did you ever find an answer for this??
    Make the money, don't let the money make you.

  4. #4
    Join Date
    Feb 2003
    Posts
    4

    Unhappy

    I am still struggling with this problem which is very critical to me because I am trying to manage the needs of 40+ persons editing records. For the moment the only thing I have succeeded in was to trap the error and create a short delay between 2 .edit efforts.

    Should I try to remove indexes from my tables?


    Originally posted by dragracer
    I have record locking issues too.
    Did you ever find an answer for this??

  5. #5
    Join Date
    Nov 2002
    Location
    Sacramento, CA
    Posts
    34
    What I have is people edit a job and then dont move off of it or close the DB. They just walk away from the PC, which locks in 10 minutes.

    So what I was thinking about doing was creating a timeout SaveRecord for my problems.

    I dont think that removing the indexs will help.
    IS there any possiblity for you to move you data to a SQL server
    Make the money, don't let the money make you.

Posting Permissions

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