Ask a Question related to Coldfusion Database Access, Design and Development.
-
philh #1
Re: unlocking Access databases in CFMX
ColdFusion pools connections. There are timeout settings on the connections.
You have to have ZERO ACTIVITY on the connection pool before it lets the lock
go.
Set an application variable to lock out your app, and wait for the pooled
connection to timeout. I think the default's somewhere in the 1-5 minute range.
Obviously you're not going to be able to FTP over your database while your app
is active. You may want to investigate alternatives to a wholesale overwrite.
Your having to do this makes the application design suspect.
philh Guest
-
unlocking Access databases in CFMX
I have the same issue. I cannot unlock the .mdb file on my shared server. It uses CF7 and I was told and proven to myseld that "Maintain... -
unlocking Access databases in CFMX
I can't believe with as often as this is a problem for me, that it doesn't appear more often in the forum. I search for a solution. I get the same... -
Cannot access databases
When running an ASP.NET, it's not your administrative rights that are considered, but the rights granted to the ASPNET worker process that count.... -
Accessing 2 Access databases on 2 different servers using ASP pages
I have a Access database residing on our 'out-of- house, .com,shared' server. I have an asp page on the .com website that writes to this db,... -
PHP and Access databases
joanne.hall@btinternet.com idiotically stated: goto www.devshed.com and read their php/mysql tutorials. they basically walk you through...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
