Use ADOX or ADOX and ADODB to query and edit data

Question

I am trying to figure out how to use ADO and ADODB to get data and view it while also being able to determine the PK so that I can alter data.

My plan is to use ADODB to display some data to an end user in Excel, if the user wants to edit the data there will be a macro monitoring cell changes and then sending the change to the database. I need a way to use ADOX to find the keys and alter the data unless I can use ADOX to query and alter the data all in one.

I have experience working with ADODB to communicate with a MySQL database and I know that ADOX can show you keys for database tables and also allows you to easily change the database structures. I can't seem to find anything with regards to what I am trying to do.

Answer 1

I don't know how much support adox has for mysql. I think it is highly dependent on the driver you are using.

You may be able to query the mysql metadata to locate the primary key info via adodb. see this q for syntax: http://stackoverflow.com/questions/893874/mysql-determine-tables-primary-key-dynamically