Nobody throws a dwarf... ;o)
-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk]
Sent: Tuesday, September 21, 2010 1:26 AM
To: cf-talk
Subject: Re: The solution: (was: Re: Is there a way to force lock release on
Access database? (CF9) )
throwing a dwarf may also help
: (was: Re: Is there a way to force lock release on
Access database? (CF9) )
Nobody throws a dwarf... ;o)
-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk]
Sent: Tuesday, September 21, 2010 1:26 AM
To: cf-talk
Subject: Re: The solution: (was: Re: Is there a way to force
Not in Middle Earth (unless it's necessary in battle :o)
-Original Message-
From: Will Swain [mailto:w...@hothorse.com]
Sent: Tuesday, September 21, 2010 8:39 AM
To: cf-talk
Subject: RE: The solution: (was: Re: Is there a way to force lock release on
Access database? (CF9
, September 19, 2010 11:49 PM
To: cf-talk
Subject: RE: The solution: (was: Re: Is there a way to force lock release on
Access database? (CF9) )
One could always use the Administrator API, and remove that setting from the
admin settings. Whether this lock is changed on the request as easily is
another
Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com]
Sent: Monday, 20 September 2010 2:41 PM
To: cf-talk
Subject: The solution: (was: Re: Is there a way to force lock release on
Access
database? (CF9) )
That would work too, Dave. I think!The second page would contain
Michaels [mailto:r...@michaels.me.uk]
Sent: Monday, September 20, 2010 4:14 PM
To: cf-talk
Subject: Re: The solution: (was: Re: Is there a way to force lock release on
Access database? (CF9) )
Your about the nth person to give that answer Mark.
as I said at the start, that hasn't worked since CF5
: RE: The solution: (was: Re: Is there a way to force lock release
on
Access database? (CF9) )
One could always use the Administrator API, and remove that setting from
the
admin settings. Whether this lock is changed on the request as easily is
another story.
Just a thought
Have you tried intentionally throwing an error?
**runs away**
:-P
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 21 September 2010 05:28, Russ Michaels r...@michaels.me.uk wrote:
don't blame you, its a very long and repetitive thread.
throwing a dwarf may also help
On Tue, Sep 21, 2010 at 6:23 AM, James Holmes james.hol...@gmail.comwrote:
Have you tried intentionally throwing an error?
**runs away**
:-P
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 21 September 2010 05:28, Russ
Lots of people have suggested similar things - cause an error when
running a query on the access database, which will break the lock.
Maureen also suggested deleting the ldb file. That's the file that
creates the lock and it cant be deleted.It gets deleted when the
system lets go of the
Why not have one page that redirects to another using CFLOCATION?
Dave Watts, CTO, Fig Leaf Software
Sent from my Droid
On Sep 19, 2010 9:06 PM, Mike Kear afpwebwo...@gmail.com wrote:
Lots of people have suggested similar things - cause an error when
running a query on the access database,
That would work too, Dave. I think!The second page would contain
the delete functionality? Seems to make sense.
The problem is to force ColdFusion to let go of the datasource
completely before attempting to delete the MDB file. I have found
that using CFThread wont work, because
[mailto:afpwebwo...@gmail.com]
Sent: Monday, 20 September 2010 2:41 PM
To: cf-talk
Subject: The solution: (was: Re: Is there a way to force lock release on
Access
database? (CF9) )
That would work too, Dave. I think!The second page would contain
the delete functionality? Seems to make sense
It's not elegant, but I've found that throwing an error on the
datasource works for releasing them. Try a query against the dsn for a
table that doesn't exist.
Cheers,
Kris
Try deleting the .ldb file.
On Wed, Sep 15, 2010 at 8:58 AM, Mike Kear afpwebwo...@gmail.com wrote:
I have to make an
Try deleting the .ldb file.
On Wed, Sep 15, 2010 at 8:58 AM, Mike Kear afpwebwo...@gmail.com wrote:
I have to make an Access database containing updated data from my
SQLServer database, which can be downloaded by my users by FTP. I
can make the Access database a coldfusion datasource,
.
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com]
Sent: Wednesday, September 15, 2010 11:58 AM
To: cf-talk
Subject: Is there a way to force lock release on Access database? (CF9)
I have to make an Access database containing updated
To: cf-talk
Subject: Is there a way to force lock release on Access database? (CF9)
I have to make an Access database containing updated data from my
SQLServer database, which can be downloaded by my users by FTP.I
can make the Access database a coldfusion datasource, and fill it up
I have to make an Access database containing updated data from my
SQLServer database, which can be downloaded by my users by FTP.I
can make the Access database a coldfusion datasource, and fill it up
with the data I want, but I need to release it from the lock
ColdFusion puts on it. Does
unchecking the maintain database connections in the DSN may work.
If not then try the release all client connections option.
If still no go, just delete the DSN.
--
Russ Michaels
www.cfmldeveloper.com - Supporting the CF community since 1999
FREE ColdFusion/Railo hosting for developers.
blog:
On Wed, Sep 15, 2010 at 12:27 PM, Russ Michaels r...@michaels.me.uk wrote:
unchecking the maintain database connections in the DSN may work.
WE used to do this back in the 90s when I was still using Access
databases for web sites :)
Rick
This has to happen automatically because the process is initiated by
an event when a manager logs on and maintains a record in the product
file. When that happens, it causes the system to generate a new
database for the users around the country to download when they next
log on.So i need to
Subject: Re: Is there a way to force lock release on Access database? (CF9)
On Wed, Sep 15, 2010 at 12:27 PM, Russ Michaels r...@michaels.me.uk wrote:
unchecking the maintain database connections in the DSN may work.
WE used to do this back in the 90s when I was still using Access
databases
. That would break the connection and release the .ldb.
This was years ago though.
Will
-Original Message-
From: Rick Root [mailto:rick.r...@gmail.com]
Sent: 15 September 2010 17:31
To: cf-talk
Subject: Re: Is there a way to force lock release on Access database? (CF9)
On Wed, Sep
Sorry - like I said, it's been a while.
-Original Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com]
Sent: 15 September 2010 18:21
To: cf-talk
Subject: Re: Is there a way to force lock release on Access database? (CF9)
Yes, that's what i used to do too
18:21
To: cf-talk
Subject: Re: Is there a way to force lock release on Access database? (CF9)
Yes, that's what i used to do too, Will. But that was in the CF5
days. With MX that stopped doing the trick.
Cheers
Mike Kear
On Thu, Sep 16, 2010 at 2:39 AM, Will Swain w...@hothorse.com
Mike,
You could use the ColdFusion Admin API to create the datasource on the
fly, do whatever you need to do and then kill the datasource
programatically.
I have a code sample but it'll be another week or so before I can get to it.
you can give it go is all I can suggest. It works sometimes and not others.
If NOT maintaining the database conenctions doesn;t work, then you will need
to programatically deleted and re-create the DSN instead.
--
Russ Michaels
www.cfmldeveloper.com - Supporting the CF community since 1999
27 matches
Mail list logo