OS: Windows 7 Software: MS Access 2003 When trying to change the column in MS Accees 2003 from Currency to Number we received the error : “There isn’t enough disk space or memory” Looking in the table there are 350, 000 records – which makes sense. To fix this we need to edit the registry. Go Read More…
Category: MS Access
MS Access displaying NULL values in currency column after upsizing to SQL 2008
Software: MS Access 2003 / MS SQL 2008 After upsizing a database, a currency column in a particular table was completely empty via the Access application. However, when viewing the table in SQL 2008, the values are present in “money” format. Suggested workarounds didn’t really fit for us (eg changing the workstations to English US Read More…
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…
You must be logged in to post a comment.