473,728 Members | 1,623 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Can't compact BE database due to 'exclusive' error

13 New Member

I'm having a bit of a problem regarding my back-end database for Access 2003. The db is set for shared mode, has no programming code at all, only back-end tables that is shared on our server, that everyone accesses. Everything has been working fine up until today.

So today I need to add about 20 fields to one of our tables (making the total about 40 fields in all for this one table). When I go to save the table, it tells me that I can't because there are too many fields (there aren't). Actually, if I update add even one field it tells me that's too many. So I say "OK, I'll compact the database" wrong again. It attempts to compact and repair the db but it tells me that "You attempted to open a database that is already opened exclusively by user 'Administrator' on machine '[my machine]'. Try again when the database is available".

Of course, the Administrator on my machine is me! So I close all my programmes, try again - no good. I restart my computer - no good. I kick everyone who is working on my database off of their computers and close Access - still no good.

I'm starting to get worried that I'm never going to be able to make any changes to my table fields again. Is this normal?


Nov 14 '07 #1
2 2594
295 Recognized Expert Contributor
My friend your DB sounds corrupt. If there is not to much corruption the easy fix is to create a new DB and import all your tables into the new database. Then you should kick everyone off the db, and delete the old. Also make sure everyone is logged off the database, make everyone restart their machines if you must. The best way to check if someone is in your database is by looking for the ldb file assiocated with running Access applications.

good luck
Nov 14 '07 #2
13 New Member
My friend your DB sounds corrupt. If there is not to much corruption the easy fix is to create a new DB and import all your tables into the new database. Then you should kick everyone off the db, and delete the old. Also make sure everyone is logged off the database, make everyone restart their machines if you must. The best way to check if someone is in your database is by looking for the lbd file assiocated with running Access applications.

good luck
Ack! Don't tell me things like that. lol What my 'fix' so far has been was to create a new db with a new table and populate all my necessary fields, then import that into my current BE DB - now that actually worked okay but it seems like a roundabout way to deal with this and if my DB really is corrupt, then I just have a bigger problem. I'm going to copy all the new table entries then revert back to my last archived DB and put all those entries in.

This has never happened before, is this situation unavoidable or is there some preventative measure I can take against this? Is it possible that someone else can corrupt my DB from another computer (unintentionall y anyway)?

Thanks Maxamis
Nov 15 '07 #3

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

Similar topics

by: MHenry | last post by:
Hi, We were going merrily along for 6 years using this database to record all client checks that came into our office, including information about what the checks were for. Suddenly, network computers cannot access the database. The message is...
by: Paul T. Rong | last post by:
Dear all, My aim is to compact and repair current database, I got the following code from http://www.mvps.org/access/general/gen0041.htm Option Compare Database ' ***** Code Start ***** Public Sub CompactDB()
by: jcazmail-groups | last post by:
The following snippet gives me an error on the line regarding AllowAdditions = False: Private Sub EditLocked() txtDeliveryDate.Locked = True cmdDeliveryDate.Enabled = False cboidCustomers.Locked = True frmOrdersDesignSubForm.Locked = True ' the following line produces the error
by: MLH | last post by:
I just used Tools / Database Utilities / Compact Database in Access 97 for the first time. Unlike Access 2.0, it does not ask me to furnish a filename for it to compact into. It just launched headlong into a process that, after the fact, had the result of overwriting the 44-meg previous size file into an 8-meg file of the same name. Has anyone ever experienced a data-loss during such a compact operation under A97? Surely, the access...
by: owengoodhew | last post by:
Hi, I am responsible for maintaining an MS Access 97 Database that reliably becomes corrupt following a compact......... About the Database: The database is made up of three linked databases, data, input and output. The files all share the same table structures. Recently the input database started growing in size and it became necessary to compact the databases more frequently. Following the compact of the
by: SOS | last post by:
Hi guys, i use of an Access database in my web project . i run "Compact And Repair database" wizard in access on this database. but after it , i get this error when i trying to run web project : The Microsoft Jet database engine cannot open the file 'c:\inetpub\wwwroot\ff\Database.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
by: Redstone | last post by:
When attempting to refresh a link through ODBC to a table (T_Leases) in my SQL backend, I get an error message teling me the Jet Engine can't find an object (A differnet table T_LockTypes in the same SQL). I checked and am able to open, design and query the second table in SQL. There are no relationships between these two tables. I am unable to query the table. I tried to refresh the second table and am told the object does not exist....
by: bob | last post by:
Hi, I use a Access database for my asp.net application. I use this connection string: sConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = c:\mydb.mdb" Now i put a pasword to the Access database and i changed the connection string to: sConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =
by: Bizmark | last post by:
Access2003, Windows XP Pro OEM user OS, Windows Sever 2000 server OS. Not-so-recently I inherited 3 Access DB's from another company merging with our own. Our own system works off of SQL server, but mainting these databases is critical to keeping the business running. 1 database in particular has been causing problems. Along the course we have had a few problems with random records corrupting (new and old) and Values within fields...
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: 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: 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...
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 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.