Hi, I have a little project that uses the table definitions available from mySQL via a datasource (ie SQL show tables, show columns from {tablename}).
This all works very well. I wanted to be able to run the same project against ms-access datasources and cannot find out how to get the list of tables and column definitions via the datasource. I can do it via VBA directly in ms-access but cant find an SQL way to do it. I know I can migrate to mySQL first but I was hoping to avoid that step. Does anyone know how to get the table schema from ms-access via a datasource ? Thanks, Murray --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---