I create a table in SQL Server 2008 R2 Express and can link to it with Access 2007. However, when I do the same thing, but attempt to link to a table on a remote server (within the domain) instead of local on this computer, it looks like it works,
it correctly identifies the table on the server, but in the end fails to complete. The test is successful, but it says "Access Denied" or something like that. I have set the login on both machines as Administrator or by my name, both of which are registered
on the domain, but no luck. Help!
View Complete Post