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

Discussion in 'Access Conversion' started by Tony Z, Apr 12, 2005.

  1. Tony Z

    Tony Z Guest

    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?
     
    Tony Z, Apr 12, 2005
    #1
    1. Advertisements

  2. Tony Z

    Gerhard Guest

    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
    this.
    Thanks, Gerhard
     
    Gerhard, May 24, 2005
    #2
    1. Advertisements

  3. 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
    unavailable".
    :) Gerhard
     
    Column data unavailable counter problem?, Jul 7, 2005
    #3
  4. Tony Z

    osac Guest

    Tony Z wrote on 04/12/2005 09:09 ET
    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
    fo
    a combo box that is queried straight from the SQL Server data

    Please, any help on this would be appreciated.
     
    osac, Oct 11, 2010
    #4
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.