move record from online sql server to a access db on clients machine

[esthera]

How could I take info from my sql db in asp and put it to an access db on my clients machine -- basically I guess I want to know how using asp I would be able to open a db on user machine and add the record. Is this possible?

[glenngv]

It would probably work with Javascript, ActiveXObject and IE but not without the annoying security alerts.

I would suggest that you just generate a CSV file and let the user download it. Then the user imports the CSV file from Access.

[Bullschmidt]

I'd suggest allowing the user to download a .csv file which could then be manually imported into Access.

Puzzle 5 Not much different from other solutions by Manohar Kamath posted 1/12/99
http://www.asp101.com/puzzles/puzzle5_s7.asp