Monday, August 4, 2008

Microsoft Access can't find the database file” Error in Ms Access

Some predefined action is an efficient way for programming in any programming language. When we talk about MS access we consider Macros as predefined actions.. Macros can perform a number of the common tasks same as Visual Basic code to perform in MDB file. As MDB and macro has some limitations so we prefer module and MDE files over macros and MDB file. Now we should know about MDE files. MDE file format allow you to limit database users from modifying database application that make your data more secure. You can’t edit, delete or modify MDE files. The MDE format allows you to store the same information that is contained in MDB files except that the underlying VBA are pre-compiled and stored in machine code. We can’t contain macros because macros do not provide error-handling capabilities. For converting your MDB files to MDE files, we recommend you to split your database and convert front-end to MDE format. An MDE files compiles all modules, remove all source code and make your database more compact and secure.

Converting a MDE file to MDB file has some limitations. Although it protects your application from modification or theft, If you want modify your MDE file then you must convert in MDB files. In process of converting MDB to MDE file we lost our macro. We always recommend you to make backup of your MDB file before converting it into MDE files. Sometimes you get common error messages

Microsoft Access can't find the database file '.MDB.' Make sure you entered the correct path and file name.” If you have your operating system configured to hide MS-DOS file extensions, when you try to export a Microsoft Access 97 object to an MDE file you may receive above message. There is strong change to loss and corruption of your MDE files. For this you have to recover your database file macro so that you can convert MDE files to MDB files. If you have large no of macros we have nice solution for you to repair access file by recovering macros.

Go to macros menu on the tools menu in access. From here you can regenerate some VBA code from the macros choose “convert macros to visual basic”. After this you have to edit VBA code for compiling.

-->Create and MDB replica or carbon copy of your MDE file using tool menu.

-->Make MDB replica to MDB file by choosing recover design master.

-->Choose MDB files and run Stellar Phoenix Access Recovery Software.

-->Now you can import everything from MDB file.

-->Search for macros in recovered MDB file and highlight them now Highlight each macro in the recovered database and choose “Convert Macros to Visual Basic” from the Macros menu on the Tools menu.

With the help of above method and Stellar Phoenix Access Repair software you can recover your macros from MDE files without loss of your important database. This software is easy to use and compatible with all version of access. It proves you fast recovery and supports file versions of MS Access including Access 2000, 2002, 2003 and 2007.