add and modify

[anonymous]

[Originally posted by c isaac]

To add and modify a MsAccess table through VB

To find the max value in a field in a table

[anonymous]

[Originally posted by Tich]

what are you using? DAO or ADO?

You can create tables using ADO, by generating the SQL to create the table (whats in the SQL depends on the database), and callnig the 'Execute' method

the SQL for getting the max value will be something like
SELECT max(column_name) FROM table_name

and you can always add a 'where' clause on the end to restrict the search.