RE: Reactor For CF Access help

[Doug Hughes]

Yea, I got that far.  It looks like you can discover the tables, but no data on their columns.    It’s looking like access support isn’t going to happen.  Boo hoo.   Doug   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kurt Wiersma Sent: Sunday, February 19, 2006 2:21 PM To: reactor@doughughes.net Subject: Re: Reactor For CF Access help   I am not an Access export but I once wondering if this was possible for Access and went searching on MS's website. Once thing to try would be to goto Tools > Options then go to the View tab and check the boxes for showing Hidden objects and System objects. Then in the list of tables you should see several system tables which might have the information you need. --Kurt On 2/19/06, Doug Hughes <[EMAIL PROTECTED]> wrote: Hey everyone, I didn't feel like being productive this morning so I decided to try to create an adaptor for Access.  I can get *almost* all the information I need.  Unfortunately, I can't find a way to find out what columns are in an access table nor information such as if it's a PK, autonumbered, Nullable, it's datatype, size or default value.  Anyone have any ideas on how I could get that?  With that, we'd have one more adaptor, albeit a somewhat useless one.   Doug -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/