Wednesday, October 22, 2008

Numerous Ways to Protect Your MDB File

Microsoft Access database file is designed to be used by the MS Access program or other program such as ASP. Your Mdb file can only be protected by employing features and methods understood by these programs. Otherwise anything done to the MDB file outside these methods would make the file unreadable.

Many people upload their MDB files to the same folder as their ASP files. Then they think about it a bit, and assume they need to create a DSN to put the MDB file outside of the web folder and refer to it with a local path. This is certainly one way to prevent people from downloading your Access database, but it is not likely the best. For one, a DSN is less efficient, and you can use a non-web path in a DSN-less connection string. Next, you're going to have a hard time updating your database structure if you need physical access to the local file system in order to see the file at all.

One more method is use of FTP’s folders, but if you think FTP is any more secure than making someone guess the location and filename, you're wrong. Unless you name your database "database.mdb", I doubt very much that anyone would be able to find it. If you name your database file some odd name like FHQWHS.mdb, then it's probably pretty safe from anything.

You might have imagined that those would be all of your options, but I think the best is naming your database file something like FHQWHG.asp. This way, even if someone were to guess the location, if they typed it in the browser and tried to download it, they'd get nothing but garbage since IIS will try to process it as an ASP file. The Access interface itself has no issues saving or opening an MDB file with any other extension.

But still in some case due to saving MDB file in this form cause corruption in database file and high loss of database loss and corruption. In this situation compact and repair utility also doesn’t help to us. Now we need some recovery or access repair softwares. Access repair software repairs all the forms, queries, macros, modules, reports and data types which have been used by the user while developing its database.

Stellar Phoenix access recovery utility is best tool for repair and recovery of database or mdb files. It is one of those access repair software that provides the most excellent options comparatively. This Access Repair software works well with all the file versions of Access counting Access 97, 2000, 2002/ XP, 2003 and 2007. This software can also repair the fields and the images included.

Sunday, October 19, 2008

Microsoft Access Error No 3079: “The search key was not found”

Sometimes when your database File (DBF) linked to an Access XP database to run a query can show some error such as MS access error 3079. This error message related to search key when you try to change design view or changes in new object in multi-user environment. This error message may like:

“The search key was not found in any record”

In this scenario, you may see the database object listed in the Database window, although the save attempt failed. There is high chances of your database begins to enter bizzare characters in certain fields due to corruption and that your database is unusable until you repair and compacted the database

We will discuss all the possible reason for this error. This problem comes due to you loose the record which required for run that query. The database was created while using a workgroup file (System.mdw) is created with Microsoft Jet older version, and the workgroup file currently in use is created with Microsoft Jet 4.0 SP5. It may occur when an ISAM SEEK is being executed and there are no matching values in the index. One more reason is due to corruption in jet database which causes key value is missing and that’s why you get this error.

To get solution of this solution you should follow some steps such as you should avoid to index memo field. If you have indexed memo filed then search for index memo field and the remove the index from that field and then reset your primary keys. In this way you can get rid from this error.

If this error cause due to jet database corruption or due to missing key value then you must install latest Jet hotfix service pack or compact and repair utility tool. In case of compact and repair you may lose some records that cause other database error. Here is good option to repair your database with access repair software. There are many special software programs are available that are designed to repair and restore the corrupted access database.

These access repair tools repairs the corrupted database objects including forms, tables, queries and macros and restore them without modifying the original contents. Stellar phoenix access recovery is one of best software which is able to restore the corrupted access database in almost all possible cases of corruption. It also repair and recover relationship b/w database as well as compatible with earlier file versions of Access such as 2007, 2003, 2002/XP and 2000.

Wednesday, October 15, 2008

Repair Damaged Jet Database 4.0

Microsoft access is a tool to create database files as MDB format to maintain our records. MS Access can use data stored in Microsoft SQL sever, Jet database and compliant data container. There is some circumstances such as technical and physical cause due to them we can’t access our important database. These causes resemble the damaged database files.

The sign of damaged or corrupted access can range from inability to access any object to deletion of whole record. For fixing this type of problem MS access provide us Jet 4.0 service pack and compact and repair utility. Jet 4.0 fix problem like “invalid argument error when you tried to create link table using ADO” or double appearance of oracle integer files and performance problems during run of pass arguments. As Jet 4.0 database make easy our work but it also has some limitation. Sometimes Jet database get corrupted because Its memory management feature doesn’t work in context indexing operation so does not work properly during backup operation.

Common Cause of error:

  • Interruption in write operation of MS access
  • Faulty network or hardware
  • Mismatch or Incompatible version of jet database
  • Opening and saving file in another program.

This type of problem can be fixing by Jet 4.0 database engine rollup or installing Jet hotfix suite. If still your Jet database is corrupted then through Microsoft compact and repair utility you can recover your Jet database file. Procedure to recover Jet database file:

  • Install latest version of Jet database.
  • Take back up of MDB file and close this MDB
  • Now delete LDB file.
  • Run compact and repair utility from tool menu.

In this way you can repair or recover your Jet 4.0 database. If your database is probably damaged beyond repair and you are not able to repair the database. Contact some data recovery consultant or use Stellar Phoenix access recovery tool.

Stellar Phoenix access repair is easy to use and within few clicks repairs the important database files or mdb files. This access repair program recover table, queries, forms, reports, modules, relation database, OLE object, Jet 4.0 database and scan whole database object as well as check for possible error to fix them. This software is compatible with various file versions including MS Access 97 / 2000 / 2002 / XP/ 2003 / 2007.

Monday, October 13, 2008

Easy Way to Repair a Corrupted Access 2000 Database

Microsoft access is a good database tools to save secure information. MS access save information helps us for creating important database which is called mdb files. Microsoft Access is very useful to us because it makes ease to accessing information from database. To create a database we follow steps such as database creation, data input, query and reports.

When creating Microsoft Access Forms for your database application, there are many times when you may come across error messages when user interaction takes place. Sometimes error messages in Microsoft Access may appear completely unpredictably or at sometime due faulty network, interrupted write operation or saving a database file in another program.

Due to above fault you can lost your important database file. You get a error message from MS access such as record is deleted, conflict error, file not supported. In This case your data become completely inaccessible; even you can’t access your whole database.

For getting rid from this type of data loss you must have a data backup. Incase you don’t have a backup then you have to repair access file. You can do it with compact and repair utility in tool section of MS access. This repair utility works in most of the database corruption cases. There are some cases when this utility doesn’t work and you will not able to repair access file. Now you need some special Access Recovery software to repair your damaged Access database files.

Stellar Phoenix Access Recovery is advanced data recovery and restore tool used when you fail to repair your corrupted database using inbuilt repair tools of MS Access. This software has enhanced data repair capabilities that recovers queries, forms, reports, macros and Visual Basic module of corrupted database. Some Access recovery softwares are user friendly.

Stellar Phoenix access recovery software is robust access recovery software that uses advanced searching algorithms to search and locate the corrupted and damaged Access database files and repair them. This software provides fast and secure recovery for home users, small business and large organizations. This software provides a cool and simple user interface to their users. Stellar Phoenix Access Recovery software supports all file versions of MS Access including Access 2000, XP, 2003 and 2007.

Sunday, October 12, 2008

Unexpectedly Closing of database in Design View

While we are using MS access, the fastest and easiest way to create a query is use of Design view. For creating query using design, you have to follow some steps such as go to the Show Table dialog box, to select a table, you can click it and click the Add button, or you can double-click the table. As this method is easy for creating table in compare to form view but sometime user face some error messages such as:

The operation on the Chart object failed.

The OLE server may not be registered.

Even your data get corrupted and unexpectedly closes when you open query in design view. Interestingly, it doesn't crash if you run the same database and open it in form view! This error may come due to database corruption and one more issue is nameAutocorrect option. The problem is almost certainly caused by Name AutoCorrect - a "feature “where Access is supposed to keep track of things when you rename them, and
let your database keeps working with the new name. But the feature only works partially, and when the names don't match completely, your database is corrupted. It may possible that there is some changes in field name in table.

To workaround for this problem you should check the table and check for field name in a table. Then check if there is any modification in field name then it should update in query. We can get away from this error by fixing query but sometime it cause database corruption and database is unable to open. If this error comes due to NameAutoCorrect option then turn off this operation using following tab:

To turn it off, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect.
Then compact the database to get rid of this:
Tools | Database Utilities | Compact.

If still you are facing this problem and database unexpectedly closes then there is serious database corruption. In this situation you need an access repair utility which can repair your database as previous. As we know compact and repair utility can fix some error but it has some limitations so in this situation we can’t rely on this. We can have a try with latest jet Hotfix pack to fix this problem.

In any case, Jet hotfix pack is not able to repair your database, don’t panic we have solution for you is Stellar Phoenix access recovery software. This utility scans your database using advance algorithm and repair your database, fix errors. Best thing about this access database repair utility is it repairs queries, forms, reports, macro, modules and primary key fields, if present.