Adding a folder results in error in currently working database

[fabrice.baro]

Hi all,

I have a Microsoft JET Database Engine running a database (mdb) which works.
Whenever I add a new folder containing another mdb file, after a while (say about 1 hour), my originally working database gives the following error (where "m\fpdb\Shaun.mdb" is the newly added folder and mdb file):

Database Results Wizard Error
Description: 'C:\Websites\JGH\External\DiagnosticMedicine\m\fpdb\Shaun.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
Number: -2147467259 (0x80004005)
Source: Microsoft JET Database Engine
The operation failed. If this continues, please contact your server administrator.

Of course I changed nothing in the code of the original database.

I'm assuming
- simply adding a new folder isn't the proper way to add a new DB
- there is some kind of process that monitors the filesystem

I would just need some broad directions on where to look/ how to proceed.

Thanks,

Fabrice

 

[Gloops]

Hello,

Is the newly created database a copy of the one you are running ?
Verify there is not something locked somewhere ...

And do not hesitate to look for the error number in hexadecimal in a
search engine, this can lead you to this for instance :
http://support.microsoft.com/kb/174943

Honestly I searched that after I wrote my answer, but ...

So, consider closing your database, it can be called by a batch that
will reload it when applied.
Inside a database, to unlock a resource (form, table ...) called by a
code, you call the following code via a timer. In the exploitation
system you can also call a timer.

If needed :
http://zailes.org/Retard/Retard.aspx

_______________________________________________________________

 

[fabrice.baro]

Hi Gloops,

Thanks for your answer.
The database is a newly created one.

I don't recall getting a lock-related error.

Is there something else to do other than adding the new database files?

Thanks,

Fabrice

 

[phil hunt]

Did you try giving 'Everyone' full control on the new folder ?

 

[Gloops]

Hi Gloops,

Thanks for your answer.
The database is a newly created one.

I don't recall getting a lock-related error.

Well, you don't recall, but you reported it here
It is named error 0x80004005

Is there something else to do other than adding the new database files?

I imagine we have to look at the calling code.