Compact & Repair Problem

I am having a problem compacting & repairing our data base. it is giving us
an error ( you attempted to open a database that is already opened
exclusively by user on a machine, Try again when the datebase is available).
Whe I look in the LDB file I am the only one in it. I asked our IT people to
force it closed and got told they don't know what I am going on about.
1. Can some one explain how I can do it
2. Explain in dedtail what I need the IT guys to do

Thanks

6 Comments

  1. Re: Compact & Repair Problem by Gina Whipp

    Gina Whipp 2009-10-21

    MarkS,

    Have you tried exiting the databse and making sure the .LDB has been
    deleted? It should also be noted you don't want your IT guys to force the
    close of a database because someone might be in it right in the middle of
    something and you will cause them to lose their work or worst you will
    corrupt the database. So the first order of business is to check that the
    .LDB actually deletes when everyone is out of it.

    Once you confirm that report back with the results.

    --
    Gina Whipp

    "I feel I have been denied critical, need to know, information!" - Tremors
    II

    http://www.regina-whipp.com/index_files/TipList.htm

    "MarkS" <MarkS@discussions.microsoft.com> wrote in message
    news:907EB8C9-26B4-4AA8-94B9-FBED460EC528@microsoft.com...
    I am having a problem compacting & repairing our data base. it is giving us
    an error ( you attempted to open a database that is already opened
    exclusively by user on a machine, Try again when the datebase is
    available).
    Whe I look in the LDB file I am the only one in it. I asked our IT people
    to
    force it closed and got told they don't know what I am going on about.
    1. Can some one explain how I can do it
    2. Explain in dedtail what I need the IT guys to do

    Thanks

  2. Re: Compact & Repair Problem by UtfBTWFyaM

    UtfBTWFyaM 2009-10-21

    HI,

    Yes I am the only one in it and when I exit it is still there with my entry
    still in it

    "Gina Whipp" wrote:

    MarkS,

    Have you tried exiting the databse and making sure the .LDB has been
    deleted? It should also be noted you don't want your IT guys to force the
    close of a database because someone might be in it right in the middle of
    something and you will cause them to lose their work or worst you will
    corrupt the database. So the first order of business is to check that the
    ..LDB actually deletes when everyone is out of it.

    Once you confirm that report back with the results.

    --
    Gina Whipp

    "I feel I have been denied critical, need to know, information!" - Tremors
    II

    http://www.regina-whipp.com/index_files/TipList.htm

    "MarkS" <MarkS@discussions.microsoft.com> wrote in message
    news:907EB8C9-26B4-4AA8-94B9-FBED460EC528@microsoft.com...
    >I am having a problem compacting & repairing our data base. it is giving us
    > an error ( you attempted to open a database that is already opened
    > exclusively by user on a machine, Try again when the datebase is
    > available).
    > Whe I look in the LDB file I am the only one in it. I asked our IT people
    > to
    > force it closed and got told they don't know what I am going on about.
    > 1. Can some one explain how I can do it
    > 2. Explain in dedtail what I need the IT guys to do

    > Thanks


    .

  3. Re: Compact & Repair Problem by Gina Whipp

    Gina Whipp 2009-10-22

    Then have the IT guys check your permissions. Sounds like you don't have
    delete permissions which is why the .LDB is still showing. That is why you
    can't Compact & Repair.

    --
    Gina Whipp

    "I feel I have been denied critical, need to know, information!" - Tremors
    II

    http://www.regina-whipp.com/index_files/TipList.htm

    "MarkS" <MarkS@discussions.microsoft.com> wrote in message
    news:C17671E4-E1DC-430F-88D8-A18D019D3F17@microsoft.com...
    HI,

    Yes I am the only one in it and when I exit it is still there with my
    entry
    still in it

    "Gina Whipp" wrote:

    MarkS,

    Have you tried exiting the databse and making sure the .LDB has been
    deleted? It should also be noted you don't want your IT guys to force
    the
    close of a database because someone might be in it right in the middle of
    something and you will cause them to lose their work or worst you will
    corrupt the database. So the first order of business is to check that
    the
    ..LDB actually deletes when everyone is out of it.

    Once you confirm that report back with the results.

    --
    Gina Whipp

    "I feel I have been denied critical, need to know, information!" -
    Tremors
    II

    http://www.regina-whipp.com/index_files/TipList.htm

    "MarkS" <MarkS@discussions.microsoft.com> wrote in message
    news:907EB8C9-26B4-4AA8-94B9-FBED460EC528@microsoft.com...
    >I am having a problem compacting & repairing our data base. it is giving
    >us
    > an error ( you attempted to open a database that is already opened
    > exclusively by user on a machine, Try again when the datebase is
    > available).
    > Whe I look in the LDB file I am the only one in it. I asked our IT
    > people
    > to
    > force it closed and got told they don't know what I am going on about.
    > 1. Can some one explain how I can do it
    > 2. Explain in dedtail what I need the IT guys to do

    > Thanks


    .


  4. Re: Compact & Repair Problem by UtfBQnVuak

    UtfBQnVuak 2009-10-22

    In the past, I have experienced the same problem several times. Since I have
    administrative rights to the drive, I knew that was not the problem. IT
    would cycle the drive my database was on and it normally deleted the .ldb
    file. One thing you can try, 1) do a control, alt, delete and look at the
    task manager. See if you have multiple sessions of access running at the
    same time. If so, end all sessions and try it again. Also, when you exit
    access, if you use the 'X' in the top right hand corner of the screen, it
    does not always delete the locking file. ALWAYS either use a command button
    to exit or do the File>exit method.

    Hope this helps.
    Kent

    "Gina Whipp" wrote:

    Then have the IT guys check your permissions. Sounds like you don't have
    delete permissions which is why the .LDB is still showing. That is why you
    can't Compact & Repair.

    --
    Gina Whipp

    "I feel I have been denied critical, need to know, information!" - Tremors
    II

    http://www.regina-whipp.com/index_files/TipList.htm

    "MarkS" <MarkS@discussions.microsoft.com> wrote in message
    news:C17671E4-E1DC-430F-88D8-A18D019D3F17@microsoft.com...
    > HI,

    > Yes I am the only one in it and when I exit it is still there with my
    > entry
    > still in it

    > "Gina Whipp" wrote:

    >> MarkS,

    >> Have you tried exiting the databse and making sure the .LDB has been
    >> deleted? It should also be noted you don't want your IT guys to force
    >> the
    >> close of a database because someone might be in it right in the middle of
    >> something and you will cause them to lose their work or worst you will
    >> corrupt the database. So the first order of business is to check that
    >> the
    >> ..LDB actually deletes when everyone is out of it.

    >> Once you confirm that report back with the results.

    >> --
    >> Gina Whipp

    >> "I feel I have been denied critical, need to know, information!" -
    >> Tremors
    >> II

    >> http://www.regina-whipp.com/index_files/TipList.htm

    >> "MarkS" <MarkS@discussions.microsoft.com> wrote in message
    >> news:907EB8C9-26B4-4AA8-94B9-FBED460EC528@microsoft.com...
    >> >I am having a problem compacting & repairing our data base. it is giving
    >> >us
    >> > an error ( you attempted to open a database that is already opened
    >> > exclusively by user on a machine, Try again when the datebase is
    >> > available).
    >> > Whe I look in the LDB file I am the only one in it. I asked our IT
    >> > people
    >> > to
    >> > force it closed and got told they don't know what I am going on about.
    >> > 1. Can some one explain how I can do it
    >> > 2. Explain in dedtail what I need the IT guys to do
    >>
    >> > Thanks


    >> .
    >>


    .

  5. Re: Compact & Repair Problem by UtfBTWFyaM

    UtfBTWFyaM 2009-10-22

    Hi,
    Yes I am have admin rights, I have checked I don't have multiple sessions
    running. I tryed opening and shuting it down using the File/Exit method.
    unfortunately no change

    Thanks MarkS

    "Bunky" wrote:

    In the past, I have experienced the same problem several times. Since I have
    administrative rights to the drive, I knew that was not the problem. IT
    would cycle the drive my database was on and it normally deleted the .ldb
    file. One thing you can try, 1) do a control, alt, delete and look at the
    task manager. See if you have multiple sessions of access running at the
    same time. If so, end all sessions and try it again. Also, when you exit
    access, if you use the 'X' in the top right hand corner of the screen, it
    does not always delete the locking file. ALWAYS either use a command button
    to exit or do the File>exit method.

    Hope this helps.
    Kent

    "Gina Whipp" wrote:

    > Then have the IT guys check your permissions. Sounds like you don't have
    > delete permissions which is why the .LDB is still showing. That is why you
    > can't Compact & Repair.
    >
    > --
    > Gina Whipp
    >
    > "I feel I have been denied critical, need to know, information!" - Tremors
    > II
    >
    > http://www.regina-whipp.com/index_files/TipList.htm
    >
    > "MarkS" <MarkS@discussions.microsoft.com> wrote in message
    > news:C17671E4-E1DC-430F-88D8-A18D019D3F17@microsoft.com...
    > > HI,
    >
    > > Yes I am the only one in it and when I exit it is still there with my
    > > entry
    > > still in it
    >
    > > "Gina Whipp" wrote:
    >
    > >> MarkS,
    >
    > >> Have you tried exiting the databse and making sure the .LDB has been
    > >> deleted? It should also be noted you don't want your IT guys to force
    > >> the
    > >> close of a database because someone might be in it right in the middle of
    > >> something and you will cause them to lose their work or worst you will
    > >> corrupt the database. So the first order of business is to check that
    > >> the
    > >> ..LDB actually deletes when everyone is out of it.
    >
    > >> Once you confirm that report back with the results.
    >
    > >> --
    > >> Gina Whipp
    >
    > >> "I feel I have been denied critical, need to know, information!" -
    > >> Tremors
    > >> II
    >
    > >> http://www.regina-whipp.com/index_files/TipList.htm
    >
    > >> "MarkS" <MarkS@discussions.microsoft.com> wrote in message
    > >> news:907EB8C9-26B4-4AA8-94B9-FBED460EC528@microsoft.com...
    > >> >I am having a problem compacting & repairing our data base. it is giving
    > >> >us
    > >> > an error ( you attempted to open a database that is already opened
    > >> > exclusively by user on a machine, Try again when the datebase is
    > >> > available).
    > >> > Whe I look in the LDB file I am the only one in it. I asked our IT
    > >> > people
    > >> > to
    > >> > force it closed and got told they don't know what I am going on about.
    > >> > 1. Can some one explain how I can do it
    > >> > 2. Explain in dedtail what I need the IT guys to do
    > >>
    > >> > Thanks
    >
    >
    > >> .
    > >>
    >
    >
    > .
    >

  6. Re: Compact & Repair Problem by Gina Whipp

    Gina Whipp 2009-10-22

    MarkS,

    What happens if you simply try to delete the .LDB? Of course, insuring no
    one else is in it? Another thought, do you leave any Recordsets Open?
    Also, is Name AutoCorrect unchecked?

    --
    Gina Whipp

    "I feel I have been denied critical, need to know, information!" - Tremors
    II

    http://www.regina-whipp.com/index_files/TipList.htm

    "MarkS" <MarkS@discussions.microsoft.com> wrote in message
    news:AB5E612D-CCA3-49B7-B991-860D6C0E43DB@microsoft.com...
    Hi,
    Yes I am have admin rights, I have checked I don't have multiple sessions
    running. I tryed opening and shuting it down using the File/Exit method.
    unfortunately no change

    Thanks MarkS

    "Bunky" wrote:

    In the past, I have experienced the same problem several times. Since I
    have
    administrative rights to the drive, I knew that was not the problem. IT
    would cycle the drive my database was on and it normally deleted the .ldb
    file. One thing you can try, 1) do a control, alt, delete and look at
    the
    task manager. See if you have multiple sessions of access running at the
    same time. If so, end all sessions and try it again. Also, when you
    exit
    access, if you use the 'X' in the top right hand corner of the screen, it
    does not always delete the locking file. ALWAYS either use a command
    button
    to exit or do the File>exit method.

    Hope this helps.
    Kent

    "Gina Whipp" wrote:

    > Then have the IT guys check your permissions. Sounds like you don't
    > have
    > delete permissions which is why the .LDB is still showing. That is why
    > you
    > can't Compact & Repair.

    > --
    > Gina Whipp

    > "I feel I have been denied critical, need to know, information!" -
    > Tremors
    > II

    > http://www.regina-whipp.com/index_files/TipList.htm

    > "MarkS" <MarkS@discussions.microsoft.com> wrote in message
    > news:C17671E4-E1DC-430F-88D8-A18D019D3F17@microsoft.com...
    > > HI,
    >
    > > Yes I am the only one in it and when I exit it is still there with my
    > > entry
    > > still in it
    >
    > > "Gina Whipp" wrote:
    >
    > >> MarkS,
    >
    > >> Have you tried exiting the databse and making sure the .LDB has been
    > >> deleted? It should also be noted you don't want your IT guys to
    > >> force
    > >> the
    > >> close of a database because someone might be in it right in the
    > >> middle of
    > >> something and you will cause them to lose their work or worst you
    > >> will
    > >> corrupt the database. So the first order of business is to check
    > >> that
    > >> the
    > >> ..LDB actually deletes when everyone is out of it.
    >
    > >> Once you confirm that report back with the results.
    >
    > >> --
    > >> Gina Whipp
    >
    > >> "I feel I have been denied critical, need to know, information!" -
    > >> Tremors
    > >> II
    >
    > >> http://www.regina-whipp.com/index_files/TipList.htm
    >
    > >> "MarkS" <MarkS@discussions.microsoft.com> wrote in message
    > >> news:907EB8C9-26B4-4AA8-94B9-FBED460EC528@microsoft.com...
    > >> >I am having a problem compacting & repairing our data base. it is
    > >> >giving
    > >> >us
    > >> > an error ( you attempted to open a database that is already opened
    > >> > exclusively by user on a machine, Try again when the datebase is
    > >> > available).
    > >> > Whe I look in the LDB file I am the only one in it. I asked our IT
    > >> > people
    > >> > to
    > >> > force it closed and got told they don't know what I am going on
    > >> > about.
    > >> > 1. Can some one explain how I can do it
    > >> > 2. Explain in dedtail what I need the IT guys to do
    > >>
    > >> > Thanks
    >
    >
    > >> .
    >


    > .
    >