Updating sql server dao recordsets

So now I need to decide the best method to update my currency table (update existing records based on each currency code as opposed to adding new records).

For the long time users of Access that developed their skills around ODBC and sql server, you don’t have to do anything as the industry much decided what you been doing all along is the recommend approach.I have never done this before but it seems logical.One potential down side to this would be limited error handling because if the update query fails for some reason I'd have to troubleshoot to figure out what the problem is.I would appreciate your opinions on what the best practice would be and If you mean create a temporary table, update from that then then delete the temporary table I'd like to avoid that as the Access database will bloat quickly. In the meantime I have started building the inefficient method as I know how to do this.I suspect that you are correct in that it will still only take a few seconds to update all of the currencies so maybe it's not a big deal...

Leave a Reply

  1. matt czuchry dating anyone 21-Jan-2020 00:14

    Don’t fall victim to one of the classic scams when they’re easily avoided.

  2. internet colorado dating 03-Feb-2020 22:20

    Singles Activities in Los Angeles, Crock Pot Steak Bites, Boston Asian Community Asia Pictures and Images ...

  3. america dating matchmaking online site web 23-Aug-2020 03:55

    R-C Ranch was built by beef lovers, for beef lovers.

  4. Free fuck no credit card no sign up 04-Aug-2020 22:39

    ,7 M i l Ub Ie ', I,n »M™t llenjamln Harrlspii brought with him lo Wash- ington Ihroe horses, and admlrublo speclmona thoy are or tho breeds thoy Tha wua T«,l Ioy to pur- ^ULHoal.orw*.

  5. Free live web cam single girls 08-Dec-2019 19:34

    Longer established rival Schweppes has reacted to Fever Tree’s success in recent years by starting to offer “premium” mixer products.