Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 15th, 2007, 10:44 PM
Registered User
 
Join Date: Jun 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default MSysCompactError Table Help!

Hi,

I am continually having a problem with my input form. I currently have 5 users entering data into an Access database (2003) form. I am told that the database freezes and does not save the data entered. I noticed that a table called “MSysCompactError” is created when an error occurs. The MSysCompactError table has an ErrorCode column, ErrorDescription column, ErrorRecid column and ErrorTable which lists the error codes and descriptions (see below).

I see the error “Could not find field ‘Description’”. What does this mean? I do not have a field called “Description” in the table.

ErrorCode ErrorDescription ErrorRecid ErrorTable
-1504 Could not find field 'Description'. fd_log_table
-1504 Could not find field 'Description'. fd_log_table
-1504 Could not find field 'Description'. fd_log_table
-1504 Could not find field 'Description'. fd_log_table
-1504 Could not find field 'Description'. fd_log_table
-1206 Could not find field 'Description'. fd_log_table

I looked up the description of the error code numbers and I would really appreciate if one of you experts could interpret my errors.

ErrorCode:
1504 - Null not valid
1206 - Non-db file or corrupted db

Thanks.

MLR
 
Old June 18th, 2007, 02:51 AM
Registered User
 
Join Date: Oct 2006
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

Do you get these error messages when the users are entering the data, or when you try to compact the database?

I have the same problem with some of my larger databases and find that when I try to compact I receive this error. It is always that I have run out of space on the shared drive. I copy the database to a larger drive, ie c: or other local drive and compress there, then overwrite the old one with the compressed version. I then archive the compressed version I have on my local drive (Just in case of problems).

My guess is not enough room where the database is located.

 
Old June 19th, 2007, 12:10 PM
Registered User
 
Join Date: Jun 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello Martinrhague,

Thank you for your response.

No, I never receive this table when compressing the database. The table generates when users attempt to add a record to the fd_log_table.

I have the database split and the back-end is located on a server that is generally slow. The server currently has 719MB of free space and the database is 12,616KB.

Do you think that a sluggish server and the current amount of free space is causing the issue?

I appreciate your help and time. :)

MLR





Similar Threads
Thread Thread Starter Forum Replies Last Post
very urgent:cals table to indesign table using xsl franklinclinton XSLT 1 December 16th, 2009 03:48 PM
Populate a List Box with Table Names & Table date hewstone999 Access VBA 1 February 27th, 2008 10:10 AM
Sort Table Columns by Table Header Attribute omrieliav XSLT 4 June 7th, 2006 01:05 AM
(oracle 8i)Alter Table <table> coalesce partition combo Oracle 3 October 13th, 2004 09:35 AM
size of table (type table is table of number) MikoMax Oracle 1 November 19th, 2003 03:11 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.