If you're using the Database Connectivity Toolkit, there are some examples
here that should help and I believe the toolkit ships with some. If you wnat to use ActiveX to connect to a MS Access database, there's one example
here and numerous others have been posted to this forum. Just do a search of "Access". If you want something free, check out LabSQL from
Jeffrey Travis.