Hi.
I have two databases, both originally created in Access 2000 on a Windows 2000 platform. database A has links to two tables in database B.
Both databases are on a shared drive and are accessed daily by 10 concurrent users.
Originally these links worked perfectly and it did not matter how many users had each database open the link still worked.
Three months ago Access was upgraded to 2003 and still everything worked fine. Last month, however, the OS was upgraded to Windows XP Pro and now we have a problem.
If both databases are open at the same time on the same machine the link won't work; it returns a message saying that tha database B is already open and it cannot connect to an already open file. However, if you close database B the link works fine. It doesn't matter if every other user has database B open at the same time the link will still work.
Seems to be some sort of local machine file locking conflict brought on by XP. I know XP is much more security conscious than 2000 but both databases are set up as shared and work OK between multiple users.
Our IT dept are not interested in supporting Access even though it is the only database that 85% of the workforce have access to. Only the chosen few get Oracle and support. For the rest of us it is "doctor heal thy self"
I have already turned down all the security settings to minimumum to get macros to work but that has not helped this problem.
Any suggestions welcome.
I have two databases, both originally created in Access 2000 on a Windows 2000 platform. database A has links to two tables in database B.
Both databases are on a shared drive and are accessed daily by 10 concurrent users.
Originally these links worked perfectly and it did not matter how many users had each database open the link still worked.
Three months ago Access was upgraded to 2003 and still everything worked fine. Last month, however, the OS was upgraded to Windows XP Pro and now we have a problem.
If both databases are open at the same time on the same machine the link won't work; it returns a message saying that tha database B is already open and it cannot connect to an already open file. However, if you close database B the link works fine. It doesn't matter if every other user has database B open at the same time the link will still work.
Seems to be some sort of local machine file locking conflict brought on by XP. I know XP is much more security conscious than 2000 but both databases are set up as shared and work OK between multiple users.
Our IT dept are not interested in supporting Access even though it is the only database that 85% of the workforce have access to. Only the chosen few get Oracle and support. For the rest of us it is "doctor heal thy self"
I have already turned down all the security settings to minimumum to get macros to work but that has not helped this problem.
Any suggestions welcome.
Last edited: