Hi guys,
I am new to Access (came into programming a few years ago and went straight to SQL - don't hold it against me).
I have an Access DB on a remote server which serves as the datasource for my website. The website is hosted on server A and I debug and create the website on server B.
When I run the application from server B (Using Visual Studio .NET 2008) it works fine. If I open IE and enter the URL (effectively launching it from server A) it falls over with the message:
The Microsoft Jet database engine cannot open the file '\\servername\staff\database\myDB.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
Due to the fact that it works from one server but not the other, is there anything that needs to be installed on server A to make it able to talk to an Access DB on another server?
Oh, and if you are interested in why I chose Access if I only know SQL, it is something I have just inherited at work.
Additional: on server B I have looked in Component Services under DCOM Config and have the component 'Microsoft Office Access Application'. This is not listed on Server A. Could this be what is missing?
I am new to Access (came into programming a few years ago and went straight to SQL - don't hold it against me).
I have an Access DB on a remote server which serves as the datasource for my website. The website is hosted on server A and I debug and create the website on server B.
When I run the application from server B (Using Visual Studio .NET 2008) it works fine. If I open IE and enter the URL (effectively launching it from server A) it falls over with the message:
The Microsoft Jet database engine cannot open the file '\\servername\staff\database\myDB.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
Due to the fact that it works from one server but not the other, is there anything that needs to be installed on server A to make it able to talk to an Access DB on another server?
Oh, and if you are interested in why I chose Access if I only know SQL, it is something I have just inherited at work.
Additional: on server B I have looked in Component Services under DCOM Config and have the component 'Microsoft Office Access Application'. This is not listed on Server A. Could this be what is missing?
Last edited: