I have a nightly automated transfer from SQL Server to MS Access 2000.
Every so often the tranfers gets interrupted and the Access database is
not closed down correctly.
This results in a corrupted database and a corresponding, open .LDB
file neither of which I can get rid of. I have to then re-create the
structure of the Access database in a new folder and start all over
again. I have about 6 identical, corrupted Access folders that just
sit there for months.
Is there a way to get rid of the LDB file so that I can delete the
database(s)?
Thanks in advance!
Peter Tyler
Geneva - Switzerland 5 4232
On 4 Feb 2005 01:50:10 -0800, PL*****@gmail.c om wrote: I have a nightly automated transfer from SQL Server to MS Access 2000. Every so often the tranfers gets interrupted and the Access database is not closed down correctly.
This results in a corrupted database and a corresponding, open .LDB file neither of which I can get rid of. I have to then re-create the structure of the Access database in a new folder and start all over again. I have about 6 identical, corrupted Access folders that just sit there for months.
Is there a way to get rid of the LDB file so that I can delete the database(s)?
You can delete the ldb file when no users are attached to it.
Rebooting should do it.
DJ
Thanks. You can delete the ldb file when no users are attached to it.
Rebooting should do it. >>
That would mean rebooting the SQL Server machine which must still be
attached, somehow, to the MDB file. There are no other users attached
to it. I just thought there may be a short cut somewhere.
Peter
Peter Tyler wrote: Thanks.
You can delete the ldb file when no users are attached to it.
Rebooting should do it. >>
That would mean rebooting the SQL Server machine which must still be attached, somehow, to the MDB file. There are no other users attached to it. I just thought there may be a short cut somewhere.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
When no users are in the Access .mdb file you can delete the .ldb file
(just highlight the file name in Windows Explorer & hit the Delete key &
click the Yes button on the warning dialog box). If that doesn't work,
sometimes rebooting the machine the .ldb file is on gets rid of it.
You might also try opening the "corrupted" .mdb file & compacting &
repairing it. After closing that file, usually the .ldb file will
disappear.
Good luck,
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQgQRLoechKq OuFEgEQIk0ACgsJ HrJQDne2BSAehYX c4n4GysR48An3NO
x8PPNfNWx+jadQ1 MGccxbr1/
=fWDZ
-----END PGP SIGNATURE-----
>>You might also try opening the "corrupted" .mdb file & compacting &
repairing it. After closing that file, usually the .ldb file will
disappear.>>
Normally you can't compact and repair an MDB file if there are other
'users' attached to it which, in this case, appears to be an SQL Server
on the network.
But thanks anyway.
Peter
Peter Tyler wrote: You might also try opening the "corrupted" .mdb file & compacting &
repairing it. After closing that file, usually the .ldb file will disappear.>>
Normally you can't compact and repair an MDB file if there are other 'users' attached to it which, in this case, appears to be an SQL Server on the network.
SQL Server has nothing to do w/ the .ldb file, it is purely related to
the Access file.
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Steve Claflin |
last post by:
I have a database with a moderate number of records in several tables
(the biggest table at the moment is about 800 records). In development
it got moved between 2K and XP repeatedly. Several days ago, it
wouldn't open, and proposed creating a backup before fixing. OK, but
the "fixed version" didn't open -- same messages as the original -- but
the backup did. But, in the 800 record table only 200 records
appeared. We went back several...
|
by: G |
last post by:
Hi all,
I've just upgraded to Access 2000 and it seems that all the wizards do
not work. I get error messages saying that they are not installed.
I've already done the following:
1. Uninstalled and re-installed
2. Checked for presence of acwzmain.mde and acwztool.mde
3. re-registered the dao files
|
by: Dalan |
last post by:
After reading and experiencing the phenomenon of installing MS Office
2000 on a system that already has MS Office 97, or for that matter
just Access 97 Runtime, I saw the ugliness that ensues. If one elects
the standard installation, then Office 2000 deletes a large percentage
of the older files. Of course, if one happens to choose Custom
installation and elects not to uninstall prior versions, then things
are happier. Yes, the archives...
|
by: Deano |
last post by:
I know this is a long, long shot since I've never seen anyone else confess
to owning this software but.....
Does anyone know what the correct sequence is to get the MSI wizard
functioning correctly on a windows 2000 SP3 pc? I have had to reinstall
following a system crash and the thing just won't play ball.
This is what I'm currently doing;
|
by: Wayne Aprato |
last post by:
I have a client who is running several Access 97 databases that I have
written for them. They are about to upgrade to Access 2003. Is the
default file format of Access 2003 still Access 2000 the same as it
was in Access 2002?
I am running Access 2002 at the moment. Is there any reason for
testing purposes etc, for me to purchase Access 2003 if I am going to
recompile the Access 97 mdb files into Access 2000 format mde files
which...
| |
by: Peter Frost |
last post by:
Please help
I don't know if this is possible but what I would really like to do is
to use On Error Goto to capture the code that is being executed when
an error occurs.
Any help would be much appreciated.
Thanks in advance
|
by: Mike Gramelspacher |
last post by:
Hello,
I have an Access 2000 database that I copied to a new computer with Access
2003. Access 2003 says the file is in Access 2000 file format. I made some
changes to the Access 2000 file code on the computer with Access 2003, and
compiled. I copied the file back to the Access 2000 machine and the file
runs, but the code is unviewable. Any ideas on why this happens?
Mike G.
|
by: brooks |
last post by:
I have an Access 97 app and the ADT and am considering selling it to
the public.
Is this viable? What issues might I have?
I also have Access 2000 and could use that if it would be better. I
don't have the "ADT" for 2000. Is it called ODE or ODT? Can you still
buy that?
Would there be any advantage in moving up to and distributing using
|
by: Walshi |
last post by:
Hi all,
I'm a relative newby to access and VBA etc. My forms and tables etc are
working great and saving lots of time...However...
I have two databases with the exact same table format. I want db1 to be
used to input data by a remote operator, when she is ready I want her
to be able to click a control button to email her new data to db2. This
new data will be added to the table in db2 ready for further
processing.
|
by: Wandering |
last post by:
I know you guys are heavy duty coders, while I do ad-hoc analysis, and
rarely write code. And, I may be in the wrong groups because this is
about an install issue, and I don't think it's a code issue. But ...
Office 2000 was on this machine when it was given to me. I don't own
it. After installing Office 97, mine, in a different directory, and
checking most of it out, I uninstalled Office 2000.
Well, it's a lot easier to upgrade than...
|
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: 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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |