Article Views:
75
Ezine ready page
Ezine ready page
Posted on July 21, 2008 by spear | Posted under Data Recovery
Enter password (when one hasn't been applied!) error message in Access
|
Some error messages are harmless and serve as mere warnings so that the user becomes cautious in advance but there exists some error messages that occur only when grave faults take place and impede the normal functioning of the application. Promptly responding to error messages is an absolute mandate if you are desirous of saving your files and folders from corruption and damage. Discussed below is one such error message that makes its appearance under the following circumstances. Enter password (when one hasn't been applied!) error message flashes on the screen when you attempt to directly open and save a Microsoft Access database - In a non-Access application such as Microsoft Word, Microsoft Excel or Notepad - When the application that is used to open the database automatically saves the document after opening it like in the case of a macro in Word. - When a non-Access application contains a macro virus that causes the applications to save documents automatically even if you have not saved it on your own accord - Use of a hyperlink from another Microsoft Office program to open the database - You made use of a Microsoft Visual Basic for Applications (VBA) automation code to open the given database Whenever the database is opened or saved in any of the manner stated above, a password prompt appears even if you have not set a password for the database. It poses a problematic situation as nothing permits you to bypass the password prompt. The only explanation for three of the above problems is the fact that Microsoft Jet database engine being a distinct binary format doesn't allow recovery, access repair , or compact of an Access database file that has been saved to any other format. The database is rendered completely unusable to Access and neither is the data decipherable when saved to a non-access application. Thus it's desirable not to open a Microsoft Access database in applications other than Access. If it proves to be an absolute necessity, try linking to it through ODBC or Office Links. As regards the last two instances that instigate this error message, the reason is as follows: After opening, you compacted the database (be it manually or by setting the Compact on Close attribute of the database) and discovered that the database password was unexpectedly set on the database. This would invariably hinder you from accessing the database by opening it directly in Access. Thus the need of the hour is exporting each of the objects into a new database by using either a hyperlink or VBA automation code. This would help in recovering the data that lies trapped in the database. If these techniques work fine for you, nothing can get better but if these tips are not solving your problem and the error message is stubbornly persisting, its time to take it to a Data recovery Lab cause it's a clear indication of corruption eating into your system. If your data is precious and you are in no mood to part with it, rely on Stellar Information Systems Ltd, a pioneer in the data recovery industry with 15 years of experience. Stellar has devised a quality data recovery utility for recovering and repairing lost .mdb files. Stellar's Access Recovery software effectively repairs and restores the corrupted access database. It is equipped to deal with any problems that might entail repair of any of the components of the Access database including tables, forms, reports, queries and macros. About The Author: Spear is a freelancer for Stellar which offers data recovery software and file recovery programs for different OS and file system including data recovery mac, data recovery linux, access repair, pst recovery and many other programs. |
Tags: ACCESS RECOVERY, ACCESS REPAIR
