473,890 Members | 1,903 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Corrupt record in Access 2003

I have a corrupt record that disappears after a compact, but reappears
several days later. This is on a widely distributed Access 2003
application that is used by about 100 users. The database itself is
only 70mb, but the problem this record causes is widespread. As soon
as the record appears again, reporting gets thrown off in a major way,
kicking out an "Invalid Argument" error when virtually any report is
attempted.

Any advice?
Jan 5 '08 #1
1 2249
"sh*********@gm ail.com" <sh*********@ao l.comwrote:
>I have a corrupt record that disappears after a compact, but reappears
several days later. This is on a widely distributed Access 2003
application that is used by about 100 users. The database itself is
only 70mb, but the problem this record causes is widespread. As soon
as the record appears again, reporting gets thrown off in a major way,
kicking out an "Invalid Argument" error when virtually any report is
attempted.
Is this the same record that gets corruption? Or the same table? Is this a memo
field?

Compact end repair may not get rid of a corrupt record. After compacting I would
suggest viewing the table, resize the columns so they are all visible on the screen
and scroll down the screen until Access pukes and dies. Or you can visit See the
Corrupt Records in a Microsoft Access MDB page at my website
http://www.granite.ab.ca/access/corr...uptrecords.htm for some code.

Now just how is this database widely distributed? Or you on a LAN, WAN? Is it split
into a FE/BE?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Jan 6 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
5088
by: aaj | last post by:
Hi all I have been given a corrupt access 2000 backend and asked to salvage the data.(youve gussed it, no backup) On trying to open it just kicks me out saying its not a valid database file - so I can't even use the internal compact/repair function I have tried the usal stuff i.e. Trying to repair via another access program using dao
21
2743
by: Dan | last post by:
Hi, just ran into my first instance of a backend Access97 database not compacting. I'm getting the "MSACCESS.EXE has generated errors.." message on compact. I've narrowed it down to the largest table which cotains 600k of records. I've tried copying the database and trying to compact that -doesn't work. I've tried Repair and then compact which also doesn't work. I've tried to create a new database and import the tables but it flakes out...
4
2211
by: Big Time | last post by:
Major fiasco on my hands here. I was in the middle of updating a record when the system halted, and the Access DB became non responsive. Eventually I had to CTRL-ALT-DEL to close the application. When I tried to open the DB again, the file has become corrupt and I get the error message "The Microsoft Jet database engine cannot find the object "Databases". I understand a database can become corrupt during an interrupted write to a...
0
1302
by: John Phelan | last post by:
I had a very large number of query statements that I had converted to SQL a long time ago aticipating that I would some day upsize my application. Every now and then when I do an import to a new application, some of the forms will import corrupted, and crashing the whole application, though it works fine in the old application. Today I did some experimenting on the two most recent corrupt form files. I discovered that even when I...
0
1247
by: jpatrick | last post by:
I had a very large number of query statements that I had converted to SQL a long time ago aticipating that I would some day upsize my application. Every now and then when I do an import to a new application, some of the forms will import corrupted, and crashing the whole application, though it works fine in the old application. Today I did some experimenting on the two most recent corrupt form files. I discovered that even when I...
4
1942
by: dixie | last post by:
I have come across some code to walk through the records of a corrupt table and copy it record by record to a new table. It comes from the MVPS.Org site and is as follows. ----------------------- (Q) How can I recover records from a corrupt table? (A) First, using Access while in the database window, copy the table's structure only from the corrupt table, if possible. Then using the code below, copy each individual row from the old...
5
2120
by: Jeff | last post by:
I'm sorry if I am appearing noobish, but I'm a C programmer that inhereted access because I'm the only "computer guy" in the office. Now I've found some problems that I fear maybe a corrupt database.... and I haven't the faintest of clue where to start when it comes to fixing this problem. Here is what happen: About a week ago the registrar came to me to ask if I could help her add a record to her training database. She told me that...
4
2413
by: nepdae | last post by:
Well, after reading and hunting all over the web, including here, I still haven't been successful in my attempts to resolve my situation. So, I thought maybe I'd just ask. Here's the situation: I have an Access 2000 database (~15 users), split into a front- and back-end. Each user has a local copy of a workgroup file and the data file is out on a server. The problem started when the IS department upgraded the server at night, touching...
13
2701
by: Owen Jenkins | last post by:
Following on from an earlier post... I can reliably corrupt a record by doing the following ... Open two separate but identical front ends on one PC each linking to the same back end. Edit a records in one front end and leave it unsaved. Edit the same record in the other front end and save the change. Save the change in the first front end - this pops up the Write Conflict message to which I click Save.
0
9976
marktang
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...
0
9814
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
11214
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...
0
10449
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...
1
8006
isladogs
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...
0
5834
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...
0
6034
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4659
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
3
3266
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.