I got it figured out.
Apparently a bit field in SQL server can be Null!?!?!?
There are two additional fields in the SQL version of the table. The NVarChar field I had set to allow nulls. I never bothered with the Bit field.
When I checked Allow Nulls on the bit field and re-linked, my query...
Thanks for your quick reply!
I tried your suggestion but I get a message that there is no such index. I also tried the individual field indexes (Colors_Access has a compound index) and it didn't like those either.
I had already tried adding an index to the SQL table and re-linking. I also...
Strange one here - I hope there are some SQL Server gurus around as well.
Access is telling me it can't append any of the records due to a key violation.
The query:
INSERT INTO dbo_Colors ( NameColorID, Application, Red, Green, Blue )
SELECT Colors_Access.NameColorID...
Solved!
Right click in Windows Explorer and uFlags passes CMF_EXPLORE as expected.
Right click in My Computer and uFlags passes CMF_NORMAL which is what you would expect for a right click drag! Even more interesting, when I do try a right-click drag, uFlags does not pass CMF_NORMAL. Not that I...
Howdy all,
I have written an app that dynamically modifies the windows explorer context menu. It works on all files as I put my GUID into HKCR\* (and HKCR\AllFileSystemObject and HKCR\Folder while attempting to debug this issue).
The problem is it doesn't work in My Computer, only Windows...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.