Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have linked several MS Access Tables, one has a LV value of "Long Binary Data" in MsysObjects Table whereas the table is only text and all other tables have no such Long Binary Data either.

share|improve this question
Why do you care? I just looked at the table for one of my front ends, and it has lots of items with OLE data in the LV field. Some of the objects are compiled temporary SQL strings, others are linked tables, etc. I would expect that for linked tables, the metadata about the data source on the other side of the link is stored there. – David W. Fenton Dec 3 '09 at 4:47
up vote 0 down vote accepted

It is short for ListView, one of the controls in MS Access. ListView means you're viewing the data like this in a list format:

alt text

Long binary data is the type of data you're currently storing into the cells. If you're interested, here is a more in-depth explanation of long binary data.

share|improve this answer
I don't believe this is correct at all. None of the items in the MSysObjects table that I just examined was a "listview" object (I don't even know what that is in Access terms). Please explain your justification for this answer. – David W. Fenton Dec 3 '09 at 4:49
I said it's a control, not an object. You won't see it in the MSysObjects table. – John T Dec 3 '09 at 5:10
I don't have any binary info in this table, but thanks for the article link it's interesting. – asksuperuser Dec 3 '09 at 22:20

You must log in to answer this question.