G
Ghost Dog
I've got a legacy app that writes Access data into an Excel spreadsheet. It
has worked fine for several years, but when the user (the only user of this
app) upgraded to Office 2003 it ceased to work. The recordset built from the
spreadsheet has its updatable property = False, and I get an "Object is
read-only" error message. I'm sure this is because it was originally written
using DAO, and I was wondering if I need to rewrite it using ADO. It's not a
particularly important app, and I would prefer to set a parameter to resolve
this, if one exists.
has worked fine for several years, but when the user (the only user of this
app) upgraded to Office 2003 it ceased to work. The recordset built from the
spreadsheet has its updatable property = False, and I get an "Object is
read-only" error message. I'm sure this is because it was originally written
using DAO, and I was wondering if I need to rewrite it using ADO. It's not a
particularly important app, and I would prefer to set a parameter to resolve
this, if one exists.