Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts
    When I compact and repair databases on my computer it works fine. But, if I log into a citrix terminal and compact and repair those same databases, a new db is created in the same folder and the old one is left untouched. I have googled this and read that Access is supposed to then rename the new db and delete the old one. Several posts I read in other forums suggested the user didn't have delete permissions on the folder. But, I have tried this with two different databases that work correctly on my regular laptop connected to the network and it works fine. The problem seems to be in Citrix.

    Anyone heard of this issue before? I have been searching the citrix forums and haven't found an answer yet. I will continue searching, but I am hoping one of you has heard of this and can tell me if this is fixable.

    Thank you!!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Can you copy the database to a local hard disk, compact it there then copy it back?

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts
    We don't have rights to copy to the local disk when using Citrix. We can copy to another network drive. I've done that without any issues. I've even tried doing the compact/repair from a copy on another network drive. It seems to be just when I'm logged into a thin client on Citrix that the problem happens - no matter which network drive I am using and no matter which database.

    And, I can open the db on my other computer (not on citrix) and compact/repair there fine.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I think you're stuck then...

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Hans is correct - unless you can get Delete privileges on the network drive where your database is located, doing a Compact and Repair will always create the new database, but is unable to rename it since that involves deleting the original database.
    Wendell

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts
    But we DO have rights to delete and write to the folder on the network where the db is located. In fact, while logged in on Citrix, I can go to the database and copy it, move it, or delete it just fine. So if compact and repair creates a new database and renames it and deletes the old one, and it is working in the same folder as the original db, and I can manually do those same things, why can't Access complete the process?

    Hans, I would understand if it copies something to the local drive because we don't have rights there. But I do have full rights on the network drive and the folder where the db lives.


    [quote name='WendellB' post='771299' date='19-Apr-2009 16:47']Hans is correct - unless you can get Delete privileges on the network drive where your database is located, doing a Compact and Repair will always create the new database, but is unable to rename it since that involves deleting the original database.[/quote]

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I don't know how Citrix works, so I'm afraid I can't help you with this. Sorry.

  8. #8
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks anyway.

Posting Permissions

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