Access + digital imaging missing reference

[P.Schuman]

We have an Access 2007 application that has recently added a weird
"reference".
If we look at the VBA editor.... Tools -> References
we see a long list of entries with only 4 checkmarked at the top.

Visual Basic for Applications
Microsoft Access 12.0 Object Library
OLE Automation
Microsoft Access 12.0 Access database engine object....

and the weird one
Missing - SCTV 1.0 Type Library

which appears to be part of the product - Microsoft Picture It - ?

 

[John Spencer]

So uncheck the Missing and try to compile the code. If it compiles you
don't need the reference. If it won't compile then you do need the
reference and will have to locate it and add it. If it is not on the
computer, then you will have to get it, load it, and add it to the
references.



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[P.Schuman]

We just can't figure out how, where, or why this "PISCTV.DLL" got added
as it refers to the Microsoft Picture It product.

BTW - We just un-checked it in the list,
and "saved" the Access 2007 accdb file and all was better.
How do we "compile" vs just saving the accdb file ?

tnx - Phil

 

[John Spencer]

Switch to VBA (Try typing control+G) and then select Compile from the Debug
menu.

I am not sure the above is accurate in Access 2007. I am not yet using it.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[P.Schuman]

Not using 2007 yet ? -> > Access MVP 2002-2005, 2007
I was just looking at the error for a friend and not really an Access user.
Stumbled across the Debug/Compile and tried it,
but it failed with some other non-associated problem.
Also tried the MDE, but that failed with too many somethings....

My biz friend is using Access 2007 to connect to his SharePoint 2007 system
and all the tables are actually Lists on the Sharepoint 2007 site.

Not being immersed in Access myself, I just kind of stumble around
looking for his errors.... it's a timesheet reporting system he created
for his small biz.

I have the really huge/thick book - Access 2007 Inside/Out - but only started
it.

tnx - Phil