Could you post the part of your ASP code that uses the emp_id? Let me see if I could catch up something from there.

_________________________
-Vijay G
Strive for Perfection

Code

Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.Open "Main"
SQLStmt = "SELECT * FROM personnel where employee ='" & emp & "'"
Set RS = DataConn.Execute(SQLStmt)
Response.write "SELECT * FROM personnel where employee ='" & emp & "' <br>"
Response.write rs("title") & "<br>"
Response.write rs("code") & "<br>"
Response.write rs("employee") & "<br>"
Response.write rs("rank") & "<br>"
Response.write rs("telephone") & "<br>"
Response.write rs("room") & "<br>"
Response.write rs("mail") & "<br>"
'Response.Write rs("emp_id") & "<br>"

Output

SELECT * FROM personnel where employee ='Randy Lightle'
Supervisory Budget Analyst
811
Randy Lightle
01
696-6837
1007
mailto:[email protected]
SELECT * FROM personnel where employee ='Randy Lightle'

I commented out the response.write rs("emp_id") because it throws my error.

Is emp_id a column name? And how was it set up? Char, Number, etc.

emp_id is a column name, yes. It is an AutoNumber

SQLStmt = "SELECT [emp_id] FROM personnel where employee ='" & emp & "'"
Set RS = DataConn.Execute(SQLStmt)
Response.write SQLStmt & "<br>"
Response.Write rs("[emp_id]") & "<br>"

Can you please let me know what the above code gives as output?

_________________________
-Vijay G
Strive for Perfection

Sorry, Please take out the [] from the following line, that was pasted by mistake.

Response.Write rs("[emp_id]") & "<br>"


_________________________
-Vijay G
Strive for Perfection

Too few parameters. Expected 1.

This blows up on the execute line. It doesn't recognize the emp_id column.

Too few parameters. Expected 1.

It blows up on the execute line. It's still not seeing the emp_id column

http://support.microsoft.com/default...b;en-us;216425

Please see this.

Is that Access 2000? What is the connection that you are using?

DataConn.Open "Main"
Can you explain on this, what "Main" holds there?

_________________________
-Vijay G
Strive for Perfection

Well, I just was able to add a test record to the table as long as I don't include the emp_id field, and it appeared in my query when I then tried to select it. But it does not appear in the access database. So apparently, the access database I'm looking at is not the one designated by "main" in my connection string. So I'm sorry for the trouble. But you've definitly helped me figure this out.