Introduction:
When queries and forms in a customer's Microsoft Access database suddenly stopped working, Technology Management Partners faced a problem that was not immediately visible in the underlying tables. The database remained accessible, and the tables appeared intact. However, key queries and forms were no longer functioning as expected.
The team first turned to Microsoft Access's built-in Compact and Repair utility, followed by an attempt to rebuild the database by exporting its tables, forms, and other objects into a new database. Neither approach revealed the underlying cause.
With standard troubleshooting unable to explain the issue, Technology Management Partners turned to Stellar® Repair for Access for a more granular way to examine the database.
Background:
Technology Management Partners provides technology management services to its clients, including support for business-critical databases.
In this case, a customer's Microsoft Access database had developed a puzzling issue. Although the underlying tables appeared to be intact, queries and forms that depended on them were no longer working correctly.
For Technology Management Partners, the priority was not simply to make the database accessible. The team needed to determine what was actually causing the failure and restore the database's functionality without compromising the customer's data.
“ Statement from the customer:
The Stellar® software did help in identifying the problem. The tools in the software allowed us to work in specific tables — that's where I was able to determine the problem. The tables were large, and the Stellar® software did resolve some indexing issues and data type problems. What the problem turned out to be — I still don't know how it happened — was that a ‘key’ in a table had lost its ‘key.’ All I had to do was make the field a key again, ‘no duplicates,’ and the problem was solved.
Would I use the software again? Absolutely — the granularity of the repair process helped identify the problem.”
”
Impact on the Business:
The affected database played an important role in the customer's day-to-day business functions.
With queries and forms failing, the issue directly affected the customer's ability to work with the database reliably. While the underlying data was still present, the inability to use key database functions created a risk of further disruption and customer dissatisfaction.
Technology Management Partners therefore needed to:
- Identify the underlying cause of the database issue.
- Preserve the customer's existing data.
- Restore query and form functionality.
- Resolve the issue without unnecessary disruption.
- Find a practical solution when standard troubleshooting had failed.
Attempted Solutions:
Before turning to Stellar®, Technology Management Partners explored the standard approaches available for an Access database exhibiting signs of corruption.
Microsoft Access Compact and Repair
The team first ran Access's built-in Compact and Repair utility. While this is a standard troubleshooting step for Access database issues, it did not resolve the problem.
Rebuilding the Database
The team then attempted to create a new database by exporting the existing tables, forms, and other objects into a new database shell. This approach also failed to identify or resolve the underlying issue. The database still contained its data, but the reason queries and forms were failing remained unclear.
Solution:
Technology Management Partners contacted Stellar® Technical Support and worked through the issue using Stellar Repair for Access.
The key difference was the ability to work with the database at a table-by-table level, rather than treating the database as a single file. This gave the team greater visibility into the individual database structures and helped narrow down where the problem was occurring.
During the repair process, the team was able to:
- Examine and repair individual tables.
- Identify several indexing issues and data type problems.
- Isolate the table associated with the database failure.
- Identify a field that had silently lost its designation as a Key with No Duplicates.
- Reinstate the key designation on the affected field.
Once the key was restored, the database's queries and forms began functioning normally again.
The granular repair process was particularly important because the underlying issue had not been apparent through the earlier whole-database troubleshooting attempts.
Conclusion:
For Technology Management Partners, the challenge was not a database that had simply stopped opening. The more difficult problem was that the tables appeared intact while dependent queries and forms were failing.
Standard Compact and Repair and manual database rebuilding did not reveal the cause.
By working at the table level with Stellar® Repair for Access, the team was able to investigate the database more granularly, identify indexing and data type issues, and ultimately isolate a field that had lost its key designation.
Restoring that key resolved the underlying functionality issue and brought the database back to normal operation. For Jeffrey Tabler, the granularity of the repair process was the key takeaway.
For IndividualsBack to main menu
Data Recovery
File Repair
Data Erasure 
For BusinessBack to main menu
Email Repair
Email Converter
Email Migration
File & Database Repair 
Toolkit
Forensic
Lab Services 
Our Partners 
About
Resources
Support 
Contact us 
Company
Leadership 
Media Coverage
Press Releases
Career 
Case Studies
Blogs 
Articles 
Videos 
