[Cause and Resolution] Cause: When you add a record to a SQL Server or SQL Azure table by using VBA, if the table's unique index field has a default value, and you do not assign a value to that field, the new record does not appear until you reopen the table in SQL Server or SQL Azure. If you try to obtain a value from the new record, you receive the following error message: Run-time error '3167' Record is deleted. Resolution: When you open the SQL Server or SQL Azure table by using VBA code, include the dbSeeChanges option, as in the following example: Set rs = db.OpenRecordset("TestTable", dbOpenDynaset, dbSeeChanges) [Issue] 
New records are not available.