Access 2000 & Access 2002 Incompatablility

[Guest]

We've got an application(an Access 2000 MDE) that searches for a file to copy. It uses the Dir command to get a list of directories, then it uses Application.FileSearch .Execute method to look in the current directory for the file. If the file isn't that direcotry it uses the Dir instruction without any parameters to get the next directory - then the Application.FileSearch .Execute method again - until it finds it

This code worked fine until the Access 2002 runtime got installed on the PC by another application. And it was no trival matter discovering that the Access 2002 runtime was the problem - and it is the problem. As soon as the Access 2002 runtine is removed this functionality works fine

When I looked at the help in both versions the Dir and Application.FileSearch have the same specs in both products

Anyone have any ideas

Al Spencer

 

[Yuan Shao]

Hello,

Thanks for your post. According to your description, I understand that your
Access 2000 MDE database worked fine until the Access 2002 runtime got
installed on the PC. If I have misunderstood, please feel free to let me
know.

When your Access 2000 MDE did not work, did any error message occur? If so,
please describe how did the problem occur and provide the detailed error
message.

Based on my experience, it is possible that certain references used in
Access 2000 MDE cannot be found after installing Access 2002 runtime so
that the Access 2000 MDE is unable to work fine. Because we are unable to
understand that references of the MDE file, can you please find the
original MDB file so that we can check the references for further research.

I am looking forward to hearing from you soon.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.