Would anyone know off the top of their head what to check next. I have spent hours looking at this. I am running Vista. Thought that may have something to do with it but I moved the program to XP and it does the same thing. As Stated the SELECT Querys work ok. I just cant get any INSERT or UPDATE to work.
I am calling an Access 2003 Query much like you would call an SQL Stored Procedure. The SELECT querys work well. The INSERT Querys act like they are saving data but do not.
I refrerence the Access Querys like this:
VB Code
--------------------------
--------
objData = New Globals
objData.SQL = "usp_InsertEmployee"
objData.InitializeCommand(
)
objData.AddParameter("@Log
inID", OleDB.OleDBType.VarChar, 50, txtLogin.Text.ToString.Tri
m)
......
objData.OpenConnection()
objData.Command.ExecuteNon
Query
objData.CloseConnection()
objData.Dispose()
The ACCESS Query that is called looks like this:
--------------------------
----------
----------
----------
---------
INSERT INTO Employees (LoginID, Password)
VALUES (@LoginID, @Password);
Start Free Trial
