neilabbott
Technical User
- Mar 11, 2003
- 19
I have searched for in vain for links/faqs dealing with connecting Access02 to OL2002. They all assume I have Exchange...
The 'link table' wizard for OL is not very helpful as it doesn't expose the useful unique ID fields needed for relationship building (combo boxes/lookups etc) (I use OSAsync which has unique IDs which stick to a record whichever folder it is in unlike the built-in system).
I tried the .udl gizmo to try and set up an ADO connection but it fails miserably ('cos of no Exchange present?)
Am I going to be stuck with having to build a new Access table each time from an OL folder (and then query it) when I need to use data?
Signed
Exasperated of Auckland NZ
(Neil)
The 'link table' wizard for OL is not very helpful as it doesn't expose the useful unique ID fields needed for relationship building (combo boxes/lookups etc) (I use OSAsync which has unique IDs which stick to a record whichever folder it is in unlike the built-in system).
I tried the .udl gizmo to try and set up an ADO connection but it fails miserably ('cos of no Exchange present?)
Am I going to be stuck with having to build a new Access table each time from an OL folder (and then query it) when I need to use data?
Signed
Exasperated of Auckland NZ
(Neil)
