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.
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: MySQL: Determine Table's Primary Key Dynamically