MS Access

There isn’t enough disk space or memory when trying to update a table

August 30, 2012 Jordansphere MS Access

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 […]

More

MS Access displaying NULL values in currency column after upsizing to SQL 2008

August 24, 2012 Jordansphere MS Access

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 […]

More

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

August 21, 2012 Jordansphere MS Access

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 […]

More

Powered by WordPress. Designed by elogi.