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 blank. When I click the 'x' in the on the upper right to close it, I get the standard MS error stating the an error has been encountered, do you want to send it to MS.
I have gone into the database in design mode, tried to compact & repair but an error pop-up box comes up with the blue title bar 'Microsoft Access' and an error stating 'Record is deleted'.
I have also gone into the code for the event 'form open' for the main form and tried to put a debug statement and it when I close the form, I get the same 'Record is deleted' error.
I had the user get a new copy of the database and it works. However, I had the same thing happen to the another user today so it has become a re-occuring event I need to resolve. Any ideas???????
1  2261 
It sounds like one of the system tables might be corrupted, but maybe not. Can you create a new blank database & import all the objects from a fully-working copy into the new one? If that succeeds, it was the system. If that fails, it will most likely stop on whichever of your Access objects is corrupted. If the import doesn't work at all, you'll need to find a known-good copy & use that as your new master.
If the preceding "works", but it continues to malfunction, another thing to look at is - if you are using Memo fields anywhere, see if you find #Error displayed in a Memo field. Access 2000 sometimes has trouble with those fields. If that's the case, you would need to copy that record (without the memo field) into a temp table, delete the bad record, and then re-append from the temp table. The contents of the Memo would be lost.
Hope that helps.
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: L Mehl |
last post by:
I tested a FE/BE application developed in A2000 on a A2002 machine and got
this message when exiting the app. Clicking the only available button "OK",
exits the application, as intended.
The FE is just the mdb, not an mde. FE and BE are in different directories
on the same machine.
Are there settings, preferably via code, that I can add to stop this error?
Thank you for any help.
|
by: adirat |
last post by:
I have read a lot on this subject on newsgroups and other access
related websites on data corruption, but since we are still not able
to isolate the problem – I am posting this detailed explanation of my
problem:
We have a 23 user environment with Windows advanced server and windows
2000 clients with access 2002 running on all clients in a FE/BE
format. The problem is our database gets corrupted almost 3-6 times on
a busy day (lot of...
|
by: Ken Davis via AccessMonster.com |
last post by:
I get this error message when trying to compact and repair my database:
(Could not find field "Description"). When I clicked on Help, the error message number comes up as (Error 3799) It's the first time I see this. Help anyone?
--
Message posted via http://www.accessmonster.com
|
by: ship |
last post by:
Hi
We need some advice: We are thinking of upgrading our Access database
from Access 2000 to Access 2004.
How stable is MS Office 2003? (particularly Access 2003).
We are just a small company and this is a big decision for us(!) It's
not just the money it's committing to an new version of Access!
| | |
by: Gary |
last post by:
I have recently placed an access database (back end) on a network folder.
The standalone pc's accessing the network have in their own respective C
drives a copy of the database (minus the table). I have linked the backend
source table to these front end database copies.
The networking has been working nicely but the other day, I got a message
when trying to access the database stating that the format is not a
recognizable one... ie i...
|
by: MAILTONRK |
last post by:
Hi,
I am a Mainframe guy. I am working with MS access(maintaining a
application) for the last 2 weeks.
I had one master database and four replicas. One of my replica had
trouble in synchronization(It said, database is in use..). After
searching google, I ran "Compact and repair" utlity against my replica.
It looks like, it has changed the attribute of my replica.
|
by: John Baker |
last post by:
Hi:
I have read a number of threads on the issue of compressing (compacting) Access data bases
programmatically, and have been left confused. We are using Access 2000, and I need code
that will programmatically compress an open database. (called "InvoiceManagement.be).
Can someone give me a piece of code that will do this, or a pointer to one, please?
Thanks
|
by: advance scout |
last post by:
HELP! My database is suddenly corrupted. My computer was acting funny
(very sluggish) and was shut down. Access had been already been closed down
but computer was acting very slow , so perhaps it was still open. I am now
getting a "The data base ... is corrupted and needs to be repaired" error .
I have made copies of the corrupted database so that I could try to repair
and still have a corrupted copy available. When I try to repair , it...
|
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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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...
| | |
