Have you encountered such a situation whereby a "Permission Denied"
error occurs whenever you try to overwrite a datasource file with an
updated copy?

Many others are encountering the same problem. This is due to the Jet
Engine locking mechanism which Webvisions runs on all NT servers. Its
main purpose is to prevent your datasources from corruption resulting
from simultaneous overwriting of your file and when visitors are trying
to access it.

You can break the lock by executing an invalid query against the database

(<cfquery name='breaklock' datasource='datasourcename'
sql='select __invalid__ from __invalid__'>)

*Need to refresh all of your application variables? In the CFAPPLICATION
tag, set the
applicationtimeout=0. cfapplication name="CaesarsPalate"
applicationtimeout="#createtimespan(0,0,0,0)#"

This can also be done with Session variables.

cfapplication name="CaesarsPalate" sessionmanagement="Yes"
sessiontimeout="#createtimespan(0,0,0,0)#"

*To insert multiple records during one process, use a loop over an insert
query. As an example forms automatically create comma separated lists if
more than one
field has the same name. Someone checks off all the products they want to
buy in the product list checkbox area of a form (each checkbox has the
name
'productlist'). It is submitted and this is run on the next page.

cfloop index="CurrentProduct" list="ProductList"

cfquery name="AddToProductList" datasouce="whatever"

Insert Into #PurchaseTable

(PurahaseID, ProductName, DateEntered)

Values ('url.PurchaseID#', '#currentProduct#', #now()#)

/cfquery

/cfloop