473,573 Members | 2,851 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ldb file is visible after databases are close

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
Nov 13 '05 #1
9 15744
John,
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.
This is by design and so it's quite normal.
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?


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.
Nov 13 '05 #2
jn**********@ya hoo.com (John) wrote:
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.
What kind of problems?
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.
That should've deleted the LDB.
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.


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
Nov 13 '05 #3
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 <tt****@teluspl anet.net> wrote in message news:<i4******* *************** **********@4ax. com>...
jn**********@ya hoo.com (John) wrote:
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.


What kind of problems?
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.


That should've deleted the LDB.
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.


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

Nov 13 '05 #4
jn**********@ya hoo.com (John) wrote:
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??


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
Nov 13 '05 #5
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 <tt****@teluspl anet.net> wrote in message news:<3l******* *************** **********@4ax. com>...
jn**********@ya hoo.com (John) wrote:
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??


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

Nov 13 '05 #6
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.

jn**********@ya hoo.com (John) wrote in message news:<b5******* *************** ****@posting.go ogle.com>...
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 <tt****@teluspl anet.net> wrote in message news:<3l******* *************** **********@4ax. com>...
jn**********@ya hoo.com (John) wrote:
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??


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

Nov 13 '05 #7
jn**********@ya hoo.com (John) wrote:
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??


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
Nov 13 '05 #8
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 <tt****@teluspl anet.net> wrote in message news:<ci******* *************** **********@4ax. com>...
jn**********@ya hoo.com (John) wrote:
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??


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

Nov 13 '05 #9
jn**********@ya hoo.com (John) wrote:
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??


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
Nov 13 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
3402
by: GrantS | last post by:
I need urgent help. Done OK for a newbie getting automation of Windows Messenger into a Winform C# app but have three problems that I urgently need pointers to. Point 1 and 2 are the same issue, I think. Point 3 might relate to a threading issue: 1. I have written a C# Winform application that uses Windows messenger automation. When I...
1
5395
by: Daniel | last post by:
I have looked everywhere on the web for an answer to this and the only thing I can find is converting the image format when the file is present on the local filesystem. What I want to do is use a web form to upload a TIFF image (scanned images) and convert it to a JPEG before I insert it into SQL Server. The file upload part works great, but...
0
5498
by: Benjamin Bittner | last post by:
Hallo NG, ive searched a lot in some google groups, and found many threads, but nothing that helped me. Here is the scenario: I have an aspx page which loads a user control in page.onInit like this Dim pdControl As bb.unit = CType(LoadControl("./content/unit.ascx"), bb.unit) phContent.Controls.Add(pdControl)
4
2114
by: Ravi J | last post by:
Hello, I need to write an asp.net page that pushes a files to the user for download. The code I wrote works just fine, in that it sends a file to the user. But the HTML controls on the page are not updated.. private void Button1_Click(object sender, System.EventArgs e) { //part 1 TextBox3.Text = TextBox1.Text + " " + TextBox2.Text;...
2
1845
by: Tim::.. | last post by:
Can someone please tell me why I keep getting an error saying the page cannot be displayed in my ASP.NET app. If I upload a file that is under approx 3mb then it works file but as soon as I try to upload a larger file I get Page Cannot be displayed error... I'm uploading the file as binary into and SQL 2000 Database! Any advice would be...
7
2867
by: Randy Yates | last post by:
I'm a complete newbie to postgres so please look the other way if these questions are really stupid. Is it legitimate to have one database per data file? For organizational and backup purposes, I'd like to keep the database files for each of several projects separate. This means, e.g., that postmaster must have multiple instances going...
4
4459
by: Matt Jensen | last post by:
Howdy I've got a rather strange issue occuring. I used forms based .NET authentication, although I'm also setting some session variables when people login. However, I've found when people use one of my webform pages which includes a button that pops up a window where you can upload files, if you upload files in this popup window, it...
3
3996
by: forest demon | last post by:
for example, let's say I do something like, System.Diagnostics.Process.Start("notepad.exe","sample.txt"); if the user does a SaveAs (in notepad), how can i capture the path that the user selects? thanks...
15
2477
by: slinky | last post by:
Thanks in advance fo rany help... I have an XML data file (well- formed) that I need to place into my website's app_data folder. I would like to have an .aspx form on my site that simply has two textboxes (corresponding to two XML fields in my file), and a "submit" button that will update the file. Any clues as to the code to use? I'm most...
0
7705
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8033
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7796
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6426
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5601
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5294
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3739
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1316
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1044
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.