After compacting my database, I have the following in MSysCompactError
ErrorCode, ErrorDescription, ErrorRecid, ErrorTable
-1605,Could not find field 'Description'., ,tblFundClient
-1017,Could not find field 'Description'.,?O,UNDERITE
-1613,You cannot add or change a record becuase a related record is required
in table 'CLIENT'., , UNDERITE
Can anyone help me make sense of this?
There is no field named 'Description' in either tblFundClient or UNDERITE.
I guess the next thing I'll try is remove any unrelated records in UNDERITE
that corrospond to CLIENT. Can anyone help me with this too.
CLIENT is the main table. I want to remove any records in UNDERITE that is
not in CLIENT. How would I go abouts making this delete query.
Thanks.
1  8535 
"Kit Truong" <ki*@e-nablesolutions.ca> wrote: After compacting my database, I have the following in MSysCompactError
ErrorCode, ErrorDescription, ErrorRecid, ErrorTable
-1605,Could not find field 'Description'., ,tblFundClient
-1017,Could not find field 'Description'.,?O,UNDERITE
-1613,You cannot add or change a record becuase a related record is required
in table 'CLIENT'., , UNDERITE
Can anyone help me make sense of this?
There is no field named 'Description' in either tblFundClient or UNDERITE.
Sign of corruption but may be due to a self join. See the Access Corruption FAQ at
my website.
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
by: Sam Smith |
last post by:
I have a 2003 10 user database program with all the latest service packs and
patches for Access and Windows.
Once a week I get a corrupt MDB file with errors in the MSysCompactError
table of...
|
by: jerry.ranch |
last post by:
I've a database that is about 11mb, 117,000 records, about 15 fields.
When I run simple queries on the table, the database crashes
I've never seen anything like this before, any ideas?
This...
|
by: JamesDC |
last post by:
Hey all,
I have two problems with trying to upgrade an access file, not written by myself.
This first is that I'm trying to change the items on a dropbox list, and they are linked with the...
|
by: Mai Le |
last post by:
Hello,
I had a database access. It's working fine on my destop, but my laptop wasn't. I didn't know why I couldn't read any table in database. When I opened databese, it generated a table...
|
by: yanzhang |
last post by:
Hi everyone,
I have a question here and need your help.
I have a Access application linked to another Access database. The database recently keeps corrupted. After repair and compact, I got...
|
by: DaveSlade72 |
last post by:
Whilst trying to update my Access 97 database I'm getting the error message:
"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
|
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,...
|
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...
| |
