VB6 Change all records in specific table

I am pretty good with VB, but I don't understand how to use databases
with VB yet. I prefer to use VB6 over 2003 or 2005 because I don't have
to worry about the bloated permissions.

I am trying to access an MS Access 97 database called "DB.mdb" with
multiple tables in it. In the "Links" table, field called "Type" I need
to change all the "T"s to "R"s. This field only contains one letter at
all times. There are over 300 thousand records in this table.

I usually do the replacement of the Ts to Rs manually but I would like
to programmatically do this from a single script.

I have a System DSN connection already setup called "DBConn" pointing
to the access database.
The user name is "admin" and the password is "db0102"

How do I setup a connection in VB6 to use the DSN connection already
setup to change all the records in the specific table field? I would to
prefer to see code as thats how I've learned anything so far.

Any books or links would be useful too.

.

Relevant Pages

  • Re: SetUp functions for multiple test cases
    ... couldn't find out how to implement a setup function, ... new database in-memory and fill it with example data for every single ... The True Unit Test Zealots will argue that all tests should be 100% ... SUnit from Smalltalk to Python: SUnit takes full advantage of ...
    (comp.lang.python)
  • Re: SQL database for use with VB6
    ... distribution that enables VB6 to access the Microsoft Jet Database. ... reason you stated. ...
    (microsoft.public.vb.general.discussion)
  • [NEWS] Lawson Financials RDBMS Insecurity
    ... Beyond Security would like to welcome Tiscali World Online ... the database itself) to easily compromise the Lawson Financials' database. ... Setup #1 tends to be the preferred configuration method by Lawson ...
    (Securiteam)
  • Re: Im very confused about the different databases!
    ... There's DAO, ADO, ADO.NET, Jet, SQL, SQL Server ... What database & version comes with VB6 LE? ... What is the most current database that I can use with VB6 LE? ... Why isn't Jet or whatever VB6 LE uses listed in Add-Remove Programs? ...
    (microsoft.public.vb.general.discussion)
  • Re: SetUp functions for multiple test cases
    ... couldn't find out how to implement a setup function, ... new database in-memory and fill it with example data for every single ... The True Unit Test Zealots will argue that all tests should be 100% ... should not interface with external resources like databases. ...
    (comp.lang.python)