Strange BUG: XP home, access DB compact, and "access denied"

[foo]

This is probably an issue for an Access Guru.

Scenario:

Access 2000 on both machines
Laptop running XP Home
Desktop running XP Pro

I am running an Access application on the desktop. I copy to the laptop
(copy c:\foo.mdb \\laptop\share\foo.mdb) to take the app on the road, and
copy it back to the desktop when I get back.

The problem is I have "compact on close" or I manually compact the app on
the laptop, when I try to move it back to the desktop, the laptop says
"access denied". The laptop can be shut down and powered back up and still
the problem remains. I can go to the laptop and copy the file to another
location, and the new copy is available over the network, at least until I
compact it.

The interesting thing, is that with XP Pro on the laptop all is fine.

I can't find it, but there must be an MS issue with XP Home, compacting a DB
and copying it over the network. It appears that the redirector on the
laptop thinks the file is still open. but only under XP Home.

Thanks for any info anyone has.

Andrew

 

[Arvin Meyer]

I'm not sure this will help. XP Home is not really designed for networks. It
can do ICS and some non-domain home networking. But domain permissions are
impossible since XP Home cannot join a domain. It can, however, connect to
the domain with proper authentication. There may be policies set on the
network that limit how files can be used and/or copied.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Jim]

I experienced a similar problem, but in reverse. My
Access 2000 database normally resides on a desktop
running XP Home. I frequently need to connect to this DB
from my laptop running XP Pro. When I recently compacted
the DB on the desktop, I could no longer connect to it
from the laptop. After reading this post, I copied the DB
from the desktop (HP home) to the laptop (XP Pro), opened
it on the laptop, closed it, copied it back to the
desktop and all is well again. I also noted that even
though the DB is in the "Shared" folder on the XP Home
desktop, I could not copy using the lap top -- I had to
do the copy from the desktop. Sounds like compacting the
DB with XP Home does some really nasty business regarding
the security in HP Home. Really does sound like a bug!

 

[chriske911]

the same here where all my projects reside on my home Win2k server and
connecting from my laptop :

from time to time I have no problem so everything goes well but sometimes I
get the message "file already exists" when trying to compact and repair ?
this is not consistent behaviour and never repeatable under same conditions

grtz