We (students and the teacher) are having some trouble with these codes. The error is "Syntax error in FROM clause". If someone could help us that would be greatly appreciated. :)
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Page language = "VB"%>
<script runat="server">
Dim objConn As New OleDbConnection
Dim objCmd As New OleDbCommand
Dim strcnn, strSQL As String
Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs)
strcnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("App_Data\user.mdb") & "; Jet OLEDB:Database Password=;"
objConn.ConnectionString = strcnn
objConn.Open()
Dim intNumRows As Integer
strSQL = "SELECT COUNT * FROM user WHERE Username = ...
Go to the complete details ...