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

Reply via email to