Access 2003 on Citrix

Topic

New Reply

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!!

Reply | Quote

Replies

Can you copy the database to a local hard disk, compact it there then copy it back?

Reply | Quote

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.

Reply | Quote

I think you’re stuck then…

Reply | Quote

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.

Reply | Quote

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.

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.

Reply | Quote

I don’t know how Citrix works, so I’m afraid I can’t help you with this. Sorry.

Reply | Quote

Thanks anyway.

Reply | Quote