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 9 15735
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. jn**********@yahoo.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
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****@telusplanet.net> wrote in message news:<i4********************************@4ax.com>. .. jn**********@yahoo.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 jn**********@yahoo.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
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****@telusplanet.net> wrote in message news:<3l********************************@4ax.com>. .. jn**********@yahoo.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
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**********@yahoo.com (John) wrote in message news:<b5**************************@posting.google. 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****@telusplanet.net> wrote in message news:<3l********************************@4ax.com>. .. jn**********@yahoo.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 jn**********@yahoo.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
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****@telusplanet.net> wrote in message news:<ci********************************@4ax.com>. .. jn**********@yahoo.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 jn**********@yahoo.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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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...
|
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...
|
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...
|
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...
|
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...
| |
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,...
|
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...
|
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...
|
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...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
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,...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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...
| |