I had a similar (well, sort of) problem that I needed to overcome. Create an Access DSN, something like sampleDbDSN. You'll need to have a "copy" of the database in that location. This file will reside in a fixed location, i.e. c:\inetpub\wwwroot\myapp\data\sampledb.mdb This will be the "target" database.
Have a "source" Access DSN that contains your empty-of-data-but-has-your-tables database in another path, i.e. c:\inetpub\wwwroot\myapp\data\source\sampledb.mdb Your CF script will run a "bad" query against sampleDbDSN, which will "break" the Access lock and allow another file to be copied over it. Then run a cffile operation to copy your \myapp\data\source\sampledb.mdb file over to your \myapp\data\sampledb.mdb file. Then, run your data import script to populate the \data\sampledb.mdb file You'll want to figure out some way to "lock" the MDB file when it's being imported into. Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268582 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
