This works for SQL Server only. I ran into "these links" while doing my own searches on google and did not find anything that referenced MS Access.
>Making a rapid search I found this link, it could help you > >http://blogs.msdn.com/sqltips/archive/2005/09/16/469136.aspx > >Greetings > >-----Original Message----- >From: John Stottlemire [mailto:[EMAIL PROTECTED] >Sent: Wednesday, April 04, 2007 11:56 PM >To: CF-Talk >Subject: Re: MS Access Primary Key > >Come on, someone has to know how to do this > >> Anyone know of a way to find the Primary Key in a table using CFMX and >> SQL? >> >> I know that queryname.columnlist returns the field names, but I'm >> trying to determine the primary key of the database table as well. >> >> Thanks in advance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274668 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
