Thursday, November 08, 2007

MS Access Database Design Mode

We had this application in MS Access which read data from a DBF file and created a text file which could then be imported into Navision. One fine day the text file would not create and there was no error flashed on the screen. To debug the issue i wanted to get to the code window of access, but the moment i clicked on the application it would get into the run mode and i could not figure out the way to get into the design mode or the database design of the application.

I Later realized that if i held the shift key while opening the application then it would open in design mode. The application was not executing as one of the DBF table had certain deleted records which could not be read once these records were purged the application started to work.

Wednesday, November 07, 2007