How do I late bind to MS Access and open Access MDB?

[MarkN1969]

I need to open an Access MDB and fire off a function contained within that MDB. I can do this OK using early binding and a reference to Access BUT to avoid potential problems with clients having different versions of Access, I would like to use late binding but I just cant seem to get even close.

Does anyone have any examples of how to late bind to MS Access and then open an MDB file that they would be willing to share?

Thanks in advance.

Mark

 

[Craig0201]

Example for adaption in Excel.

Principles are identical.

http://support.microsoft.com/kb/302902

 

[MarkN1969]

Thanks for the pointer Craig. I should be able to get it working from there with a bit of work.