I'm having a problem I've never encountered before:
I have an Access 2000 database on a PC with Windows 2000,
networked with 3 other PCs (2 have Windows 2000, 1 has XP)
and the database folder keeps getting unmapped from the
other machines. This is just happening to the database
and it's folder; none of the other files or folders shared
by the network are unmapping.
I thought the fact that we're using different operating
systems might me the cause but we disconnected the XP PC
from the network and still had the problem.
This is happening a couple of times a day and it's
creating data problems.
Has anyone else had similar problems? And does anyone
have any advice or suggestions for things I can try?
Thanks in advance!
Howard Brody
HSalim - 18 Sep 2003 05:27 GMT
Access does not in any way disconnect or connect drive mappings, (that is
the OS' business),
unless you have specific code in your VBA that does that.
It is not inconceivable to have that code - for example, If you are using a
frontEnd/BackEnd and
you are using linked tables, the developer may have written some code to
manage drive mappings.
Are you using a workgroup or a domain?
If you are using a workgroup, then make sure that each user has an account
on the server and that the passwords are the same.
This will work as well.
Using a Domain usually makes it easier as authentication is seamless and
guaranteed. You only have to manage the rights correctly.
HS
> I'm having a problem I've never encountered before:
>
[quoted text clipped - 18 lines]
>
> Howard Brody