The DSNless access

[Paul_B]

I am finally working on converting CF 5.x to the latest an greatest... why so
long? Well, it's that darn deprication of dynamic data... I can deal with
select and edit:

<CFQUERY name="checkIt" datasource="dummy1">
SELECT * from Table1
IN 'd:\#context#\data\xyz.mdb'
WHERE...
</CFQUERY>

Works fine as select, edit (assume DELETE is no-brainer)... HOWEVER, anyone
know how to use this with INSERT??? I've tried positioning the IN everywhere it
could even unreasonably fit... no joy.

TIA
Paul

[Mountain Lover]

from the M$ Access Jet SQL Reference:
To identify a destination table:

[SELECT | INSERT] INTO destination IN
{path | ["path" "type"] | ["" [type; DATABASE = path]]}

HTH
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]