You must use the dbSeeChanges option with OpenRecordset when accessing a SQL server table that has an IDENTITY column

We just upgraded an internal MS Access 2003 DB to  use  MS SQL 2008  (in linked server table format) and immediately got the error listed in the title (and pictured below)   The debug option gave the following line as the problem: Set rs = db.OpenRecordset(sql) I tried Set rs = db.OpenRecordset(sql, dbSeeChanges) but just Read More…

Searching using the command prompt in MS DOS

Useful command in DOS for searching within a directory : findstr /spin /d:\dir1\dir2\ “searchstring” Note: Flags: /s   : Searches for matching files in the current directory and all subdirectories. /p   : Skips files with non-printable characters /i   : Specifies that the search is not to be case-sensitive. /n   : Prints the line number before each line that matches.