Damn good point. Maybe the Flush.cfm file is the way to go.
Dru
At 14:05 10/5/2000 -0400, Pete Freitag wrote:
>Not maintaining database connections may solve the problem, but it may
>affect performance. Say you have three queries to the same datasource on
>the same page (not uncommon), then CF will release the connection, and
>reconnect for each query. Imagine simultaneous accesses, and you've slowed
>down your server quite a bit. On a development server this may be
>acceptable, but don't do this on a production server.
>
>-----Original Message-----
>From: Shawnea Carter [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, October 05, 2000 1:19 PM
>To: CF-Talk
>Subject: RE: Death to .ldb !!!
>
>
>I believe that when you are setting up the DSN if you DO NOT click maintain
>database connections this eliminates the problem.
>
>Shawnea
>
>-----Original Message-----
>From: Dru Whitledge [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, October 05, 2000 12:34 PM
>To: CF-Talk
>Subject: Death to .ldb !!!
>
>
>If anyone else is working with MS Access you've probably had the same
>annoying experience!!
>
>I often have to swap backed up databases (.mdb files) and if I've been
>using the old database that I want to copy over -- there is always a damn
>.ldb (file / record locking file) in the directory that prevents me from
>overwriting the old database.
>
>I know how to cure this problem on the web (make a dummy query to a
>nonexistent table in the same database) but that technique doe not seem to
>work on my hard drive? I usually end up, annoyed as hell, having to re-boot
>to be able to delete the damn thing off.
>
>Does anybody know of a simpler way to dispatch this pesky little .ldb file
>-- without rebooting?
>
>Thanks,
>
>Dru
>----------------------------------------------------------------------------
>--
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>----------------------------------------------------------------------------
>--
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
