Link to Outlook Address Book

[DEI]

I have created a link to my Global Outlook Address Book in a database (File -
Get External Data - Link Table - etc.) and I am trying to work with the
table. It is slow, I accept that, but I when I write a query against it that
includes 'like' in the WHERE clause, I get only (1) record returned. Eg.
the following SQL statement returns (1) name:

SELECT [Global Address List].[Display name]
FROM [Global Address List]
WHERE ((([Global Address List].[Display name]) Like "Smith*"));

I have even tried to access it via ADO (with perecent instead of asterisk)
and I only get (1) record.

Has anyone encountered this? Is there a way to get ALL the like records?

Thanks,

DEI

 

[Ralph]

I had the same problem. Then I tried:

WHERE ((([Global Address List].[Display name]) Like "*Smith*"));

It worked but it took at least 5 minutes to run.
You may do better copying the table. Depending on how big or how often
employees turn over in your company you may be able to copy it weekly or even
monthly.

 

[DEI]

Thanks Ralph. I tried the sam ething and got the same results - very slow.

I applied another solution similar to what you describe, but it requires
periodic updates.

I had the same problem. Then I tried:

WHERE ((([Global Address List].[Display name]) Like "*Smith*"));

It worked but it took at least 5 minutes to run.
You may do better copying the table. Depending on how big or how often
employees turn over in your company you may be able to copy it weekly or even
monthly.

I have created a link to my Global Outlook Address Book in a database (File -
Get External Data - Link Table - etc.) and I am trying to work with the
table. It is slow, I accept that, but I when I write a query against it that
includes 'like' in the WHERE clause, I get only (1) record returned. Eg.
the following SQL statement returns (1) name:

SELECT [Global Address List].[Display name]
FROM [Global Address List]
WHERE ((([Global Address List].[Display name]) Like "Smith*"));

I have even tried to access it via ADO (with perecent instead of asterisk)
and I only get (1) record.

Has anyone encountered this? Is there a way to get ALL the like records?

Thanks,

DEI