The documentation in MS access seems quite vague about this area. I want to get a list of tables from an access database to import into our own custom data store. I have fiddled around and have come to the conclusion that this is the query that must be run:
SELECT MSysObjects.* FROM MSysObjects WHERE MSysObjects.Type =1 AND MSysObjects.Flags=0 IN '#accessFilePath#' Can anyone confirm if this is correct? I've tried this on a few various files that I found lying around and have managed to get the same results every time, but you just don't know what may change between versions when it comes to MS products (just getting in on the whole debate here..). And it's undocumented.. Any help is appreciated Joel --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---