What is the meaning of error - "Column data is unavailable"?


Tony Z

I ported my .mdb project to .adp, but now I get that message when I try to
save a record from a form. Anyone know the cause?


I'm experiencing the same problem, which is really nasty because it happens
sometimes and sometimes not. After receiving the error (#1020) "column data
is unavailable" MS-Access crashes and generates a problem report (Access 2002
SP3 with MSDE SP4 on Windows XP SP2). I reduced the problem to one form with
3 fields and one table as the data source for the form - nothing complex -
entering a couple of values and Access crashes again.
I hope somebody has a solution, I've got no idea to build a workaround for
Thanks, Gerhard



Column data unavailable counter problem?

After all I believe to have found the error's cause. Removing a counter from
the crashing form (a normal textbox with control element "=Count([ID])")
solved the problem - no crashes anymore and no error message "column data is
:) Gerhard




Tony Z wrote on 04/12/2005 09:09 ET
I ported my .mdb project to .adp, but now I get that message when I try t
save a record from a form. Anyone know the cause
I am also having this proble

We began receiving this error after converting our Access 2003 project using
SQL Server backend, to Access 2007. The message "Column dat
unavailable" comes up on GotFocus of combo boxes where we normally assig
the rowsource based on other entered data. This never happened in Access 200
but is happening quite often in Access 2007. The first time it happened th
rowsource was actually based on values from a query from a linked server so
changed it to create a temporary table instead. Now the message is coming u
a combo box that is queried straight from the SQL Server data

Please, any help on this would be appreciated.

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