From: none@nospam.com   
      
   "Erland Sommarskog"  wrote in message   
   news:Xns9EDBF05F66BAYazorman@127.0.0.1...   
   > ron paii (none@nospam.com) writes:   
   >> I am trying to create a Linked Server from MS SQL server Management   
   >> Studio   
   >> to a MDB file on a 2nd Server.   
   >> Using Windows authentication I can query a remote table in the Studio   
   >> but not from a remote application. Using SQL authentication I get the   
   >> following error "Cannot start your application. The workgroup   
   >> information file is missing or opened exclusively by another user." If   
   >> the MDB file is moved to the C: drive of the SQL server, everything   
   >> works, using both authentication methods. There is no security setup on   
   >> the MDB file.   
   >> SQL server is NOT using a Domain account.   
   >   
   > That is probably the problem. If SQL Server runs under LocalSystem or   
   > somesuch, there is usually not access rights to remote shares.   
   >   
   >   
   > --   
   > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
   >   
   > Links for SQL Server Books Online:   
   > SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   > SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   >   
      
   Is there any issues with running it under a Domain account?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)