Access 2000 database is now installed on Window 2000 Server (File Server and Domain Controller), using Active Directory. Win98 SE Client running Access 2000 can open it, but when I try to open it with Access 2002 on my XP Pro client, Access refuses, telling me it's not a trusted site or outside the Intranet, and suggesting I copy the database to a local drive to open it. This works OK when the database is closed - I can copy it, modify it, and copy it back just fine. Obviously it doesn't allow me to modify the database when it's in use elsewhere...
I'm still in the process of setting up the Server, am a total Rookie with 2000 Server, so you may have some questions I don't know enough to answer yet... I've looked at Access and Windows security settings, poked around the Registry a bit too, and have yet to figure out where the source of the problem is.
Here's hoping (as seems to happen a lot here) that you'll see this, remember solving the same issue yourself, and get me online. Otherwise, let me know the questions I haven't answered yet - very likely in looking for those answers I'll see the problem, otherwise over time I'm confident you'll help me reach the solution!
I will be gradually adding Read-Only or Read-Write access to other Clients in the LAN, and eventually on the VPN as well, so I'd also welcome words of wisdom on networking MS Access and on Win 2000 Server/Active Directory configuration.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!