Re: The state of Statlessness

[Byron Mann]

Very curious to know what the scenario is for this requirement.

Byron Mann
Lead Engineer & Architect
HostMySite.com
On Jul 3, 2014 12:38 PM, "UXB"  wrote:

>
> I have always know and understood the underlying technology of the web in
> that it is a stateless medium.  For the past decade I have been designing
> web apps knowing that because it is stateless you can never trust the
> client
> condition or the data being sent from them.  So with that in mind I find
> myself struggling with a methodology to determine if a single CF session
> has
> opened a particular web page in two or more browser windows.
>
> Has anyone come up with a way to make this determination?  The solution
> does
> not need to be bullet proof just best try. I am trying to prevent or warn a
> user from visiting a page he already has open and running/displayed in a
> separate browser window.
>
>
>
> Ps: where is everyone? On vacation? I have only received 8 messages from
> this list since the 1st of the month.
>
>
> Dennis Powers
> UXB Internet - A website Design and Hosting Company
> P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844
> W: http://www.uxbinternet.com
> W: http://www.ctbusinesslist.com
>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358816
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Dave Watts]

> >But transfer the data to an actual database
>
> I was expecting this clever answer! ;-)
> Access has a bad reputation in a LAN multiuser APPLICATION.
> But it is only when the application is also an Access application.
> All requests cause many accesses to the disk, both for code and for data, 
> which causes a bottleneck.
> In a coldFusion application, the application is NOT stored in the same file 
> as the database,
> and there is only ONE user: Coldfusion is the user.

While there is only one user account, there are potentially many
connections, so the fact that it's only one user is irrelevant - you
still have concurrency issues. You also have other problems, such as
the inability of Access to perform routine table maintenance while the
database is being used by CF. For example, the space originally
allocated for records isn't reclaimed properly when the records are
deleted.

Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358815
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: barcodes, cuecats, reverse engineering - semi OT

[leona lewis]

http://www.keepautomation.com/products/net_barcode_reader/

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358814
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: barcodes, cuecats, reverse engineering - semi OT

[leona lewis]

read barcodes with .net
http://www.keepautomation.com/products/net_barcode_reader/

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358813
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: File Upload with Chunk Method

[UXB]

>> I am trying to implement a file upload utilizing Plupload and its chunk
methodology 

>> I can't seem to solve for when the user opens a new browser window and
proceeds 
>> to upload the same file OR file with the same name as is already
uploading.  

Just in case anyone might find this of interest I finally found a way,
thanks to Maureen in another thread, to attach a UUID or unique file ID to
the multipart upload form fields in the Plupload jQuery uploader queue
widget implementation.  Thanks to an article I found by Ben Nadel
(http://www.bennadel.com/blog/2506-storing-per-file-multipart-params-in-the-
plupload-queue.htm) 
I was able to hook into the widget events and inject new multi-part
parameters for each file in the queue and then write them on the server
using the UUID as a file name, check to see if another file of the same name
exists and re-name the new file with an incremented file name.

Here is the JS for the PLupload queue widget: (note the uuid(); function
script is in my other post)

// Retrieving a reference to plupload.Uploader object
var uploader = $('#uploader').pluploadQueue();
uploader.bind('BeforeUpload', function(up) {
 up.settings.multipart_params.fileuuid = uuid();
});

And on the server side:






















This will NOT work with the Jquery UI widget implementation since they don't
seem to (easily) expose the events needed like 'BeforeUpload'.

I hope this helps someone.



Dennis Powers
UXB Internet - A website Design and Hosting Company
P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844
W: http://www.uxbinternet.com
W: http://www.ctbusinesslist.com


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358812
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: The state of Statlessness

[UXB]

>> Try this:
>> https://sites.google.com/site/sarittechworld/track-client-windows

>> > I am trying 
>> > to prevent or warn a user from visiting a page he already has open and 
>> > running/displayed in a separate browser window.

Thanks Maureen, It got me steered in the right direction.  I am not an
expert on (anything?) JavaScript so I was unaware that modern browsers now
have a window.name object that will be blank until set.  With that knowledge
and the fact that I am trying to protect the user from himself and the
functionality requires JavaScript it was much easier than I expected.  With
some "appropriated code" I was able to set it for use in the other functions
(Plupload) to send back form data to the server with a suitable UUID for
tracking at the server level.

Like so:

var guid = uuid();
 function uuid()
{
   var chars = '0123456789abcdef'.split('');
   var uuid = [], rnd = Math.random, r;
   uuid[8] = uuid[13] = uuid[18] = uuid[23] = '-';
   uuid[14] = '4'; // version 4
   for (var i = 0; i < 36; i++)
   {
  if (!uuid[i])
  {
r = 0 | rnd()*16;
uuid[i] = chars[(i == 19) ? (r & 0x3) | 0x8 : r & 0xf];
  }
   }
   return uuid.join('');
}

$(document).ready(function(){

//-- guarantees that window.name is a GUID, and that it would
//-- be preserved whilst this window's life is open
window.name = guid; 

//-- do all the other stuff here

// end of document ready function   
});


Now I could access the window.name in other scripting functions for a
"unique" ID for the page that the server could track.



Dennis Powers
UXB Internet - A website Design and Hosting Company
P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844
W: http://www.uxbinternet.com
W: http://www.ctbusinesslist.com




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358811
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Bryan Stevenson]

Have a good 4th! ...from Canada ;-)

*Bryan Stevenson*B.Comm.
President & CEO
Electric Edge Systems Group Inc. - makers of FACTS^(TM)
phone: 250.480.0642
cell: 250.920.8830
e-mail: br...@electricedgesystems.com 
web: www.electricedgesystems.com  
and www.fisheryfacts.com 



Please consider the environment before printing this e-mail

-CONFIDENTIALITY--
This message, including any attachments, is confidential and may contain 
information that is privileged or exempt from disclosure. It is intended 
only for the person to whom it is addressed unless expressly authorized 
otherwise by the sender. If you are not an authorized recipient, please 
notify the sender immediately and permanently destroy all copies of this 
message and attachments.
On 14-07-03 02:58 PM, Ben Conner wrote:
> Thanks, guys!  I knew I would get the full picture here and wasn't 
> disappointed.
>
> Best wishes and Hope you have a great 4th of July!
>
> --Ben
>



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358810
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Ben Conner]

Thanks, guys!  I knew I would get the full picture here and wasn't disappointed.

Best wishes and Hope you have a great 4th of July!

--Ben

-- 
Ben Conner  b...@webworldinc.com
Web World, Inc. 888-206-6486 or
PO Box 1122 480-704-2000
Queen Creek, AZ 85142



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358809
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Locks on Access files in CF 9

[UXB]

>> I'm seeing an odd issue where a .lck file doesn't go away at times on an 
>> Access DB file in CF >> 9 in a Windows 2008 environment. When this
happens, 
>> I also can't restart the CF ODBC Server. 
>> Restarting the box itself is the only solution. 


The way we use to release a lock on an access DB file was to run a bad query
against the data source.  Add an extra field name not in the table to a
select statement.  This lets the Jet driver release the file until a new
query is initiated.

>> This isn't a heavily trafficked site. 

Good thing or you would never be able to release the lock.   I am sure it
goes without saying, but yet I am saying it, but Access is not the best
solution for multi-user environments.  However, I understand that the best
solutions may not always be and option.


Dennis Powers
UXB Internet - A website Design and Hosting Company
P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844
W: http://www.uxbinternet.com
W: http://www.ctbusinesslist.com



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358808
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Russ Michaels]

You like have a hung request which is maintaining a connection to the db.
Use the server monitor to check.
Only solution for this is to restart cf.

Russ Michaels
www.michaels.me.uk
cfmldeveloper.com
cflive.net
cfsearch.com
On 3 Jul 2014 20:06, "Maureen"  wrote:

>
> Access is actually not bad as a user interface.  When I have clients
> who are using it, I migrate the data to production level database then
> use the Access link table function to allow them to continue to use
> the interface without needing to recreate it in another tool, or
> retrain them for a different interface.  The works especially well for
> existing projects with lots of reports.
>
>
> On Thu, Jul 3, 2014 at 2:53 PM, Scott Stewart 
> wrote:
> >
> > bottom line: Access sucks unless your inventorying a CD collection.
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358807
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Maureen]

Access is actually not bad as a user interface.  When I have clients
who are using it, I migrate the data to production level database then
use the Access link table function to allow them to continue to use
the interface without needing to recreate it in another tool, or
retrain them for a different interface.  The works especially well for
existing projects with lots of reports.


On Thu, Jul 3, 2014 at 2:53 PM, Scott Stewart  wrote:
>
> bottom line: Access sucks unless your inventorying a CD collection.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358806
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Scott Stewart]

bottom line: Access sucks unless your inventorying a CD collection.


On Thu, Jul 3, 2014 at 2:49 PM, <> wrote:

>
>  >>But transfer the data to an actual database
>
> I was expecting this clever answer! ;-)
> Access has a bad reputation in a LAN multiuser APPLICATION.
> But it is only when the application is also an Access application.
> All requests cause many accesses to the disk, both for code and for data,
> which causes a bottleneck.
> In a coldFusion application, the application is NOT stored in the same
> file as the database,
> and there is only ONE user: Coldfusion is the user.
>
> I've noticed that since I have my database installed on Windows 7, locks
> are even more capricious than before if you open the database in the same
> time you run a CF application, and this does not come from Access.
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358805
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Claude Schnéegans]

 >>But transfer the data to an actual database

I was expecting this clever answer! ;-)
Access has a bad reputation in a LAN multiuser APPLICATION.
But it is only when the application is also an Access application.
All requests cause many accesses to the disk, both for code and for data, which 
causes a bottleneck.
In a coldFusion application, the application is NOT stored in the same file as 
the database,
and there is only ONE user: Coldfusion is the user.

I've noticed that since I have my database installed on Windows 7, locks are 
even more capricious than before if you open the database in the same time you 
run a CF application, and this does not come from Access.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358804
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Scott Stewart]

Access was never designed to be a multiuser DB. The .lck file just grows as
more connections are made. It will eventually kill the box it it's left
alone long enough



On Thu, Jul 3, 2014 at 2:32 PM, Ben  wrote:

>
> Interesting. Probably more work than I want to out in unless needed.
>
> Anyone know why the lck file gets sticky?  CF issue? ODBC issue in
> Windows?  Just curious
>
> Ben
>
> > On Jul 3, 2014, at 11:15 AM, Scott Stewart 
> wrote:
> >
> >
> > You *could* put a system together where the client, or you uploads the
> > access database, the system programatically creates a datasource on the
> fly
> > transfers any data changes to the real database, kills the datasource and
> > deletes the access db, the client can do what he wants and you don't have
> > to deal with access lock file issues.
> >
> >
> >> On Thu, Jul 3, 2014 at 2:06 PM, Ben  wrote:
> >>
> >>
> >> Yeah, you're preaching to the choir on that one. :)
> >>
> >> This client tweaks their copy of the DB with local apps then uploads it
> to
> >> the server.
> >>
> >> Ben
> >>
>  On Jul 3, 2014, at 10:59 AM, Phillip Vector <
> vec...@mostdeadlygame.com>
> >>> wrote:
> >>>
> >>>
> >>> Not to be "That Guy"... But transfer the data to an actual database and
> >> use
> >>> that?
> >>>
> >>>
>  On Thu, Jul 3, 2014 at 10:53 AM, Ben  wrote:
> 
> 
>  Sorry, didn't mention that. It is off.
> 
>  Ben
> 
> >> On Jul 3, 2014, at 10:51 AM, Scott Stewart <
> webmas...@sstwebworks.com
> >>>
> > wrote:
> >
> >
> > Turn off maintain connections in the data source properties.
> >> On Jul 3, 2014 1:49 PM, "Ben"  wrote:
> >>
> >>
> >> Hi
> >>
> >> I'm seeing an odd issue where a .lck file doesn't go away at times
> on
> >> an
> >> Access DB file in CF 9 in a Windows 2008 environment. When this
>  happens, I
> >> also can't restart the CF ODBC Server. Restarting the box itself is
> >> the
> >> only solution. This isn't a heavily trafficked site.
> >>
> >> Anyone have any ideas what might be causing this and/or a
> work-around?
> >>
> >> Thanks!
> >>
> >> Ben
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358803
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Locks on Access files in CF 9

[DURETTE, STEVEN J]

It's Access. Need we say more? (hehe)

Actually I believe it has something to do with a combination of ODBC and 
Windows and the JET drivers. Other ODBC connections don't seem to lock that way 
but if you look really hard with google you can find a tool that will list the 
locks and what is holding them and another tool (in the same package) that lets 
you kill them, however the caveat I read years ago was that after doing that 
you immediately needed to run a clean and repair on the Access DB.


Steven Durette

-Original Message-
From: Ben [mailto:b...@webworldinc.com] 
Sent: Thursday, July 03, 2014 2:32 PM
To: cf-talk
Subject: Re: Locks on Access files in CF 9


Interesting. Probably more work than I want to out in unless needed. 

Anyone know why the lck file gets sticky?  CF issue? ODBC issue in Windows?  
Just curious

Ben

> On Jul 3, 2014, at 11:15 AM, Scott Stewart  wrote:
> 
> 
> You *could* put a system together where the client, or you uploads the
> access database, the system programatically creates a datasource on the fly
> transfers any data changes to the real database, kills the datasource and
> deletes the access db, the client can do what he wants and you don't have
> to deal with access lock file issues.
> 
> 
>> On Thu, Jul 3, 2014 at 2:06 PM, Ben  wrote:
>> 
>> 
>> Yeah, you're preaching to the choir on that one. :)
>> 
>> This client tweaks their copy of the DB with local apps then uploads it to
>> the server.
>> 
>> Ben
>> 
 On Jul 3, 2014, at 10:59 AM, Phillip Vector 
>>> wrote:
>>> 
>>> 
>>> Not to be "That Guy"... But transfer the data to an actual database and
>> use
>>> that?
>>> 
>>> 
 On Thu, Jul 3, 2014 at 10:53 AM, Ben  wrote:
 
 
 Sorry, didn't mention that. It is off.
 
 Ben
 
>> On Jul 3, 2014, at 10:51 AM, Scott Stewart >> 
> wrote:
> 
> 
> Turn off maintain connections in the data source properties.
>> On Jul 3, 2014 1:49 PM, "Ben"  wrote:
>> 
>> 
>> Hi
>> 
>> I'm seeing an odd issue where a .lck file doesn't go away at times on
>> an
>> Access DB file in CF 9 in a Windows 2008 environment. When this
 happens, I
>> also can't restart the CF ODBC Server. Restarting the box itself is
>> the
>> only solution. This isn't a heavily trafficked site.
>> 
>> Anyone have any ideas what might be causing this and/or a work-around?
>> 
>> Thanks!
>> 
>> Ben
> 
> 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358802
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Ben]

Interesting. Probably more work than I want to out in unless needed. 

Anyone know why the lck file gets sticky?  CF issue? ODBC issue in Windows?  
Just curious

Ben

> On Jul 3, 2014, at 11:15 AM, Scott Stewart  wrote:
> 
> 
> You *could* put a system together where the client, or you uploads the
> access database, the system programatically creates a datasource on the fly
> transfers any data changes to the real database, kills the datasource and
> deletes the access db, the client can do what he wants and you don't have
> to deal with access lock file issues.
> 
> 
>> On Thu, Jul 3, 2014 at 2:06 PM, Ben  wrote:
>> 
>> 
>> Yeah, you're preaching to the choir on that one. :)
>> 
>> This client tweaks their copy of the DB with local apps then uploads it to
>> the server.
>> 
>> Ben
>> 
 On Jul 3, 2014, at 10:59 AM, Phillip Vector 
>>> wrote:
>>> 
>>> 
>>> Not to be "That Guy"... But transfer the data to an actual database and
>> use
>>> that?
>>> 
>>> 
 On Thu, Jul 3, 2014 at 10:53 AM, Ben  wrote:
 
 
 Sorry, didn't mention that. It is off.
 
 Ben
 
>> On Jul 3, 2014, at 10:51 AM, Scott Stewart >> 
> wrote:
> 
> 
> Turn off maintain connections in the data source properties.
>> On Jul 3, 2014 1:49 PM, "Ben"  wrote:
>> 
>> 
>> Hi
>> 
>> I'm seeing an odd issue where a .lck file doesn't go away at times on
>> an
>> Access DB file in CF 9 in a Windows 2008 environment. When this
 happens, I
>> also can't restart the CF ODBC Server. Restarting the box itself is
>> the
>> only solution. This isn't a heavily trafficked site.
>> 
>> Anyone have any ideas what might be causing this and/or a work-around?
>> 
>> Thanks!
>> 
>> Ben
> 
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358801
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Jon Clausen]

What Scott said (the ideal method), or you need to write an “deploy database” 
script that completely stops the site in IIS, waits for the .lck file to 
disappear and then replaces the db and restarts the site (I’m assuming you’re 
on IIS).  Even if the “maintain database connections” is off, the only safe and 
reliable way I’ve found to deal with .lck files when replacing Access databases 
is to completely stop the site and wait for it to go away.  You could remove 
them in Windows with Administrator permissions, but even that is iffy as 
sometimes you can end up totally locking up the directory.

Jon

On Jul 3, 2014, at 2:15 PM, Scott Stewart  wrote:

> 
> You *could* put a system together where the client, or you uploads the
> access database, the system programatically creates a datasource on the fly
> transfers any data changes to the real database, kills the datasource and
> deletes the access db, the client can do what he wants and you don't have
> to deal with access lock file issues.
> 
> 
> On Thu, Jul 3, 2014 at 2:06 PM, Ben  wrote:
> 
>> 
>> Yeah, you're preaching to the choir on that one. :)
>> 
>> This client tweaks their copy of the DB with local apps then uploads it to
>> the server.
>> 
>> Ben
>> 
>>> On Jul 3, 2014, at 10:59 AM, Phillip Vector 
>> wrote:
>>> 
>>> 
>>> Not to be "That Guy"... But transfer the data to an actual database and
>> use
>>> that?
>>> 
>>> 
 On Thu, Jul 3, 2014 at 10:53 AM, Ben  wrote:
 
 
 Sorry, didn't mention that. It is off.
 
 Ben
 
>> On Jul 3, 2014, at 10:51 AM, Scott Stewart >> 
> wrote:
> 
> 
> Turn off maintain connections in the data source properties.
>> On Jul 3, 2014 1:49 PM, "Ben"  wrote:
>> 
>> 
>> Hi
>> 
>> I'm seeing an odd issue where a .lck file doesn't go away at times on
>> an
>> Access DB file in CF 9 in a Windows 2008 environment. When this
 happens, I
>> also can't restart the CF ODBC Server. Restarting the box itself is
>> the
>> only solution. This isn't a heavily trafficked site.
>> 
>> Anyone have any ideas what might be causing this and/or a work-around?
>> 
>> Thanks!
>> 
>> Ben
>>> 
>>> 
>> 
>> 
> 
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358800
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Ben]

Yep. 

So is the site. So 1995. But they are rewriting it in one of the newer 
languages-du-jour which will solve ALL their problems. :)

Ben

> On Jul 3, 2014, at 11:10 AM, Bryan Stevenson  
> wrote:
> 
> 
>> On 14-07-03 11:06 AM, Ben wrote:
>> Yeah, you're preaching to the choir on that one. :)
>> 
>> This client tweaks their copy of the DB with local apps then uploads it to 
>> the server.
>> 
>> Ben
> Ugh...that is horrible! ;-)
> 
> 
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358798
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Scott Stewart]

You *could* put a system together where the client, or you uploads the
access database, the system programatically creates a datasource on the fly
transfers any data changes to the real database, kills the datasource and
deletes the access db, the client can do what he wants and you don't have
to deal with access lock file issues.


On Thu, Jul 3, 2014 at 2:06 PM, Ben  wrote:

>
> Yeah, you're preaching to the choir on that one. :)
>
> This client tweaks their copy of the DB with local apps then uploads it to
> the server.
>
> Ben
>
> > On Jul 3, 2014, at 10:59 AM, Phillip Vector 
> wrote:
> >
> >
> > Not to be "That Guy"... But transfer the data to an actual database and
> use
> > that?
> >
> >
> >> On Thu, Jul 3, 2014 at 10:53 AM, Ben  wrote:
> >>
> >>
> >> Sorry, didn't mention that. It is off.
> >>
> >> Ben
> >>
>  On Jul 3, 2014, at 10:51 AM, Scott Stewart  >
> >>> wrote:
> >>>
> >>>
> >>> Turn off maintain connections in the data source properties.
>  On Jul 3, 2014 1:49 PM, "Ben"  wrote:
> 
> 
>  Hi
> 
>  I'm seeing an odd issue where a .lck file doesn't go away at times on
> an
>  Access DB file in CF 9 in a Windows 2008 environment. When this
> >> happens, I
>  also can't restart the CF ODBC Server. Restarting the box itself is
> the
>  only solution. This isn't a heavily trafficked site.
> 
>  Anyone have any ideas what might be causing this and/or a work-around?
> 
>  Thanks!
> 
>  Ben
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358799
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Bryan Stevenson]

On 14-07-03 11:06 AM, Ben wrote:
> Yeah, you're preaching to the choir on that one. :)
>
> This client tweaks their copy of the DB with local apps then uploads it to 
> the server.
>
> Ben
Ugh...that is horrible! ;-)


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358797
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Ben]

Oh. That's clever. Even devious. 
Will try it. Thanks!

Ben

> On Jul 3, 2014, at 11:04 AM, Bryan Stevenson  
> wrote:
> 
> 
> Try running a bad query against the datasource (whip up a CFM file call 
> "LockKill.cfm" and stuff a CFQUERY in it - run in browser
> 
> "SELECT gum FROM Pack_of_Gum" should do the trick ;-)
> 
> This was the old school way to get Access to let go
> 
> Run the query and then refresh the folder with your DB file in in and 
> the lock file "should" go way
> 
> If not...try a  few more times as sometimes it would take a couple of 
> attempts
> 
> HTH
> 
> Cheers
> 
> *Bryan Stevenson*B.Comm.
> President & CEO
> Electric Edge Systems Group Inc. - makers of FACTS^(TM)
> phone: 250.480.0642
> cell: 250.920.8830
> e-mail: br...@electricedgesystems.com 
> web: www.electricedgesystems.com  
> and www.fisheryfacts.com 
> 
> 
> 
> Please consider the environment before printing this e-mail
> 
> -CONFIDENTIALITY--
> This message, including any attachments, is confidential and may contain 
> information that is privileged or exempt from disclosure. It is intended 
> only for the person to whom it is addressed unless expressly authorized 
> otherwise by the sender. If you are not an authorized recipient, please 
> notify the sender immediately and permanently destroy all copies of this 
> message and attachments.
> 
> 
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358796
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Ben]

Yeah, you're preaching to the choir on that one. :)

This client tweaks their copy of the DB with local apps then uploads it to the 
server. 

Ben

> On Jul 3, 2014, at 10:59 AM, Phillip Vector  wrote:
> 
> 
> Not to be "That Guy"... But transfer the data to an actual database and use
> that?
> 
> 
>> On Thu, Jul 3, 2014 at 10:53 AM, Ben  wrote:
>> 
>> 
>> Sorry, didn't mention that. It is off.
>> 
>> Ben
>> 
 On Jul 3, 2014, at 10:51 AM, Scott Stewart 
>>> wrote:
>>> 
>>> 
>>> Turn off maintain connections in the data source properties.
 On Jul 3, 2014 1:49 PM, "Ben"  wrote:
 
 
 Hi
 
 I'm seeing an odd issue where a .lck file doesn't go away at times on an
 Access DB file in CF 9 in a Windows 2008 environment. When this
>> happens, I
 also can't restart the CF ODBC Server. Restarting the box itself is the
 only solution. This isn't a heavily trafficked site.
 
 Anyone have any ideas what might be causing this and/or a work-around?
 
 Thanks!
 
 Ben
> 
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358795
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Bryan Stevenson]

...and now you are "That Guy" Phillip ;-)

I agree wholeheartedly, but thought I'd try and provide help for the 
actual issue that is in Ben's face at the moment.

Cheers

*Bryan Stevenson*B.Comm.
President & CEO
Electric Edge Systems Group Inc. - makers of FACTS^(TM)
phone: 250.480.0642
cell: 250.920.8830
e-mail: br...@electricedgesystems.com 
web: www.electricedgesystems.com  
and www.fisheryfacts.com 



Please consider the environment before printing this e-mail

-CONFIDENTIALITY--
This message, including any attachments, is confidential and may contain 
information that is privileged or exempt from disclosure. It is intended 
only for the person to whom it is addressed unless expressly authorized 
otherwise by the sender. If you are not an authorized recipient, please 
notify the sender immediately and permanently destroy all copies of this 
message and attachments.
On 14-07-03 10:59 AM, Phillip Vector wrote:
> Not to be "That Guy"... But transfer the data to an actual database and use
> that?
>
>
> On Thu, Jul 3, 2014 at 10:53 AM, Ben  wrote:



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358794
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Bryan Stevenson]

Try running a bad query against the datasource (whip up a CFM file call 
"LockKill.cfm" and stuff a CFQUERY in it - run in browser

"SELECT gum FROM Pack_of_Gum" should do the trick ;-)

This was the old school way to get Access to let go

Run the query and then refresh the folder with your DB file in in and 
the lock file "should" go way

If not...try a  few more times as sometimes it would take a couple of 
attempts

HTH

Cheers

*Bryan Stevenson*B.Comm.
President & CEO
Electric Edge Systems Group Inc. - makers of FACTS^(TM)
phone: 250.480.0642
cell: 250.920.8830
e-mail: br...@electricedgesystems.com 
web: www.electricedgesystems.com  
and www.fisheryfacts.com 



Please consider the environment before printing this e-mail

-CONFIDENTIALITY--
This message, including any attachments, is confidential and may contain 
information that is privileged or exempt from disclosure. It is intended 
only for the person to whom it is addressed unless expressly authorized 
otherwise by the sender. If you are not an authorized recipient, please 
notify the sender immediately and permanently destroy all copies of this 
message and attachments.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358793
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Phillip Vector]

Not to be "That Guy"... But transfer the data to an actual database and use
that?


On Thu, Jul 3, 2014 at 10:53 AM, Ben  wrote:

>
> Sorry, didn't mention that. It is off.
>
> Ben
>
> > On Jul 3, 2014, at 10:51 AM, Scott Stewart 
> wrote:
> >
> >
> > Turn off maintain connections in the data source properties.
> >> On Jul 3, 2014 1:49 PM, "Ben"  wrote:
> >>
> >>
> >> Hi
> >>
> >> I'm seeing an odd issue where a .lck file doesn't go away at times on an
> >> Access DB file in CF 9 in a Windows 2008 environment. When this
> happens, I
> >> also can't restart the CF ODBC Server. Restarting the box itself is the
> >> only solution. This isn't a heavily trafficked site.
> >>
> >> Anyone have any ideas what might be causing this and/or a work-around?
> >>
> >> Thanks!
> >>
> >> Ben
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358792
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Ben]

Sorry, didn't mention that. It is off. 

Ben

> On Jul 3, 2014, at 10:51 AM, Scott Stewart  wrote:
> 
> 
> Turn off maintain connections in the data source properties.
>> On Jul 3, 2014 1:49 PM, "Ben"  wrote:
>> 
>> 
>> Hi
>> 
>> I'm seeing an odd issue where a .lck file doesn't go away at times on an
>> Access DB file in CF 9 in a Windows 2008 environment. When this happens, I
>> also can't restart the CF ODBC Server. Restarting the box itself is the
>> only solution. This isn't a heavily trafficked site.
>> 
>> Anyone have any ideas what might be causing this and/or a work-around?
>> 
>> Thanks!
>> 
>> Ben
> 
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358791
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Locks on Access files in CF 9

[Scott Stewart]

Turn off maintain connections in the data source properties.
On Jul 3, 2014 1:49 PM, "Ben"  wrote:

>
> Hi
>
> I'm seeing an odd issue where a .lck file doesn't go away at times on an
> Access DB file in CF 9 in a Windows 2008 environment. When this happens, I
> also can't restart the CF ODBC Server. Restarting the box itself is the
> only solution. This isn't a heavily trafficked site.
>
> Anyone have any ideas what might be causing this and/or a work-around?
>
> Thanks!
>
> Ben
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358790
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Locks on Access files in CF 9

[Ben]

Hi

I'm seeing an odd issue where a .lck file doesn't go away at times on an Access 
DB file in CF 9 in a Windows 2008 environment. When this happens, I also can't 
restart the CF ODBC Server. Restarting the box itself is the only solution. 
This isn't a heavily trafficked site. 

Anyone have any ideas what might be causing this and/or a work-around?

Thanks!

Ben

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358789
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: The state of Statlessness

[Maureen]

Try this:
https://sites.google.com/site/sarittechworld/track-client-windows

On Thu, Jul 3, 2014 at 12:36 PM, UXB  wrote:
>
>
> Has anyone come up with a way to make this determination?  The solution does
> not need to be bullet proof just best try. I am trying to prevent or warn a
> user from visiting a page he already has open and running/displayed in a
> separate browser window.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358788
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

The state of Statlessness

[UXB]

I have always know and understood the underlying technology of the web in
that it is a stateless medium.  For the past decade I have been designing
web apps knowing that because it is stateless you can never trust the client
condition or the data being sent from them.  So with that in mind I find
myself struggling with a methodology to determine if a single CF session has
opened a particular web page in two or more browser windows.

Has anyone come up with a way to make this determination?  The solution does
not need to be bullet proof just best try. I am trying to prevent or warn a
user from visiting a page he already has open and running/displayed in a
separate browser window.



Ps: where is everyone? On vacation? I have only received 8 messages from
this list since the 1st of the month.


Dennis Powers
UXB Internet - A website Design and Hosting Company
P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844
W: http://www.uxbinternet.com
W: http://www.ctbusinesslist.com




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358787
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm