Error Number 3800
Suggest Category Add a new article - Add To Favorites - Comment on this article Partners CertifyPro Certnotes kalliance.com www.cbtplanet.com Hardware Tutorials BGP Configuration Home > Articles > Tips to resolve Run Time Error 3800 message in MS Access 2002 Tips to resolve Run Time Error 3800 message in MS Access 2002 Added: 08/17/2009, Hits: 7,155, Rating: 0, Comments: 0, Votes: 0 Add To Favorites | Comment on this article Tables in MS Access database are the primary storage components to store user's records. While this database component is easy to open, there are possibilities that when you attempt to open the tables, an error message pops up. This error message does not allow you to access any records saved in the tables. In such situations, an ideal way is to restore the tables from an updated backup. But if in case, no backup is available or backup falls short to restore the records, then you will need to use advanced access repair software. As a practical example, you encounter any of the below error messages when you attempt to view records saved in Finance table: “Error 3800: AOIndex is not an index in this table.” Or “Run-Time Error '3058' Index or Primary key cannot contain a null value” You encounter the same error message every time you attempt to open the Finance table. Furthermore, the data stored in the Finance table becomes inaccessible after the above error message appears. Cause: The above error message primarily occurs due to damage or corruption of index in system table. Resolution: To resolve the above run time error message, you will need to repair the Finance table by using an inbuilt repair utility named “Compact and Repair”. Below are the steps that enable you to repair the table: 1.You will need to select Database utilities on the Tools menu, and then click Compact and Repair Database. 2.Next, click the database in the ‘Database to Compact From’ dialog box, and then click Compact. 3.Lastly, you will need to select a correct folder location for the new file in the ‘Compact Database Into’ dialog box, type a unique name for the
Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rating: Display Modes 03-02-2011, 01:53 PM #1 AUGuy Newly Registered Idiot Join Date: Jul 2010 Location: Auburn, AL Posts: 135 Thanks: 9 Thanked 7 Times in 7 Posts "FieldName" is not an index in this table. Error 3800 http://www.techtutorials.net/articles/tips_to_resolve_run_time_error_3800_message_in_ms_access_2002_a.html This is the code i'm using, error line highlighted: Code: Option Compare Database Public Function VerifyAcct(AcctNum As String) Dim dbDatabase As Database Dim rsAcctNumber As Recordset Set dbDatabase = CurrentDb Set rsAcctNumber = dbDatabase.OpenRecordset("CAM_Portfolio_Query", dbOpenTable) With rsAcctNumber .Index = "Account-Number" .Seek "=", AcctNum If .NoMatch = True Then MsgBox "NotFound" Else MsgBox "Found" End If End With http://www.access-programmers.co.uk/forums/showthread.php?t=206101 End Function It is giving me Runtime 3800, "FieldName" is not an index in this table. In the table CAM_Portfolio_Query, I set the [Account-Number] field to be both the key and indexed, with no duplicates allowed. Yet i still get this error. Any thoughts? Thanks, Guy __________________ A little thanks goes a long way. Show the "Thanks" button some love if someone solves your problem. AUGuy View Public Profile Find More Posts by AUGuy 03-02-2011, 02:00 PM #2 John Big Booty AWF VIP Join Date: Aug 2005 Location: Planet 10, by way of the Eighth Dimension Posts: 8,263 Thanks: 113 Thanked 994 Times in 864 Posts Re: "FieldName" is not an index in this table. Error 3800 Wild guess mode; The embedded minus sign may be causing your problem; avoid using special charters in field and object names, limit yourself to alpha and numeric charters and the underscore (_) __________________ ...but they're only monkey boys!!! John Big Booty View Public Pro
Help for Downloading Add-Ons Genelines GenSmarts Charting Companion Heritage Collector Suite Map My Family Tree Passage Express Pocket Genealogist TreeDraw Training View Training Videos View Webinars Help Center Troubleshooting Help Submit Support Ticket Make http://support.legacyfamilytree.com/article/AA-00308/0/Error-3800-xxxx-is-not-an-index-in-this-table.html a Suggestion How to import files from other programs Learn to Use Legacy Tips Frequently Asked Questions Email Lists User Groups Affliliates Sitemap Contact Us News Daily News Email Lists Calendar Press Legacy Cruise http://ipswitchft.force.com/kb/articles/FAQ/What-does-General-Failure-Error-code-3800-Mean Online Store Legacy Products Upgrades Add-Ons Wall Chart Prinitng Magnifiers Legacy QuickGuides® Quick Reference Guides Mobile Apps (Android/iPhone/Windows Mobile) Software and Books Training Videos Html CSS Menu Css3Menu.com Home Error Messages & Problems error number Tools Categories Error 3800 - 'xxxx' is not an index in this table Author: Jim Terry Reference Number:AA-00308 Views: 2453 Created: 2013-11-07 02:29 PM Last Updated: 2016-05-24 10:53 AM 0 Rating/ Voters 1. Repair your Legacy program by updating it. LEGACY: http://www.legacyfamilytree.com/DownloadUpdate.asp LEGACY 7.5 OR EARLIER: http://support.legacyfamilytree.com/article/AA-00899 and download the final release (build) of your version. You may also wish to read "How to Install Legacy 7.5 error number 3800 or earlier on a Windows 8, Windows 7 or Windows Vista computer" at http://support.legacyfamilytree.com/article/AA-00897. 2. Reset Legacy’s temporary folder by clicking on Options on the menu bar, then selecting Customize and clicking the Locations tab. Next, click the Reset button for the “Location of Temporary File.” 3. Export your records into a new Family File. Click on File on the menu bar and select Export To / Legacy File from the Fie menu. Give the new Family File a name different from any others in use and click Save. When the Export screen opens, click the Start Export button. If prompted, click the Don't Assign a Source button. Open the new Family File and use it. (You can delete the old file when you are satisfied everything is OK.) 4. If these steps fail to correct Error 3800, please restore your Family File from your most recent backup. Knowledge Manager by: KnowledgeBase Manager Pro v6.2.2 Knowledgebase JavaScript must be enabled in order for you to use Knowledgebase Manager Pro. However, it seems JavaScript is either disabled or not supported by your browser. To use Knowledgebase Manager Pro, enable JavaScript by changing your browser options, then try again. Learn more.
What does General Failure - Error code 3800 Mean?Printable View «Go Back Information Article Environment Metadata Information Summary Question/Problem: What does the error "General Failure - Error code 3800" mean and what can I do about it? Product:  MOVEitCentral Version:  All Platform:  All... Article Type FAQ Last Published Date 9/10/2015 5:49 PM Last Modified Date 12/11/2015 10:56 PM Article Article Number 000002676 Title What does General Failure - Error code 3800 Mean? Description Question/Problem: What does the error "General Failure - Error code 3800" mean and what can I do about it? Product: MOVEitCentral Version: All Platform: All Solution Answer/Solution:This error is coming directly from the network level. The error itself is not very descriptive. What this means is that something failed in transit but there was no error message reported. To address this you will need to trace the network connection to figure out where the breakdown is occurring.  Environment Version All Versions Metadata Keywords General Failure, Error, Central Copyright © 2016 Ipswitch File Transfer, All Rights Reserved. | Ipswitch Portals | Privacy