Unable to link MS Access to MS SQL Server - Getting "Cannot generate SPSI Context" error
Posted on 2015-02-15
I have corruption with my MS Access 2K database so I copied all the objects into a new database. All is well, except I can not link to the MS SQL tables which are on a WIndows 7 machine running MS SQL Server 2008R2 .
The client machine is XP Pro and it is on the same LAN. We have One domain controller on the network but we also have a Windows 2000 server that was recently demoted at a domain controller but still runs Active Directory.
The Domain Controller is a Windows 2003 Server.
Any ideas what's wrong?