Access database getting hosed up on web server

[CRC]

I have had this problem consistently ever since I upgraded to Dreamweaver 8.
The problem is I am creating/modifying coldfusion pages on my intranet site
which has both .ASP and .CFM files and eventually none of the .ASP files will
work. And I know it is has to do with Access database lock file and I cannot
delete it because it says it is in use. I understand that if you are in the
actual database it will create a lock file and it will eventually hang up, but
I am not in the database file when this happens. I might be creating
recordsets but that is it. I downloaded a microsoft jet utility that shows who
is actively in the database and when this happens it shows the webserver is
connected to the database. The only way to clear the access lock file is to
reboot. Any ideas?

[philh]

Uncheck "Maintain database connections" in your administrator. I think. Used to be you could issue a bad query and break the lock, but that doesn't work anymore.

[mxstu]

>Used to be you could issue a bad query and break the lock, but that doesn't work anymore

Out of curiousity, any ideas why it doesn't work any more?

[mxstu]

In the CF Administrator > Data & Services > Datasources > (select your
datasource to edit)

1. Click "Show Advanced Settings" button
2. Uncheck "Maintain Connections" box
3. Click Submit to save the changes

[CRC]

it was never checked, but there is a
Timeout (min) that has 20
AND Interval (min) 7








Disable Connections
-- Suspend all client connections.

Login Timeout (sec)

CLOB
-- Enable long text retrieval (CLOB).

BLOB
-- Enable binary large object retrieval (BLOB).

Long Text Buffer (chr)

Blob Buffer(bytes)

Allowed SQL
SELECT Create GRANT
INSERT DROP REVOKE
UPDATE ALTER Stored Procedures
DELETE

[CRC]

I am not sure, but it has consistently happened since I upgraded to Dreamweaver 8

[mxstu]

Are you using client variables? I don't use DW8, but you might want to check
the issues list
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=a3f38dcf[/url]

... or the DW forums to see if there is any mention of this problem ...
[url]http://www.macromedia.com/cfusion/webforums/forum/index.cfm?forumid=12[/url]

Btw, your forums IM option is turned "off" :-) You can change the settings
under
Profiles --> Personal Options --> Receive Private Messages

[mxstu]

philh - you've got IM turned off too ;-)