Something Like:
SELECT
SomeColum
FROM
d:\xxxx\yyyy\zzz\SomeDatabase.SomeTable
HTH
Dick
At 3:07 PM +0000 3/12/01, Philip Arnold - ASP wrote:
> > Is it true that if you have an ole access ds setup, you can connect to any
>> mdb file on the system?
>> Also, is it possible to do things such as setup default field values etc
>> which arent possible through JET on odbc through OLE???
>
>Actually, as long as the login for CF has the rights, you can connect to any
>mdb on a system via ODBC - you just have to know where it is and the table
>names
>
>I'll dig up the code if you want/need it, it'll just take some time...
>
>I'm honestly not sure about the OLEDB controls vs ODBC JET as I haven't used
>Access as a driver for over a year...
>
>Philip Arnold
>Director
>Certified ColdFusion Developer
>ASP Multimedia Limited
>T: +44 (0)20 8680 1133
>
>"Websites for the real world"
>
>**********************************************************************
>This email and any files transmitted with it are confidential and
>intended solely for the use of the individual or entity to whom they
>are addressed. If you have received this email in error please notify
>the system manager.
>**********************************************************************
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
