Breaking lock on Access file

[Bryan Ashcraft ::TMM::]

How do I break the lock on an Access file? Querying a non-existent table
doesn't seem to work in MX.


--
Bryan Ashcraft (remove brain to reply)
Macromedia Certified Dreamweaver Developer
Paragon Visuals :: [url]http://www.paragonvisuals.com[/url]
TMM Volunteer (DW) :: [url]http://www.macromedia.com/go/team/[/url]
~~~~~~~~~~~~~~~~~~~~~~~~
Got Questions? Get Answers
DWFAQ :: [url]http://www.dwfaq.com[/url]
PVII :: [url]http://www.projectseven.com/go/[/url]
--

[joolzzz]

Hi,

You can not break a lock on an access database, thats why it's better to use
SQL Server or MySQL instead. The lock on the access database means that there
is another program the have created a perminate link to it an has not released
it, that has always been the probelm with access.

Hope this helps

Joolz

[Bryan Ashcraft ::TMM::]

joolzzz wrote:

> Hi,
>
> You can not break a lock on an access database, thats why it's better to use
> SQL Server or MySQL instead. The lock on the access database means that there
> is another program the have created a perminate link to it an has not released
> it, that has always been the probelm with access.
>
> Hope this helps
>
> Joolz
>

I agree that Access isn't as good as SQL Server. In fact this will be up
sized to SQL Server once development and testing are done. Apparently
CFMX is keeping the link as I'm the only one accessing the file and I
have to wait 30-45 minutes after closing my browser for the lock to be
released. In CF5 you could just query a non-existent table and the lock
would be released, but this isn't working on CFMX.

--
Bryan Ashcraft (remove brain to reply)
Macromedia Certified Dreamweaver Developer
Paragon Visuals :: [url]http://www.paragonvisuals.com[/url]
TMM Volunteer (DW) :: [url]http://www.macromedia.com/go/team/[/url]
~~~~~~~~~~~~~~~~~~~~~~~~
Got Questions? Get Answers
DWFAQ :: [url]http://www.dwfaq.com[/url]
PVII :: [url]http://www.projectseven.com/go/[/url]
--

[paross1]

You probably should de-select Maintain Connections in the advanced settings for
your Access data source in ColdFusion Administrator. I doubt that you will see
any difference in performance, and this has been something that was recommended
by Macromedia in the past for Access databases.

[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17034[/url]

Phil

[Bryan Ashcraft ::TMM::]

paross1 wrote:

> You probably should de-select Maintain Connections in the advanced settings for
> your Access data source in ColdFusion Administrator. I doubt that you will see
> any difference in performance, and this has been something that was recommended
> by Macromedia in the past for Access databases.
>
> [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17034[/url]
>
> Phil
>

Thanks for the reply. Unfortunately I don't have access to the CF Admin.
I'll pass the recommendation and link along to the admin, but won't hold
my breath on anything being done on that end. Guess I'm just screwed on
this one, huh?

--
Bryan Ashcraft (remove brain to reply)
Macromedia Certified Dreamweaver Developer
Paragon Visuals :: [url]http://www.paragonvisuals.com[/url]
TMM Volunteer (DW) :: [url]http://www.macromedia.com/go/team/[/url]
~~~~~~~~~~~~~~~~~~~~~~~~
Got Questions? Get Answers
DWFAQ :: [url]http://www.dwfaq.com[/url]
PVII :: [url]http://www.projectseven.com/go/[/url]
--

[paross1]

I would like to believe that your admin would consider it in his/her best
interest to comply with the recommendations from Macromedia regarding the
proper administration of ColdFusion data sources, but then again, some folks
have their own agenda, eh?

Good luck with this one.
Phil