Month: May 2006
Microsoft Access: Why qdf.execute Is Not Showing Any Warning?
I had an application in which I had a code like The query was not running because of error but the application was not breaking at the time of error generation. To force the application to break/throw exception write the statement like This way we can catch all errors.
Things to Remember While Converting Microsoft Access Application Into SQL Server Application
When the Access database grows much large and the performance of the application gets worsen, you might need to think of upsizing the Access database into SQL Server database. So that you can split your MS Access front end and SQL Server back end. Microsoft Access comes with a utility called “Upsizing Wizard”. It is…