Hello,
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?
Thanks!
-BG
2 2587 maxamis4 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
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
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: 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: 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: 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.
| |