I'm unsure about the searching, but there is a bigger issue in that Access
does not natively support connections over http. However, if the SharePoint
server is on a local network is worth noting the equivalence of the
following paths:
Using the alternative straight address, the SharePoint folder structure
behaves like part of the
internal file system and can be treated pretty much in the same way as
folders on the local machine.