DAO with Citrix Terminal Server

[jpiscit1]

Hi everyone.

I am currently working on an application that uses MS Access 2000 as a front end and SQL 2000 as my data warehouse. The application is configured to run on a Windows 2000 Terminal Server with Citrix MetaFrame XP.

Prior to developing the application We installed MDAC 2.6 drivers on the server. Found here:

http://www.microsoft.com/downloads/...28-7071-4979-8a67-3cffcb0c2524&displaylang=en

I am attempting to use code to dynamically re-connect my SQL tables back to access. However, I am getting an ISAM 3170 error.

My question is how does MDAC 2.6 relate to DAO ?
Does it matter if I reference DAO 3.5 Object Library or 3.6 with MDAC 2.6 loaded?
I have already checked the references in the system registry covered under this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209805&Product=acc2000

I have not, however, tried the repair Office 2000 option on the server yet.

I can post the code used but it does work in another application at another site. I am pretty sure this is a case of registered files or versions mismatch...

I am hoping I can get a better understanding of this prior to making anymore changes. Can someone shed some light ?

Thanks,

John

Your limits are only as far as you set your boundries......