ASP Script to access a remote MS Access database

Hi,

I have a chalenging question; I would really apreciate any feedback,

Let us suppose that you have two websites, and they both have two seperate databases, and suppose you want those two database to talk to each others everytime an event is trigered on one of the websites ..

For example if you have a website 'A', that has many pages and that is accesable by the public. And you also have another website 'B', that has a MS Access DB, which collects data from website 'A', about how many people loged on to website 'A', and which pages they have viewed, and analyses it ....

So basicaly you need to run some script code on web site 'A', that when ever someone clicks on a link on website 'A', it increments a counter in the MS Access database on website 'B' ....

I have tried this typipcal code, but without any luck:

<%

set conn = Server.CreateObject("ADODB.Connection")

conn.open "Provider=MS Remote;" &_
"Remote Server=<u>http://www.website 'A'.com</u>;" &_
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source= \HitCounter.mdb</font id="red">;"

set rs = conn.Execute("SELECT * FROM tabella")

%>

................................................................

Please Advice
Thank You

 

Thank you for your feedback,

What about a remote SQL server DB??? Is that not supported as well??
And if not, please tell about any thoughts on a way for achieving this task, I am sure there is a way to it, and I really appreciate your help,
Thank You