Finding out NULL values in OLE Object field in MS Access
Good Morning Experts! I am struggling with a query. I need to query an "OLE Object" field and find out which records have a "NULL" value. However, when I try and put the "NULL" criteria in the query it doesn't work. Neither does it work to sort ascending so I can copy/paste the ones that are NULL. I also cannot see the data on the column. How do I find out the NULL values?
Last Comment
Is Null does not work?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
It works for me in A2003.
Which version of Access are you using?
Which version of Access are you using?
ASKER
Yes, the query works but it is a false positive. I get results with the query but they are not true.
ASKER
I'm using Access 2003.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hey, thanks! That's a good point! I only have read access to the data, which I connect to using ODBC. I'll try and look closer on the data. There is a field called "BinaryObject" where all the values are tagged as "OLEObject" in my view. Supposedly, a user should be able to "attach" a file through the application. When she does so, the application creates a record in this table. There is another field called "FilePath", which is the path of the file. It is my understanding that the users can upload the file directly to the application, which should be stored as "OLEObject". Since you guys are telling me this works, it leads me to believe that none of these files are currently stored as "OLEObject" in the database, but just referenced through in the "FilePath" field. What was throwing me off was why are all fields tagged as "OLEObject" and not have a blank in them.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
