I'm using sp_addlinkedserver and sp_addlinkedsrvlogin to access an unsecured Access database. The TSQL Select statements I then use to read from the specified .mdb file work fine when I'm running SQL Server Personal Edition, but fail when using Express Edition (2005). When my Windows account is made an Administrator, then it works using Express Edition. I'm running with Windows authentication in both SQL Server instances (each is on a separate PC) and have the System Administrator role in both instances.
What could cause this behavior, and how can I deploy my tool on a laptop with SQL Server Express Edition without granting the users admin rights to the PC? I'll certainly appreciate any help, as the documentain I have says nothing about this. Thanks!