Could you show the code/line on which the error occurs?
Are you trying to rename the file just for testing purposes, or in the code too?

>This problem seemed to pop up out of nowhere. My users cant access a file. Nowhere in my code do I ever have exclusive use of this table, I always use it shared.
>
>Can't access diespotcheck.cdx, it is in use by another user, try again later.
>
>I open my server manager(sbs 2003) and look at all of my open files. It is not among them. My server does not see it as being open by anyone. However, If I try to rename it, The server says I can't because it is in use by another user.
>
>I downloaded a third party software, hyena, and it also tells me that no one has it open. And again, if I try to rename it, it tells me it cant because someone has it open.
>
>This has happend before. If I wait overnight, the file will be freed up on it's own, if I reboot the server, the file will become available.
>
>I have copied the files and opened the copies with foxpro, nothing seems wrong, no corruption.
>
>I have went around to my clients and had anyone reboot that might be accessing the file, that hasn't helped.