I use the following code to create a new a user_id in my database.<BR><BR>rs.Open "users", connDB, adOpenKeyset, adLockOptimistic, adCmdTable<BR>rs.AddNew<BR>rs("full_name") = "test user"<BR>rs.Update<BR>rs.Resync<BR>^^^^^^^^^ I use this to refresh the recordset to pull the new id<BR>intNewID = rs("user_id").Value <BR>rs.Close<BR><BR>Now if I use an ODBC connection, the above works flawlessly. I add a user then get the new user_id back.<BR><BR>But if I use OLEDB, I get an "Errors occurred" error when rs.Resync is called. the connection string is as follows:<BR>connDB.Open "Provider=SQLOLEDB; Data Source=server; Initial Catalog=DB; User ID=X; Password=X"<BR><BR>Any suggestions as to why this happens when using OLEDB? Any other options I can play with?<BR><BR>Tyson