Re: Issue: LDB Not Being Created

Albert,

Thank you very much for that extensive reply - it is greatly
appreciated.

I would totally agree that it is a rights issue (and was convinced it
was until i extensively tested it) except that I am the network
administrator with full control rights to that folder and all the
files within it. Also, if it was a rights issue, I would presume that
I wouldn't be able to create the LDB file every other time I open the
database. I am baffled!

Again, just to reitterate:

* I open the database and the LDB gets created.
* I close the database and the LDB gets deleted.
* I open the database a few moments later and *no* LDB is created.
* I close the database.
* Repeat process....

This process happens infinitely even if no one else tries to open the
databse.

One last note: these are simple databases that are not split between a
front end and back end - just a single MDB.

Thank you and if anyone has any ideas please send them my way.


On Wed, 7 Jan 2009 09:58:11 -0700, "Albert D. Kallal"
<PleaseNOOOsPAMmkallal@xxxxxxx> wrote:


Perhaps one of the users entering that database does not have create file
permissions for the backend folder?

What this would mean is that when one user opens the back and has correct
file create permissions, then all other users of the network would be able
to freely open and use the database.

However if one user opens up the file does not have correct permissions to
that back and folder, then he'll open the file, but no other additional
users will be able to open that data base because the locking file or
temporary LDB cannot be created.

So I would check the actual user permissions and user rights assigned to the
individual users of the folder. This is absolutely nothing to do with access
in terms of access permissions, we're talking about the network and file
folder permissions.

Note also that several users could open the database that have a actual
correct file creation rights to that folder, then the last user in is one of
those users who does not have file create permissons. as he would exit, the
locking file disappears, but when he opens the file, he's unable to create
that user locking file, and thus everyone else will be locked out. So is
going to depend on the particular user and permissions and which user gets
in first that will explain this strange phenomenon (in other words this
behavior will change depending on which user gets in first, and which user
does or does not have that file creation permissions, so some users might
have this right, and things will work fine unless they're the first or last
guy in or out of the application).

On the other hand also keep in mind that you'll have to use the refresh
button in the windows desktop explorer to make sure that you see that file
being created, or deleted. Often windows itself will not update that
directiry view very fast, thus in fact files have been created or deleted in
that directory but you don't see the user interface being updated. So,
you'll have to use the refresh button in the windows explorer quite often to
make sure you're actually seeing the current state of files in that
directory.

My first spider sense in this whole problem to check the user permissions
and make sure they have full creation file rights in that directory, and
also full file deletion rights.
.