going round in circles - "file already in use" error (Access)

[Nathon Jones]

I'm using VBScript/ASP with an Access database on a standalone PC, running
IIS.
And before you all jump on this post, I have tried:

1) ODBC connection to database
2) OLE DB connection to database
3) Checking permissions on the database
4) Checking permissions on the folder the database is in

Basically, whenever I edit an ASP page in DWMX, that is linked to my Access
database, it creates an .ldb file in the same directory as the database.
This means that when I try to preview the site offline
([url]http://localhost/sitename/index.asp[/url]), I get an error about the file already
being in use.

The ONLY was I can get rid of the .ldb file is to shut down Dreamweaver, and
it is really doing my NUT in now.
I've ran through all of the permissions tech sheets, both on Macromedia and
Microsoft, and none of them resolve the issue for me.

When I used an ODBC connection, I got this error:
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file
already in use.

When I used an OLE DB connection I got this error:
[Microsoft][ODBC Microsoft Access Driver] Could not use "; file already in
use.

Please somebody save me from this insanity. WHAT ON EARTH is the problem
here??? :o(

Nath.

[Julian Roberts]

Always use an OLEDB connection. Edit your connection and see if you're using
a driver on local or remote server. Try swapping them over.

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Nathon Jones]

Hi Jules,

Ok, took it slowly, and recreated an OLE DB connection. If I select Remote
Server, it doesn't seem to be able to retrieve tables from the database,
however, if I select Local Server it allows me to create a recordset, and is
seeing the tables.

Problem is, when I try to look at this
([url]http://localhost/sitedirectory/index.asp[/url]), I get the following error:

Error Type:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
/sitedirectory/index.asp, line 8

I checked DWMX, and sure enough there is an .ldb file in the database
folder.
I honestly thought that changing from ODBC to OLE DB was going to solve this
for me, but now I'm wondering where exactly the problem is.

Hoping you can shed some light, oh wise one.

Thanks again
Nath.

Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d311jm$h1f$1@forums.macromedia.com...

> Always use an OLEDB connection. Edit your connection and see if you're
> using a driver on local or remote server. Try swapping them over.
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>

[middletree]

I have seen this error when I had Access open. You need to close Access when
running your ASP pages, if it isn't already.

I went to [url]www.aspfaq.com[/url], and typed in the phrase you are getting, and found
this article:

[url]http://www.aspfaq.com/show.asp?id=2009[/url]





"Nathon Jones" <nathon@SHPAMkirkmoor.com> wrote in message
news:d313h6$js9$1@forums.macromedia.com...

> Hi Jules,
>
> Ok, took it slowly, and recreated an OLE DB connection. If I select

Remote

> Server, it doesn't seem to be able to retrieve tables from the database,
> however, if I select Local Server it allows me to create a recordset, and

is

> seeing the tables.
>
> Problem is, when I try to look at this
> ([url]http://localhost/sitedirectory/index.asp[/url]), I get the following error:
>
> Error Type:
> Microsoft JET Database Engine (0x80004005)
> Could not use ''; file already in use.
> /sitedirectory/index.asp, line 8
>
> I checked DWMX, and sure enough there is an .ldb file in the database
> folder.
> I honestly thought that changing from ODBC to OLE DB was going to solve

this

> for me, but now I'm wondering where exactly the problem is.
>
> Hoping you can shed some light, oh wise one.
>
> Thanks again
> Nath.
>
> Julian Roberts" <newsg@charon.co.uk> wrote in message
> news:d311jm$h1f$1@forums.macromedia.com...

> > Always use an OLEDB connection. Edit your connection and see if you're
> > using a driver on local or remote server. Try swapping them over.
> >
> > --
> > Jules
> > [url]http://www.charon.co.uk/charoncart[/url]
> > Charon Cart 3
> > Shopping Cart Extension for Dreamweaver MX/MX 2004
> >
> >
> >

>
>

[Nathon Jones]

Hi,

But the only way I can close Access down, as such, is to shut down
Dreamweaver.

Access is creating an .ldb file whenever I open an ASP page (in DW) that has
a recordset connected to that database. When I close the ASP page, the .ldb
remains. At one stage I tried opening the Access database directly, and
then closing it again to see if it would remove the .ldb file. But it
doesn't.

It just seems ridiculous that DW holds the .ldb when, quite clearly, a user
has shut down the ASP page they were working on. Why (oh why!), does DW do
this?

Over the last few days (yes this has been going on for days!), I have read a
lot of articles about it being a permissions thing, but as far as I can see,
if DW didn't leave the .ldb file open, then this problem wouldn't arise.

Of course, when DW reboots, the .ldb has mysteriously vanished!

Doing my head in, and it looks like many others have had this same problem.
Starting to get very fed up of DW to be honest.

Nath.

"middletree" <middletree@htomail.com> wrote in message
news:d318kq$ra3$1@forums.macromedia.com...

>I have seen this error when I had Access open. You need to close Access
>when
> running your ASP pages, if it isn't already.
>
> I went to [url]www.aspfaq.com[/url], and typed in the phrase you are getting, and
> found
> this article:
>
> [url]http://www.aspfaq.com/show.asp?id=2009[/url]
>
>
>
>
>
> "Nathon Jones" <nathon@SHPAMkirkmoor.com> wrote in message
> news:d313h6$js9$1@forums.macromedia.com...

>> Hi Jules,
>>
>> Ok, took it slowly, and recreated an OLE DB connection. If I select

> Remote

>> Server, it doesn't seem to be able to retrieve tables from the database,
>> however, if I select Local Server it allows me to create a recordset, and

> is

>> seeing the tables.
>>
>> Problem is, when I try to look at this
>> ([url]http://localhost/sitedirectory/index.asp[/url]), I get the following error:
>>
>> Error Type:
>> Microsoft JET Database Engine (0x80004005)
>> Could not use ''; file already in use.
>> /sitedirectory/index.asp, line 8
>>
>> I checked DWMX, and sure enough there is an .ldb file in the database
>> folder.
>> I honestly thought that changing from ODBC to OLE DB was going to solve

> this

>> for me, but now I'm wondering where exactly the problem is.
>>
>> Hoping you can shed some light, oh wise one.
>>
>> Thanks again
>> Nath.
>>
>> Julian Roberts" <newsg@charon.co.uk> wrote in message
>> news:d311jm$h1f$1@forums.macromedia.com...

>> > Always use an OLEDB connection. Edit your connection and see if you're
>> > using a driver on local or remote server. Try swapping them over.
>> >
>> > --
>> > Jules
>> > [url]http://www.charon.co.uk/charoncart[/url]
>> > Charon Cart 3
>> > Shopping Cart Extension for Dreamweaver MX/MX 2004
>> >
>> >
>> >

>>
>>

>
>

[darrel]

> Doing my head in, and it looks like many others have had this same
problem.

> Starting to get very fed up of DW to be honest.

Here's another option...download MySQL and never look back. ;o)

-Darrel

[middletree]

Perhaps I was misunderstood. I meant that Access has to be on your machine,
or wherever it's running. But you don't have to have it open. Having it open
is going to cause this problem. By open, I mean that you have double-clicked
it and you can see it in your taskbar.

Based on the way you have it worded, you don't have Access running, and in
that case, I'd recommend reading the article I linked to, from
[url]www.aspfaq.com[/url]


"Nathon Jones" <nathon@SHPAMkirkmoor.com> wrote in message
news:d319to$t4o$1@forums.macromedia.com...

> Hi,
>
> But the only way I can close Access down, as such, is to shut down
> Dreamweaver.
>
> Access is creating an .ldb file whenever I open an ASP page (in DW) that

has

> a recordset connected to that database. When I close the ASP page, the

..ldb

> remains. At one stage I tried opening the Access database directly, and
> then closing it again to see if it would remove the .ldb file. But it
> doesn't.
>
> It just seems ridiculous that DW holds the .ldb when, quite clearly, a

user

> has shut down the ASP page they were working on. Why (oh why!), does DW

do

> this?
>
> Over the last few days (yes this has been going on for days!), I have read

a

> lot of articles about it being a permissions thing, but as far as I can

see,

> if DW didn't leave the .ldb file open, then this problem wouldn't arise.
>
> Of course, when DW reboots, the .ldb has mysteriously vanished!
>
> Doing my head in, and it looks like many others have had this same

problem.

> Starting to get very fed up of DW to be honest.
>
> Nath.
>
> "middletree" <middletree@htomail.com> wrote in message
> news:d318kq$ra3$1@forums.macromedia.com...

> >I have seen this error when I had Access open. You need to close Access
> >when
> > running your ASP pages, if it isn't already.
> >
> > I went to [url]www.aspfaq.com[/url], and typed in the phrase you are getting, and
> > found
> > this article:
> >
> > [url]http://www.aspfaq.com/show.asp?id=2009[/url]
> >
> >
> >
> >
> >
> > "Nathon Jones" <nathon@SHPAMkirkmoor.com> wrote in message
> > news:d313h6$js9$1@forums.macromedia.com...

> >> Hi Jules,
> >>
> >> Ok, took it slowly, and recreated an OLE DB connection. If I select

> > Remote

> >> Server, it doesn't seem to be able to retrieve tables from the

database,

> >> however, if I select Local Server it allows me to create a recordset,

and

> > is

> >> seeing the tables.
> >>
> >> Problem is, when I try to look at this
> >> ([url]http://localhost/sitedirectory/index.asp[/url]), I get the following error:
> >>
> >> Error Type:
> >> Microsoft JET Database Engine (0x80004005)
> >> Could not use ''; file already in use.
> >> /sitedirectory/index.asp, line 8
> >>
> >> I checked DWMX, and sure enough there is an .ldb file in the database
> >> folder.
> >> I honestly thought that changing from ODBC to OLE DB was going to solve

> > this

> >> for me, but now I'm wondering where exactly the problem is.
> >>
> >> Hoping you can shed some light, oh wise one.
> >>
> >> Thanks again
> >> Nath.
> >>
> >> Julian Roberts" <newsg@charon.co.uk> wrote in message
> >> news:d311jm$h1f$1@forums.macromedia.com...
> >> > Always use an OLEDB connection. Edit your connection and see if

you're

> >> > using a driver on local or remote server. Try swapping them over.
> >> >
> >> > --
> >> > Jules
> >> > [url]http://www.charon.co.uk/charoncart[/url]
> >> > Charon Cart 3
> >> > Shopping Cart Extension for Dreamweaver MX/MX 2004
> >> >
> >> >
> >> >
> >>
> >>

> >
> >

>
>

[UltraDav]

[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;202171[/url]

u got your db directly in the testing server?

[Nathon Jones]

The database is held in:

C:\Inetpub\wwwroot\sitedirectory\data\database.mdb

The ASP pages are in:

C:\Inetpub\wwwroot\sitedirectory\asppages.asp

Still having problems, despite running through all the permissions checks.

:o(

Nath.

"UltraDav" <webforumsuser@macromedia.com> wrote in message
news:d32e7b$epg$1@forums.macromedia.com...

> [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;202171[/url]
>
> u got your db directly in the testing server?

[Nathon Jones]

Thanks again.

I have checked all the permissions though, and everything is as it should
be.

To provide a little more background, my database and site are held in the
Inetpub\wwwroot\sitedirectory\ folder on my C drive.
I am using Internet Explorer to view the site offline at this address:
[url]http://localhost/sitedirectory/index.asp[/url]

Now, I can work away with the database and when I close it, it removes the
..ldb. However, when I work with recordsets and asp pages, DW also creates
an .ldb in the same directory as the database. Except, when you close the
recordsets/asp pages it doesn't remove it, which is why I am getting this
error.

I feel that this issue has nothing to do with permissions.

The question therefore has to be....is this a bug in Dreamweaver? If so,
it's being happening since UltraDev 4 as far as I know.

Why does Dreamweaver create an .ldb file when you open a recordset or asp
page?
Why doesn't it delete the .ldb file when you close the recordset or asp
page?

The answer to these questions will resolve this issue, I'm sure.

Nath.

"middletree" <middletree@verywarmmail.com> wrote in message
news:d31hdm$9rd$1@forums.macromedia.com...

> Perhaps I was misunderstood. I meant that Access has to be on your
> machine,
> or wherever it's running. But you don't have to have it open. Having it
> open
> is going to cause this problem. By open, I mean that you have
> double-clicked
> it and you can see it in your taskbar.
>
> Based on the way you have it worded, you don't have Access running, and in
> that case, I'd recommend reading the article I linked to, from
> [url]www.aspfaq.com[/url]
>
>
> "Nathon Jones" <nathon@SHPAMkirkmoor.com> wrote in message
> news:d319to$t4o$1@forums.macromedia.com...

>> Hi,
>>
>> But the only way I can close Access down, as such, is to shut down
>> Dreamweaver.
>>
>> Access is creating an .ldb file whenever I open an ASP page (in DW) that

> has

>> a recordset connected to that database. When I close the ASP page, the

> .ldb

>> remains. At one stage I tried opening the Access database directly, and
>> then closing it again to see if it would remove the .ldb file. But it
>> doesn't.
>>
>> It just seems ridiculous that DW holds the .ldb when, quite clearly, a

> user

>> has shut down the ASP page they were working on. Why (oh why!), does DW

> do

>> this?
>>
>> Over the last few days (yes this has been going on for days!), I have
>> read

> a

>> lot of articles about it being a permissions thing, but as far as I can

> see,

>> if DW didn't leave the .ldb file open, then this problem wouldn't arise.
>>
>> Of course, when DW reboots, the .ldb has mysteriously vanished!
>>
>> Doing my head in, and it looks like many others have had this same

> problem.

>> Starting to get very fed up of DW to be honest.
>>
>> Nath.
>>
>> "middletree" <middletree@htomail.com> wrote in message
>> news:d318kq$ra3$1@forums.macromedia.com...

>> >I have seen this error when I had Access open. You need to close Access
>> >when
>> > running your ASP pages, if it isn't already.
>> >
>> > I went to [url]www.aspfaq.com[/url], and typed in the phrase you are getting, and
>> > found
>> > this article:
>> >
>> > [url]http://www.aspfaq.com/show.asp?id=2009[/url]
>> >
>> >
>> >
>> >
>> >
>> > "Nathon Jones" <nathon@SHPAMkirkmoor.com> wrote in message
>> > news:d313h6$js9$1@forums.macromedia.com...
>> >> Hi Jules,
>> >>
>> >> Ok, took it slowly, and recreated an OLE DB connection. If I select
>> > Remote
>> >> Server, it doesn't seem to be able to retrieve tables from the

> database,

>> >> however, if I select Local Server it allows me to create a recordset,

> and

>> > is
>> >> seeing the tables.
>> >>
>> >> Problem is, when I try to look at this
>> >> ([url]http://localhost/sitedirectory/index.asp[/url]), I get the following error:
>> >>
>> >> Error Type:
>> >> Microsoft JET Database Engine (0x80004005)
>> >> Could not use ''; file already in use.
>> >> /sitedirectory/index.asp, line 8
>> >>
>> >> I checked DWMX, and sure enough there is an .ldb file in the database
>> >> folder.
>> >> I honestly thought that changing from ODBC to OLE DB was going to
>> >> solve
>> > this
>> >> for me, but now I'm wondering where exactly the problem is.
>> >>
>> >> Hoping you can shed some light, oh wise one.
>> >>
>> >> Thanks again
>> >> Nath.
>> >>
>> >> Julian Roberts" <newsg@charon.co.uk> wrote in message
>> >> news:d311jm$h1f$1@forums.macromedia.com...
>> >> > Always use an OLEDB connection. Edit your connection and see if

> you're

>> >> > using a driver on local or remote server. Try swapping them over.
>> >> >
>> >> > --
>> >> > Jules
>> >> > [url]http://www.charon.co.uk/charoncart[/url]
>> >> > Charon Cart 3
>> >> > Shopping Cart Extension for Dreamweaver MX/MX 2004
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >

>>
>>

>
>

[Nathon Jones]

How about...

Pack in working with computers and look forward to a life without stress....

Nath

"darrel" <notreal@hotmail.com> wrote in message
news:d31af6$kq$1@forums.macromedia.com...

>> Doing my head in, and it looks like many others have had this same

> problem.

>> Starting to get very fed up of DW to be honest.

>
> Here's another option...download MySQL and never look back. ;o)
>
> -Darrel
>
>