HI all,
Although i have another topic at the moment, I'm starting another, as the issue seems to have changed as fixes have been attempted. As a result, I felt it may be better to make a fresh start in the topic thread, so that I can highlight exactly what's happening, and what we've done to try.
Here's a brief overview of what happened at the start of the issues:
Currently the issues I'm facing are:
ErrorCode ErrorDescription ErrorRecid ErrorTable
-1206 Could not find field 'Description'. ꬂ tblRequest
-1053 Could not find field 'Description'. tblRequest
I have so far attempted the following, and I'm still having issues, so I am assuming that they haven't worked:
I haven't made any changes to the be and fe prior to this happening, so I'm sure that it wasn't me doing something prior to the weekend (plus I always make sure that if I am doing anything, it goes in on Wednesday, so I have time to revert/fix).
At the moment, I'm completely stumped. Every attempt I've made has failed so far and anything I'm getting through Google advises me to take steps i've already taken. :banghead:
At this stage, any advise people give to get us back up and running would be greatly appreciated. As i've been working on it for 5 days and feel I've gotten no where (and still no understanding to why it's happening), I'm pretty concerned.
Many thanks everyone of any help you can give, and I'm happy to answer any questions you may have to the best of my ability.
Also, sorry, i only just thought of saying this, another Access database we use seemed to suffer a similar issue. The applciation isn't anywhere near as complex, and I haven't done any of the steps above apart from compact and repair, but it also went down at approximately the same time on saturday. Does anyone know if there's anything that could cause two independant Access db's to corrupt repeatedly,a s this db does also fail after I compact and repair. Again this has the same errors in the MSys table, even though a field "Description" doesn't exist in the table:
ErrorCode ErrorDescription ErrorRecid ErrorTable
-1206 Could not find field 'Description'. ᬖ tblContact
-1206 Could not find field 'Description'. ᴉ tblContact
-1206 Could not find field 'Description'. ḃ tblContact
-1206 Could not find field 'Description'. Ḅ tblContact
-1206 Could not find field 'Description'. ḅ tblContact
-1053 Could not find field 'Description'. tblContact
Kind regards,
Tom.
Although i have another topic at the moment, I'm starting another, as the issue seems to have changed as fixes have been attempted. As a result, I felt it may be better to make a fresh start in the topic thread, so that I can highlight exactly what's happening, and what we've done to try.
Here's a brief overview of what happened at the start of the issues:
- On Saturday morning (02/11), the backend database corrupted
- I was notified on Monday morning of the issue
- I compacted and repaired the back end
- After this, I found a large quantity of records in one table that were filled with #'s (about 100)
- In additional, there were about 20 more records containing random alphanumeric strings. Some of these has autonumber ID of over 10,000,000, even though the current ID is about 130,000.
- I deleted these records, and checked that the fe booted fine (which it did).
- Shortly after asking the team to go back to use, the be corrupted again.
- Another repair showed some more #s in the records, but only about 4.
- Again, the be corrupted, so i asked the team to hold fire.
Currently the issues I'm facing are:
- The database corrupts after use in the live environment. The time to corrupt appears "random", but is sometimes instant, others takes hours.
- #'s appear in one of the tables, although no records are lost
- Primary keys are also being lost on the same table
- Duplicate data is appearing in the same table (the duplicates appear to be random, as one duplicated record was 6 months old, and hadn't been editted since then)
- Relationsip between the table, and others are breaking.
- Sometimes after a Compact and Repair, a table named "MSysCompactError" appears with data I (see below). Note, there is no field "Description" in tblRequest.
ErrorCode ErrorDescription ErrorRecid ErrorTable
-1206 Could not find field 'Description'. ꬂ tblRequest
-1053 Could not find field 'Description'. tblRequest
I have so far attempted the following, and I'm still having issues, so I am assuming that they haven't worked:
- Compact and Repair
- Updating the db (fe and be), to Access 2002 from Access 200 format
- Converting the fe into a MDE file, instead of MDB.
- Providing a fe client to each agent, instead of using a central copy.
- Creating a temporary tblRequest table, copy the data across, and deleting the old one, before copying back again
- Creating a brand new back end, and then copy the data across using the import function (excluding MSys tables).
- Creating a brand new back end, with all the tables empty. Re-entering system required information, and leaving the rest blank. The new be corrupted as well (on the same table)
I haven't made any changes to the be and fe prior to this happening, so I'm sure that it wasn't me doing something prior to the weekend (plus I always make sure that if I am doing anything, it goes in on Wednesday, so I have time to revert/fix).
At the moment, I'm completely stumped. Every attempt I've made has failed so far and anything I'm getting through Google advises me to take steps i've already taken. :banghead:
At this stage, any advise people give to get us back up and running would be greatly appreciated. As i've been working on it for 5 days and feel I've gotten no where (and still no understanding to why it's happening), I'm pretty concerned.
Many thanks everyone of any help you can give, and I'm happy to answer any questions you may have to the best of my ability.
Also, sorry, i only just thought of saying this, another Access database we use seemed to suffer a similar issue. The applciation isn't anywhere near as complex, and I haven't done any of the steps above apart from compact and repair, but it also went down at approximately the same time on saturday. Does anyone know if there's anything that could cause two independant Access db's to corrupt repeatedly,a s this db does also fail after I compact and repair. Again this has the same errors in the MSys table, even though a field "Description" doesn't exist in the table:
ErrorCode ErrorDescription ErrorRecid ErrorTable
-1206 Could not find field 'Description'. ᬖ tblContact
-1206 Could not find field 'Description'. ᴉ tblContact
-1206 Could not find field 'Description'. ḃ tblContact
-1206 Could not find field 'Description'. Ḅ tblContact
-1206 Could not find field 'Description'. ḅ tblContact
-1053 Could not find field 'Description'. tblContact
Kind regards,
Tom.
Last edited: