[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
Printable View
[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
[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.
