One of those frustrating days.
Working with a new client. Peer-to-Peer network, “server” is XP Pro, and I think other workstations were also XP Pro.
On the server/workstation, I copied 2 Access databases (a frontend and backend) to new filenames within the same directory. I made some minor changes and relinked them. Everything worked fine.
I then went to another workstation and tried to copy the frontend db down to a local drive, but got an “Access Denied” message, indicating file space full, or in use by another user, etc. As it turns out, I couldn’t do anything with the new databases from the workstation; I couldn’t open them, I couldn’t rename them, I couldn’t copy them. Same situation at the other 4 workstations!
This seemed to be some sort of permissions problem, but I don’t understand what. I could still do anything I wanted with other files within that same server directory from any of the workstations! Almost like there was a file-level permission that was denying access to the files, but there isn’t any file-level security, is there? (other than the Read-only property, which was not set).
From the server, I happened to make a copy of one of the “offending” databases, and voila! All workstations could open that copy! So I just renamed both databases, made copies back to the original filenames, and all the workstations were fine and dandy, I could even open the database simultaneously from 2 or more workstations!
Does anyone know what I was running into?
