Updating an Access database with VB

Results 1 to 2 of 2

Thread: Updating an Access database with VB

  1. #1
    Greg Connolly Guest

    Default Updating an Access database with VB

    I&#039;m in a bit of a spot and I hope someone can help me. I need to write a vb app, that can be run on a machine, open an Access database without using a dsn, and convert the values in all the currency fields from pounds to euros. I.E. Multiply them by 0.78. I&#039;m lost as how to open the database and get the information like you would in ASP. I wand to be able to run something like rs("bill") = rs("bill")/0.75 and then Update the table.<BR>If anyone can help me I would be more than greatfull.<BR><BR>Thanks<BR>Greg

  2. #2
    Join Date
    Dec 1969

    Default RE: Updating an Access database with VB

    I wouldn&#039;t know about VB, but as alternative how about converting an ASP script to a script that can be run using windows scripting host.<BR><BR>&#062; I think the FAQ&#039;s have help for a DSN less connection<BR>&#062; The query you want would all be done in one update query i.e.:<BR>"UPDATE Tbl SET Bill = Bill/0.75"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts