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
-~----------~----~----~----~------~----~------~--~---

Reply via email to