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 15746
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**********@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
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 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
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
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 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
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 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 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 think.
Point 3 might relate to a threading issue:
1. I have written a C# Winform application that uses Windows messenger
automation.
When I attempt to send a file through the window messenger object,
there is some horrid screen flicking...
|
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 I can;t convert the image. I certainly don't want to upload it the
the server filesystem, convert...
|
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)
|
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;
TextBox1.Visible = TextBox2.Visible = TextBox3.Visible = false;
|
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 appritiated!
| |
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 simultaneously?
I'm thinking the answer is NO because, for one, the TCPIP
|
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 seems to somehow clear out all of the session
variables and the users get logged out. However, if...
|
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...
|
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 familiar with the DataAdapter/DataSet model and using
SQLserver files and having an INSERT INTO...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |