The following list provides the most common errors that students find during lab installations, and if you encounter problems, you can check to see if there are similar situations:
Incorrect MDB file name or path - Reinstall Check the exact MDB name and path. To avoid path name errors, you can use the Browse button in AccessDataSource's Configure Data Source wizard.
·Incorrect access permissions for MDB files - If the MDB file requires a UserID and password, the techniques described in Chapter 4 must be used.
·Try to use data-bound controls when there is no data source control - data-bound controls must have a data source specified by the DataSourceID property, that is, the data source control.
· Setting the wrong data source for a data-bound control - If you use multiple data source controls, pay special attention to the exact name of each control. Then check again the data source used in the DataSourceID property of each data-bound control.
·Attempting to use MDB when JET is not installed on the machine - Although this happens rarely, please check whether the server has JET installed. Copying MDB files is easy, but you must have Access software or JET engine installed.
· Errors in table and column names - This error often occurs when typing; if you use the designer wizard or drag and drop in Visual Studio and VWD, then there will be no problem.
·Incorrect SQL statement syntax - Please make sure you spell the keywords correctly. There must be a comma between each item in a list (such as a set of field names). Literal strings must be enclosed in single quotes, but numbers do not. Whenever possible, use the data source control's Configure Data Source dialog box to create the statement. You can also test SQL statements directly in the Access Query Design tool or Visual Studio QueryBuilder.
·Attempt to use a locked MDB object - An MDB table or query currently open in Access in Design mode denies all reads and writes. When you want to use this object in ASP.NET, you need to close this object at design time or run time.
·Attempting to modify a locked page - VWD's Design view is not available for a page that is opened by a browser. If you need to use Design view, you must first close the browser. (You can edit, save, and refresh the browser in Source view to view changes).