Hi All,

I have encountered a problem with the ldb file of a database. When
making changes to the backend databases I need exclusive access to make
changes. I usually do this at night when all users have left the premises,
but for the last couple of nights there are no users using the database
and the ldb file is still visible even though I'm sure nobody is using
the database. I have tried to manually delete the lbd file but the
following day users encountered problems with database so I have to replace
the database with previous night database.

I have tried to open the database and close the database just in case a
user has closed the database inappropriate, but the ldb file is still
visible.

I have tried to open the ldb file with notepad to see which users are
using the database, but the users that are shown in notepad have left
and they have nor remote access.

How can I close the ldb file to have exclusive access to the database
to make changes and no to get errors the following day using the
database?

Regards

John

John,
[color=blue]
>I have encountered a problem with the ldb file of a database. When
>making changes to the backend databases I need exclusive access to make
>changes. I usually do this at night when all users have left the premises,
>but for the last couple of nights there are no users using the database
>and the ldb file is still visible even though I'm sure nobody is using
>the database. I have tried to manually delete the lbd file but the
>following day users encountered problems with database so I have to replace
>the database with previous night database.
>
>I have tried to open the database and close the database just in case a
>user has closed the database inappropriate, but the ldb file is still
>visible.
>
>I have tried to open the ldb file with notepad to see which users are
>using the database, but the users that are shown in notepad have left
>and they have nor remote access.[/color]

This is by design and so it's quite normal.
[color=blue]
>How can I close the ldb file to have exclusive access to the database
>to make changes and no to get errors the following day using the
>database?[/color]

Delete the ldb file. This will NOT cause any problems the following
day. But the problems and the not deleted ldb file have the same
reason: someone has left the MDB file not properly.

Have a look at Tonys page: www.granite.ab.ca/access/corruptmdbs.htm

Regards

Thilo Immel
Access Repair Service www.atroplan.com
NEW: Access Memory Reporter 1.0
Shows the use of memory by tables and indexes.

jnnybgud2000@yahoo.com (John) wrote:
[color=blue]
>I have encountered a problem with the ldb file of a database. When
>making changes to the backend databases I need exclusive access to make
>changes. I usually do this at night when all users have left the premises,
>but for the last couple of nights there are no users using the database
>and the ldb file is still visible even though I'm sure nobody is using
>the database. I have tried to manually delete the lbd file but the
>following day users encountered problems with database so I have to replace
>the database with previous night database.[/color]

What kind of problems?
[color=blue]
>I have tried to open the database and close the database just in case a
>user has closed the database inappropriate, but the ldb file is still
>visible.[/color]

That should've deleted the LDB.
[color=blue]
>I have tried to open the ldb file with notepad to see which users are
>using the database, but the users that are shown in notepad have left
>and they have nor remote access.[/color]

This is normal behaviour.

Opening the .ldb file using notepad will show you both who's currently in the
database and some of the workstations which were in the database. When a person
exits Access their workstation name and Access login id, Admin unless you are using
Access security, are left in a "slot" or record in the ldb file. This slot or record
may get overwritten the next time someone enters the MDB depending on what slot or
record is available previous to it in the ldb file.

Determining the workstation which caused the Microsoft Access MDB corruption
http://www.granite.ab.ca/access/corr...orkstation.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Hi All,

I have tried to remove the ldb files of the backend databases but the
ldb file returns immediately. I'm more than sure than no one is using
the database. I want to make a few changes to the backend databases
but I can't because I get a message that I don't have exclusive access
when no one is using the database.

I have tried several times to delete the ldb file but it keeps
appearing. Has anyone experienced this problem before??

Regards

John

Tony Toews <ttoews@telusplanet.net> wrote in message news:<i4cib0ps1n52nog1u3o259tbttbo9jobc0@4ax.com>. ..[color=blue]
> jnnybgud2000@yahoo.com (John) wrote:
>[color=green]
> >I have encountered a problem with the ldb file of a database. When
> >making changes to the backend databases I need exclusive access to make
> >changes. I usually do this at night when all users have left the premises,
> >but for the last couple of nights there are no users using the database
> >and the ldb file is still visible even though I'm sure nobody is using
> >the database. I have tried to manually delete the lbd file but the
> >following day users encountered problems with database so I have to replace
> >the database with previous night database.[/color]
>
> What kind of problems?
>[color=green]
> >I have tried to open the database and close the database just in case a
> >user has closed the database inappropriate, but the ldb file is still
> >visible.[/color]
>
> That should've deleted the LDB.
>[color=green]
> >I have tried to open the ldb file with notepad to see which users are
> >using the database, but the users that are shown in notepad have left
> >and they have nor remote access.[/color]
>
> This is normal behaviour.
>
> Opening the .ldb file using notepad will show you both who's currently in the
> database and some of the workstations which were in the database. When a person
> exits Access their workstation name and Access login id, Admin unless you are using
> Access security, are left in a "slot" or record in the ldb file. This slot or record
> may get overwritten the next time someone enters the MDB depending on what slot or
> record is available previous to it in the ldb file.
>
> Determining the workstation which caused the Microsoft Access MDB corruption
> http://www.granite.ab.ca/access/corr...orkstation.htm
>
> Tony[/color]

jnnybgud2000@yahoo.com (John) wrote:
[color=blue]
>I have tried to remove the ldb files of the backend databases but the
>ldb file returns immediately. I'm more than sure than no one is using
>the database. I want to make a few changes to the backend databases
>but I can't because I get a message that I don't have exclusive access
>when no one is using the database.
>
>I have tried several times to delete the ldb file but it keeps
>appearing. Has anyone experienced this problem before??[/color]

Something is definitely recreating the LDB file. Have you tried opening it in
notepad and seeing if there are any clues in there such as workstation name? Do not
save it though.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Hi Tony,
I have opened the ldb file in notepad which displays the workstations
and users, but these users and workstations are not longer using the
database. I have physically checked the users and workstations.

I do not know what is recreating the ldb file. Do you have any ideas
what is behind it??

Regards

John

Tony Toews <ttoews@telusplanet.net> wrote in message news:<3lblb0ddsf8jobl5eutt1n6c27rd9f6230@4ax.com>. ..[color=blue]
> jnnybgud2000@yahoo.com (John) wrote:
>[color=green]
> >I have tried to remove the ldb files of the backend databases but the
> >ldb file returns immediately. I'm more than sure than no one is using
> >the database. I want to make a few changes to the backend databases
> >but I can't because I get a message that I don't have exclusive access
> >when no one is using the database.
> >
> >I have tried several times to delete the ldb file but it keeps
> >appearing. Has anyone experienced this problem before??[/color]
>
> Something is definitely recreating the LDB file. Have you tried opening it in
> notepad and seeing if there are any clues in there such as workstation name? Do not
> save it though.
>
> Tony[/color]

I've had problems with the .ldb file hanging up, and one of our server
people is able to check and see who actually still has the database
open. Do you have anyone who can do that?

Since it keeps being re-created, someone or something must be
connecting to it. Is anyone using merge files that pull data from it?
That will create an .ldb file also.

jnnybgud2000@yahoo.com (John) wrote in message news:<b5fa58b4.0405311552.30578bd7@posting.google. com>...[color=blue]
> Hi Tony,
> I have opened the ldb file in notepad which displays the workstations
> and users, but these users and workstations are not longer using the
> database. I have physically checked the users and workstations.
>
> I do not know what is recreating the ldb file. Do you have any ideas
> what is behind it??
>
> Regards
>
> John
>
> Tony Toews <ttoews@telusplanet.net> wrote in message news:<3lblb0ddsf8jobl5eutt1n6c27rd9f6230@4ax.com>. ..[color=green]
> > jnnybgud2000@yahoo.com (John) wrote:
> >[color=darkred]
> > >I have tried to remove the ldb files of the backend databases but the
> > >ldb file returns immediately. I'm more than sure than no one is using
> > >the database. I want to make a few changes to the backend databases
> > >but I can't because I get a message that I don't have exclusive access
> > >when no one is using the database.
> > >
> > >I have tried several times to delete the ldb file but it keeps
> > >appearing. Has anyone experienced this problem before??[/color]
> >
> > Something is definitely recreating the LDB file. Have you tried opening it in
> > notepad and seeing if there are any clues in there such as workstation name? Do not
> > save it though.
> >
> > Tony[/color][/color]

jnnybgud2000@yahoo.com (John) wrote:
[color=blue]
>I have opened the ldb file in notepad which displays the workstations
>and users, but these users and workstations are not longer using the
>database. I have physically checked the users and workstations.
>
>I do not know what is recreating the ldb file. Do you have any ideas
>what is behind it??[/color]

No. But what is confusing to me is that you delete the ldb file, which you couldn't
do if anyone was in the MDB as well, and a few minutes later the ldb file is back but
with some users and workstations in it. The only way that the ldb can be recreated
with that data is by those users/workstations.

Or somehow, and this is highly unlikely, something is restoring that file from
somewhere.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Hi Tony,
To be honest I have no idea what is recreating the ldb file. I will
probably copy the backend databases to another folder, make all the
require changes then copy the databases back to the appropriate
folder.

I don't believe this will corrupt the database. Would it??

Regards

John

Tony Toews <ttoews@telusplanet.net> wrote in message news:<ci9vb0tkhrcoj61aq19kbv02g0ec4j0nk4@4ax.com>. ..[color=blue]
> jnnybgud2000@yahoo.com (John) wrote:
>[color=green]
> >I have opened the ldb file in notepad which displays the workstations
> >and users, but these users and workstations are not longer using the
> >database. I have physically checked the users and workstations.
> >
> >I do not know what is recreating the ldb file. Do you have any ideas
> >what is behind it??[/color]
>
> No. But what is confusing to me is that you delete the ldb file, which you couldn't
> do if anyone was in the MDB as well, and a few minutes later the ldb file is back but
> with some users and workstations in it. The only way that the ldb can be recreated
> with that data is by those users/workstations.
>
> Or somehow, and this is highly unlikely, something is restoring that file from
> somewhere.
>
> Tony[/color]

jnnybgud2000@yahoo.com (John) wrote:
[color=blue]
>To be honest I have no idea what is recreating the ldb file. I will
>probably copy the backend databases to another folder, make all the
>require changes then copy the databases back to the appropriate
>folder.
>
>I don't believe this will corrupt the database. Would it??[/color]

It could if a user was in the MDB doing an update. Besides you'd lose the changes
they made. I'd suggest renaming except you're are still going to have the problem
of figuring out what user(s) are locking the mdb. You can also get the system
admins to figure out who has a file lock on the file.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm