Situation: Users have access to front End Databases that allow them to query the backend through their own reports and Queries. Problem is that we just added a terminal server. Now when the user tries to access the databases the VB References for the Libraries get screwed up because on their machines Access is loaded on C drive. On the Terminal Server Access is loaded on the D drive. Because the libraries are loaded on a different drive and it seams that the databases themselves keep track of this and not the access program. Functions will not work if users go from Terminal Server to Local or Vise Versa. Anyway to overcome this without moving much around? The quick work around was to uncheck a reference and then rechech a reference then Access saw the libraries on the correct drive. Using Access 2002 and Win2k both server and desktop.
Thank You
Michael
Thank You
Michael