Posted on: 9/1/2012 1:57:27 AM | Views : 395

Hi all, I've been at this the entire day today and I'm a little frustrated right now. I'm trying to insert data into a table in Access 2003 and the SQL statement is relatively short but its's not working. I get the error "Query input must contain at least one table or query", when I run my web app. I made sure that my stored procedure name in my code behind page matches the one in Access and all that good stuff. Below are my Code an Stored Proc
public void AddEmployer(string Path,string Fname, string Lname, string Address, string City, string State, string Zip, string Phone, string Email, string Company, string UserType, int UserID) { //Declaring connection, command, string, and parameter objects OleDbConnection OleConn = null; OleDbCommand oCommand = null; OleDbParameter param = null; // Defining a connection string passing in Microsoft OLEDB Provider and the source path so it can locate the ...

Go to the complete details ...