MS Access is relational database application. To use it in documents without retyping, Word merge is used. But sometimes, when you export a table from MS Access database to the MS Word Merge format, you may receive the following error message:
“The data being exported does not match the format described in the Schema.ini file”
This problem occurs after a successful export of table from the access database.
In the case of exporting a table from MS Access project or a query from the database the MS Word Merge format, the error message may appear like:
“The Microsoft Jet database engine could not find the object ‘filename’. Make sure the object exists and that you spell its name and the path name correctly.”
The reason behind it may be that when you first time export the table or query, the field names for the Microsoft Word Merge format are stored in the schema.ini file. The schema information file is always named schema.ini file and always kept in the same directory as the text data source. It provides the general format of the file, the column name and the data type information. So after a filed name in the source table or query is modified, the previously exported fields no longer match the names of the new fields. So when next time you try to export the table or query, you receive the above mentioned error messages. The other reasons may include corruption in the access database. So when you try to import the table or query it may generate errors.
Microsoft has suggested opening the schema.ini file with a text editor like notepad and then deleting that part which may be creating the problem. This problem may get resolved by this method but may create further database corruption like problems, in case of any mistake. Also the databases which are already corrupted need to be repaired. In both the cases you require a tool which could do Access repair and the same comes under the name of Access Repair software.
The Access Repair software are powerful enough to repair the Access databases in any of the case of database corruption. They can extract the data from the corrupted mdb files by applying the powerful algorithms. Data in the access databases may be of great significance to the user and his business, so choosing the best one is obligatory.
Stellar Phoenix Access Recovery software is the leading and the most advanced software for this. This access repair software can repair all the fields, query and tables of the database. Access Repair becomes quite an easy task for the user with its interactive and easy to use user’s interface. This access repair software works well with all the file versions of the Access like Access 97, 2000, 2002/XP, 2003 and 2007.
This access repair software does a complete scan of the corrupted mdb files and with its demo version you can preview the repairable files. This demo version can be downloaded from the website itself without any cost. To use the actual software no kind of vast technical knowledge is demanded from the user’s side.