Re: Reactor For CF Access help

[Kurt Wiersma]

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/