Archive for December, 2009
This article describes you how to deal with MS Access error message saying,
Microsoft Access has detected corruption in this file.
Microsoft Office malfunctioning, OS malfunctioning, software damage, file system damage, virus attacks, unexpected system shutdown, etc. are the well known reasons for corruption in MS Access database.
In Microsoft Access queries have a very significant role, as getting a certain piece of information from a large database is quite impossible without them. In MS Access most of the queries follow particular criteria that are defined at the time of creation. However, sometimes you may need to input different criteria or modify the defined criteria to meet your requirements.
While you try opening the Visual Basic Editor in MS Access database (by pressing Alt+F11), you might encounter one or more of the error messages mentioned below:
The Visual Basic for Applications project in this database is corrupt.
Or
The module name ‘module name’ is misspelled or refers to a module that is invalid.
In Microsoft Access, the default data type is TEXT. However, one can change the text data type to another desired data type. Choosing a specific data type is totally one’s own perception and his/her choice as doing so ensures that you will get the best results from your queries and searches. If you are using MS Access database, then this article would be of great help. This article describes steps involved in converting data values of Text data type to proper case format.
Dynamic content is the primary thing to present organizational information over internet. As far as MS Access is concerned, one can make available information dynamic using various features. One of these features is Data Access Page.