|
|
On Jan 29, 7:58 pm, "steppoff-donegal" <stephen.p...@xxxxxxxxxxxxxx>
wrote:
> Running CFMX7, IIS6 on Win2k3. Using <unfortunately> multiple Ms-Access 2000
> mdbs. One application in particular is erroring out constantly. I have
> "maintain connections" unchecked. Line 86 is the location of the update
> query.
> The update query DOES NOT use CFUPDATE...it uses CFQUERY with update
> statement
> inside.
>
> "Error","jrpp-135","01/29/08","14:02:50",,"Error Executing Database
> Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
> Microsoft Access Driver] Could not update; currently locked by user 'admin' on
> machine 'mymachinename'. The specific sequence of files included or processed
> is: D:\Websites\thiswebsite\wwwroot\WebApps\subfolder\subfolder2\results.cfm,
> line: 86 "
Check that you DO NOT have your db open in "view table structure" mode
in MS Access...
BTW: I hope you are NOT using admin DB account to work with DB via CF.
|
|