R
Ronnie
I have an application programmed in Visual Basic in Microsoft Access 2000
that extracts data using an Oracle 10 ODBC driver. It consists of 70
pass-through queries that are used to append data to 70 tables. The amount
of data generated is very large. Currently, the .mdb that houses all the
data is approximately a gig in size. It is kicked off in the evening, using
ESP Workload Automation. It is submitted to the Windows 2003 server as a
command line.
Every once in a while, the application will fail with the error message
"Error # 3073 was generated by DAO.Database. Operation must use an
updateable query." I have not been able to replicate this message when I run
it from the point of failure the next morning. I have also done some
research on this, but can't seem to find anything relevant.
If anyone out there has a suggestion, I would appreciate it.
Thanks.
that extracts data using an Oracle 10 ODBC driver. It consists of 70
pass-through queries that are used to append data to 70 tables. The amount
of data generated is very large. Currently, the .mdb that houses all the
data is approximately a gig in size. It is kicked off in the evening, using
ESP Workload Automation. It is submitted to the Windows 2003 server as a
command line.
Every once in a while, the application will fail with the error message
"Error # 3073 was generated by DAO.Database. Operation must use an
updateable query." I have not been able to replicate this message when I run
it from the point of failure the next morning. I have also done some
research on this, but can't seem to find anything relevant.
If anyone out there has a suggestion, I would appreciate it.
Thanks.