MsAccess+Sql Server

[Thameem Aliyar]

Hi,
I have a ms access database and sql server database. I need to map the elements of both table and need to retrieve some data. What should i do for.........
Kindly reply me a solution.

Thanking you in advance.............`

[Vijitha Kumara]

Are you trying to do this as part of an application? Or an admin task?

[Thameem Aliyar]

Thanks for your reply..
I would like to do it as a part of an application..........

Jindly tell me the solution...........

[Thameem Aliyar]

Thanks for your reply..
I would like to do it as a part of an application..........

kindly tell me the solution...........

[Vijitha Kumara]

No need to post another reply just to change a mistake, just edit the one you just posted to correct it.

What kind of goal you have to achieve here? What kind of mapping are you talking about? You may need to tell more details about it (TellTheDetails).

[Thameem Aliyar]

Thank you for the reply..........

I got the answer..........
I did it using Linked tables.....

Hope similar cooperation in the future........
Thanking you in advance.......

[Vijitha Kumara]

If you like you may post some tips on how to do it for future readers' benefit .

[Thameem Aliyar]

Select the linked tables from file..... Add the particular sql server dsn from the machine datasource... And then you can add list of tables from the particular database.......... So it will get attached in your ms access DB.........
Thanks........