Linking tables

[GLENEE]

The database i have written is split via a Front End(FE) and Back End(BE). I have used the Class FileDialog to give the user the option to search and relink the files if the BE moves. This I believe is a member of the Microsoft Office 10.0 Object Library. The problem is the user does not have this reference available on their machine, only Microsoft Office 9.0 Object Library. I cant seem to see an equivalent class to use on their machine and not sure if i'm able/allowed to install MSOffice 10 object library on to their machine. Is there an alternative?. Thanks

 

[Remou]

This should help:

http://www.mvps.org/access/tables/tbl0012.htm

 

[jrbarnett]

The Access 9.0 Object library indicates that Access 2000 is the version installed on that PC.

Without installing Access XP (or later) you won't get Access 10.0 library, so another way is to call the API functions directly, as per:

http://www.mvps.org/access/api/api0001.htm

John

 

[GLENEE]

Thanks for the advice, i'll try and get my head around it or wait until the user upgrades their version of Access!