Specify remote mdw file location in provider string (Jet OLEDB:System Database=MySystem. Mdw) and allow access to it from local server.
My guess is that this is related to user I when you use Query Analyser you're using a different login than when you're accessing the server from your C# application. Try by setting the same username & password in your C# app. You could solve this by configuring the linked server connection with a username and password, so that SQL server disregards any other password/current user credentials.
Just use/check the last option/radio in this printscreen (disregard the login mappings list in the middle) and enter the username & password to use for ALL connections.
I have a SQL server 2000 and an Access database mdb connected by Linked server on the other hand I have a program in c # that updates data in a SQL table (Users) based data base access. OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. OLE / DB provider returned message: Can not start the application.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.