Skip to main content
Inspiring
September 11, 2006
Answered

Microsoft JET Database Engine error '80004005'

  • September 11, 2006
  • 4 replies
  • 943 views
Hello there

I hope you can help me resolve a situation.

When I try to run a page I get this error.

quote:

Microsoft JET Database Engine error '80004005'

Could not use ''; file already in use.

/assignment3/resales2.asp, line 9

Does anyone have any ideas what the problem is and how I can solve it?

Many thanks
This topic has been closed for replies.
Correct answer Pantyboy
Ok. What happened there? I just seen I have managed to post the same reply three times! Burk!

Nath! I think I have found the answer! I found this completely by accident.

Have a look at: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19515 and check out the link 'Database connectivity fails with local ASP.NET and ASP servers'.

However, I would try selecting 'Using driver on testing server' in the 'Custom Connection String' dialog box before installing the extension, as the installation of the extension overwrites the existing one and I'm not sure the it needs to installed in v8 and just using '... driver on testing server' might just do the trick. I didn't try it first but I did disable the extension after I installed it and with the '... testing server' selected it still worked.

Anyway, give it a go and see.

Martin

4 replies

Inspiring
September 11, 2006
I'd love to know a solution to that, ehm, "Pantyboy", :-o but I've been
using DW since UD4 and it has always been a problem.
I tried changing permissions on the database, database directory, wwwRoot
folder...everything, but never solved it. Resigned myself to shutting down
and re-starting DW!

If you come up with a solution, I'd be interested to hear it.

Nath.

"Pantyboy" <webforumsuser@macromedia.com> wrote in message
news:ee3skn$nek$1@forums.macromedia.com...
> Hi there
>
> Many thanks for the reply. It solved the problem and everything worked
> fine.
>
> Do you know of any way to stop the .ldb file from being created? Would
> adding
> something to the 'MM_fdh_STRING = ...' help?
>
> Regards
>
> Martin
>


PantyboyAuthor
Inspiring
September 11, 2006
Hi Nath

I've been hunting the web ideas and I can't find anything of any real help. With any luck they might create an update to cure the problem, but as you've been a user since v4, I don't thing we should hold our breath.

Any hoo, once again, many thanks for help.

Martin
Inspiring
September 11, 2006
No, but opening a page that connects to a different database will also
release the lock, and that's faster than shutting down DW.

"Pantyboy" <webforumsuser@macromedia.com> wrote in message
news:ee3skn$nek$1@forums.macromedia.com...
> Hi there
>
> Many thanks for the reply. It solved the problem and everything worked
> fine.
>
> Do you know of any way to stop the .ldb file from being created? Would
> adding
> something to the 'MM_fdh_STRING = ...' help?
>
> Regards
>
> Martin
>


PantyboyAuthor
Inspiring
September 11, 2006
Hi there

Many thanks for the reply. It solved the problem and everything worked fine.

Do you know of any way to stop the .ldb file from being created? Would adding something to the 'MM_fdh_STRING = ...' help?

Regards

Martin
Inspiring
September 11, 2006
Check that you don't have a temporary .ldb file sat in your database
directory (if you are using Access).
This file appears if you edit the database direct, or if you edit a page
that has a connection to that database...and then try to preview. Because
the .ldb file exists, the database is deemed to be "already in use". Only
way to get rid of that is to shut down DW and re-start.

Just a guess, but I hope this helps. Any more details, if it's not the
above?

Regards
Nath.

"Pantyboy" <webforumsuser@macromedia.com> wrote in message
news:ee39ck$kk$1@forums.macromedia.com...
> Hello there
>
> I hope you can help me resolve a situation.
>
> When I try to run a page I get this error.
>
>
quote:

Microsoft JET Database Engine error '80004005'
>
> Could not use ''; file already in use.
>
> /assignment3/resales2.asp, line 9

> Does anyone have any ideas what the problem is and how I can solve it?
>
> Many thanks
>
>