I am writing an ASP internet application using access 97.

The problem I have is that the goalposts have been moved (yet again!) and the database that was one may have to become many being used on subdomains of the same server sharing some information but not all from a 'global' database.

The solution I initially found was to used linked tables and developing it on pws this was perfect. I linked local databases to the tables in the 'global' database hey presto the application ran smoothly there was only 1 connection to each local database and I could retrieve all the information I needed from the global one. However on uploading I have no idea how to set this via asp or sql as online the path of the linked tables is what was on my local machine and I have found no way of being able to edit this.

Please could someone help with this or suggest an alternative direction to look for a solution. I realise I could do this with 2 separate connections with a bit of reworking of code but I would rather find a way with 1.

thanks
Stephen.

Maybe one of the articles here http://www.mvps.org/access/tables/index.html will help you, e.g. the one entitled "Relink Access tables from code".

Thanks pgtips but I am coding in classic asp and the articles of interest appear to be in asp.net. Do you know if they would be easily converted? if so I will attempt to do so.

Actually they are written in Access VBA. I think the idea is that you put them in your Access db and run them from there...

I have possibly posted onto the wrong forum so bare with me, how would I go about doing this, and will it run via a web browser as I use a third party web host?

Sorry, i know nothing about the intricacies of running your db on a 3rd party host.

Thanks any way,
I may have to post this on another forum.