I'm writing a program which requires me to process access database data without using any form based controls.
I would like to read a record into a string, modify it and then write it back.
I'm using a database created in Access97
I have a table called proddata which has these fields
prodid - text
stock - long integer
preddesc - text
I'd like to read in a record where the prodid is specified, change the values of the fields using other program code and then write it back so that it's updated in the database.
Any help would be aprpecaited.
A generic example would be great - doesn't have to be tailored for the above table, I just need the method of achieving this.