473,608 Members | 2,287 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Compact & Repair not working for Microsoft Access Database 2003

66 New Member
The Compact & Repair option is not working on 1 of the computers .The Operating system used is Windows XP.

In the Database,when the Compact & Repair option is used it creates a separate file as db1.mdb.

Whereas other computers this option works fine..it no longer creates db1.mdbs separately.

Does the computer which is not able to do Compact & Repair require any specific setting..
Can anyone Plz help me with some solution for this .
Oct 14 '10 #1
4 2623
MMcCarthy
14,534 Recognized Expert Moderator MVP
If you check you will probably find there is a lock file (*.ldb) on the computer that won't complete the Compact and Repair. This was probably left behind after a crash or the database closing incorrectly. This file will have to be deleted.

Essentially compact and repair will only work when the database is opened exclusively by the user running it. If the lock file is present it assumes another user has the database open and therefore it creates the db1 file instead.

Mary
Oct 14 '10 #2
shalskedar
66 New Member
Thanks.
Had been checked several times that the Database is opened exclusively but still this error occurs..
Oct 14 '10 #3
MMcCarthy
14,534 Recognized Expert Moderator MVP
It's not so much that the database has to be open exclusively but rather there cannot be any other users currently on the database.

Are you sure that there is no *.ldb file either in the frontend or backend locations of the database? This is the only circumstances I'm aware of that causes this problem.
Oct 14 '10 #4
dsatino
393 Contributor
You should also know that compact and repair always creates db1.mdb. Basically compact and repair makes a duplicate of the database without all the excess garbage it's collected, deletes your db, and then renames the db1 to your db name.

So you can see the compact is working to an extent. I would go with Mary's advice, search for that .ldb file. It's the only thing I can think of that would cause your problem.
Oct 15 '10 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

3
3271
by: pwh777 | last post by:
I have three databases. DB1 has a button on a form. When I click that button, I want to import all the objects from DB2 to DB3 (just as you would if you would chose the File > Get External Data > Import menu option). Then I want to Compact and Repair DB3. I want to do this all by pushing the button in DB1. Is this possible?
5
17653
by: Lauren Wilson | last post by:
Hi folks, Somewhere, I recently saw an article header titled: "How to compact and Repair a back-end Access db from the front-end using VBA" or words to that effect. Now that I need it, I cannot find it. Does anyone know were to find such an article?
6
3064
by: GaryDave | last post by:
My school registration database has not been quite right after a recent compact and repair (done while I was away). Though most of the many forms and subforms are working normally, one form in particular will no longer allow new entries into the subform - the recordset of the underlying query is no longer updatable. The subform in question enters the identity and other vital info for children whose parent's ID provides the FK, linking...
2
1269
by: authorking | last post by:
How can I create and access a microsoft access database?
1
3174
by: Michael Meckelein | last post by:
Hi, My csharp application access a MS Access database through odbc connection. Is there a way to compact the Access database after deleting records using the odbc connection?
5
1505
by: davepisarek | last post by:
I am looking for a quick and dirty way to create a hyperlink that will open a Microsoft access database written in asp.
1
2144
by: 1064871 | last post by:
Hi How to insert Data in Microsoft Access database using VB.net regards adil
11
12025
by: Saher | last post by:
Thanks, for the help! hey guys, thanks 4 the help. By the way my access still wont work, but its alright, because i dont need to use it immediately, and im getting a laptop, so it shud be fine. I wanted to ask another question, for my coursework. Can u set reminders in a microsoft access database, and if yes, how? Thanks saher!!
1
2251
by: ncsthbell | last post by:
I have an Access 2000 database (running on Windows XP) that is used as a model and each user grabs a copy of this and puts onto their own drive. I have had 2 folks have issues with it lately. When they try to open it, the application does not fully open. What you see is a blank grey form with the dark blue title bar at the top with the appliation title. The 'main' form that is set on the startup properties does not come up. Everything is...
4
2731
by: Bob Alston | last post by:
For those of you that have replicated databases, how often to you compact and repair them? Also what mathod do you use if you do this on an automated way? How do you make sure that the automated process is successful and if not, what process of notification is used? Bob
0
8002
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,...
0
8496
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8148
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,...
0
8338
tracyyun
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...
0
6816
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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5475
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();...
0
3962
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...
1
1594
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1329
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.