HELP: LDB LOCK FILE

[James]

HI,

I am having lots of troubles with the ldb file, I open a database and after
I closed it the ldb file is not erased.

So if I try to open the db back it said that the db is currently open and if
I wanted to repair it. If I said YES nothing it said that I do not have
permission to use the object ". If I said NO the db is not opened.

On the other hand if I erase the ldb file the same message as above is
shown.

NEED HELP URGENTLY.

Thanks,

Jaime

 

[Guest]

James:

The .ldb file is the locking file used by Access to monitor usage,
particularly when the database is being used by multiple users. You didn't
mention whether or not you are sharing this database with anyone else. If
the .ldb doesn't close itself automatically when a single-user leaves the
..mdb, a couple of things could be happening. Are you the only user? Did you
initially create the database? Do you need a password to get into the .mdb?
Have you been tinkering with database security?
I suspect that Access thinks that you are not the creator of the .mdb
or that you are not the administrator? Are you logging onto your computer
with a different name or logon ID? Are you trying to run multiple copies of
the .mdb on your machine?
Check these questions and if you can't figure out the problem, re-post
to this newsgroup.

Steve in Ohio

 

[James]

Steve,

Thanks for your help I could not find out what is happening so I beg you
some more help:

CONFIGURATION: I created the frontend and backend database in computer1, The
frontend tables are linked to the backend "real" tables. I have made a copy
of the frontend in computer2 and I linked it to backend in computer1, also I
have made a copy of frontend in computer3 and linked it to backend in
compute1.
Also I have a firewall in each computer. I do not use password in any
database.

I think you are right that there is some security problem, Please can you
advice me how to proceed.

Thanks,

Jaime

 

[Guest]

James,

Possibly the open mode is set incorrectly for a multi-user database:
Tools|Options, select Advanced tab. Check the Default open mode.
It should be "Shared".

TomU

 

[James]

Actually is SHARED.

Thanks anyway,
Jaime

James,

Possibly the open mode is set incorrectly for a multi-user database:
Tools|Options, select Advanced tab. Check the Default open mode.
It should be "Shared".

TomU

 

[Kevin K. Sullivan]

Just a stab,

Do the users of computer2 and computer3 have permission to delete files from
the the backend directory? It sounds like they can read, write and create
an .ldb (if they don't get a read-only warning, they have created/modified
the .ldb) but they can't remove it when they are the last one out. Just a
thought.

Kevin

 

[James]

Yes I have already try it and I can delete a file in computer1 from
Computer2 and Computer3.
Thanks.

There is something I miss in a previous mail, I had import a form from
backend in computer1 to frontend in computer3 and then if I try to change
name or delete that form in computer3 it do not allow me also it do not show
any message it simple do not delete or change name.

Any help???.

Thanks.

Jaime