IS there any way to make DW MX close an access locking file???

[George Mizzell]

Everytime I open a dynamic page in DMX I notice the locking file turns on,
but closing the file does not clear the locking file. Therefore I can't
ever upload the database unless I close DMX and then reopen and before
opening the page, I upload the mdb. If I want to download the file, I have
to do the same thing - close DMX, reopen then download the file and move it
to another folder and open it so that it doesn't set the lockfile.

I have figured out how live with it, but DO I HAVE TO?

Thanks
George

[Showjumper]

I used to have the same trouble w/ both UD and DWMX when using asp. Never
found a way to fix it
"George Mizzell" <george@engconcepts.net> wrote in message
news:bevm8c$f76$1@forums.macromedia.com...

> Everytime I open a dynamic page in DMX I notice the locking file turns on,
> but closing the file does not clear the locking file. Therefore I can't
> ever upload the database unless I close DMX and then reopen and before
> opening the page, I upload the mdb. If I want to download the file, I

have

> to do the same thing - close DMX, reopen then download the file and move

it

> to another folder and open it so that it doesn't set the lockfile.
>
> I have figured out how live with it, but DO I HAVE TO?
>
> Thanks
> George
>
>

[colm]

To clear the lockfile on the server, send it a bad query. I usually have a
page on the site that looks for a non-existant table in the db. Call the
page and the lockfile goes. This allows me to put a new copy.
Never found a way to clear the local one though....

--
Colm
[url]http://www.moosepucky.com/links/links.cfm[/url] > Links
[url]http://www.colmgallagher.com/extensions.htm[/url] > Extensions


"George Mizzell" <george@engconcepts.net> wrote in message
news:bevm8c$f76$1@forums.macromedia.com...

> Everytime I open a dynamic page in DMX I notice the locking file turns on,
> but closing the file does not clear the locking file. Therefore I can't
> ever upload the database unless I close DMX and then reopen and before
> opening the page, I upload the mdb. If I want to download the file, I

have

> to do the same thing - close DMX, reopen then download the file and move

it

> to another folder and open it so that it doesn't set the lockfile.

[Elliott]

Yeah, i'd be interested if there was a way of doing this...

What I do, is have a seperate database held elsewhere on my harddrive,
whenever I change the database (with DMX open) I copy and paste any
queries\tables I have changed into this other (non locked) database. When I
download the database form the server I just copy and overwrite the entire
(locked) database with the one Ive just downloaded. This, for me is much
quicker than loading and reloading dreamwever (also saves system resources)

Does that make sense?

Tom
[url]www.telliott.co.uk[/url]

"George Mizzell" <george@engconcepts.net> wrote in message
news:bevm8c$f76$1@forums.macromedia.com...

> Everytime I open a dynamic page in DMX I notice the locking file turns on,
> but closing the file does not clear the locking file. Therefore I can't
> ever upload the database unless I close DMX and then reopen and before
> opening the page, I upload the mdb. If I want to download the file, I

have

> to do the same thing - close DMX, reopen then download the file and move

it

> to another folder and open it so that it doesn't set the lockfile.
>
> I have figured out how live with it, but DO I HAVE TO?
>
> Thanks
> George
>
>