Linking a linked table??

[vyper78]

Problem:

I've got an sql server db (sql1) and 2 access db's (adb1, adb2)

Now, there is a table in adb1 (cars) that is linked to adb2 (cars), therefore, which ever information is saved on the front end form, it is saved to both databases.

Now, I want a table in sql1 called cars that has the same information, therefore, when adb1(cars) is updated, so are adb2(cars) and sql1(cars). I figure the only way to do this is with linked tables.

What is the best way to develope this link. I've been pulling my hair out for the last couple of days!!

Thanks

 

[TheFailedWizzard]

I'm new here but I don't understand why you have 3 db's all, apparently collecting the same information?

I may be way off base. Why do you need to do this? If it really is necessary then I would have thought it better to run an append table routine to update the other db's

 

[vyper78]

Sorry, after reaing it I realise I didn't make myself clear. There is an existing access db that has forms so users can enter in information (access_front_end). The tables it writes to are linked tables that correspond to another access db (access_back_end) that stores all the info ( I suppose for backup purposes or something).

Anyway, I'm writing a new interface for data retrieval in asp using an sql database. So when the data is updated in access, I want the table in sql to update also.

So far, the only thing I can do this is to create a linked table from sql into access and call it the same as the original table. Therefore, there will be no backup in the data access database (back_end).

I don't really have any other ideas, Access really isn't my forte. Unless a single form can write to both the table, AND a linked table at the same time?!?!

Anyways, thanks for the comment.