Access/Excel query error

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.
 
B

Bart E

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error message 1
Access #Error & Excel Pivot 0
MS Excel Error: Too many client tasks 1
Either Excel or Access Error - not sure 5
loss of Pivot functionality in compatability mode 1
Import External Data...Import Data... Error 0
Can't create a report from my query in Access 1
[Providex] [ODBC Drive] Assignment Error 0

Top