Access/Excel query error

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

I have an application where a macro pulls data into an
Excel spreadsheet from an Access database. The macro
works fine, but when I add a new record to the database,
and a corresponding set of rows to the query page of the
spreadsheet, I am unable to edit the query or create a new
query, getting the following error message: [Microsoft]
[ODBC Microsoft Access 97 Driver]Data Truncated. This
occurs for multiple users, all of whom are running Access
97. The application worked for a couple of months, then
this error started popping up. Anyone familiar with it?
Thanks.
 
Hi,

You could try refresh the query first and then do the
other stuff. I'm having the same problem in Excel.
refreshing the data and then editing the query is the
solution for me.

Regards,
Bart
 
Back
Top