O
ondine
Hi
I am having this very weird problem with a client. I had to create a
new back-end data file for them due to some corruption a few months
ago, all went well and I opened their front end on the server machine
without any trouble. However, when I went to one of the other pcs and
opened their copy of the front end it wouldn't link to the data. I
got a message telling me that I didn't have permissions on the folder
etc. Of course nothing had changed, the folder was shared in exactly
the same way. I could see the data file in Windows explorer, but
couldn't open it directly either (similar message), although I could
open other MS Access files.
I seem to remember that the networked pc could open the file if the
server pc didn't have it's front-end open, but it wasn't practical to
leave the client in that situation. In the end, I found that if I
made a copy of the file and named the copy something else, I could
link to or open it on all pcs. However - if I changed the name of the
copy back to the original (having moved the original or renamed it)
then I was back to square one. It was all extremely strange the
frustrating.
I left the data with a different name, but on a subsequent visit
managed to change it back again and everything was fine. However,
today I had to get them to email me their data file as they had some
data problems - I sorted it out, emailed the file back and replaced
the original file with mine via remote access. I opened the front end
again on the server pc and all was well.
However: they then tried to get into the system on another networked
pc and have had the same problem - the front end can't connect to the
data.
I'm tearing my hair out - have never come across this in 10 years of
Access development - can anyone please help??
We are all using Access 2000 btw.
Thanks!
Ondine.
I am having this very weird problem with a client. I had to create a
new back-end data file for them due to some corruption a few months
ago, all went well and I opened their front end on the server machine
without any trouble. However, when I went to one of the other pcs and
opened their copy of the front end it wouldn't link to the data. I
got a message telling me that I didn't have permissions on the folder
etc. Of course nothing had changed, the folder was shared in exactly
the same way. I could see the data file in Windows explorer, but
couldn't open it directly either (similar message), although I could
open other MS Access files.
I seem to remember that the networked pc could open the file if the
server pc didn't have it's front-end open, but it wasn't practical to
leave the client in that situation. In the end, I found that if I
made a copy of the file and named the copy something else, I could
link to or open it on all pcs. However - if I changed the name of the
copy back to the original (having moved the original or renamed it)
then I was back to square one. It was all extremely strange the
frustrating.
I left the data with a different name, but on a subsequent visit
managed to change it back again and everything was fine. However,
today I had to get them to email me their data file as they had some
data problems - I sorted it out, emailed the file back and replaced
the original file with mine via remote access. I opened the front end
again on the server pc and all was well.
However: they then tried to get into the system on another networked
pc and have had the same problem - the front end can't connect to the
data.
I'm tearing my hair out - have never come across this in 10 years of
Access development - can anyone please help??
We are all using Access 2000 btw.
Thanks!
Ondine.