Problem with windows 98

[Butch]

I developed a database with access 2000 on windows xp. But the company I developed it for is having a one problem with it when running it on windows 98.
I have a function that calls the 'windows file browser'. This function works ok with windows 2000 upwards but with windows 98 it comes up with a compile error.

Why would there be a difference with the calls for the 'windows file browser'?
Is there a fix that can be run on the Windows 98 PC's that can update these so the same functions will work on all versions?

 

[ghudson]

I belive that the common dialog control must be set to the correct referrence for the version of Access and/or Windows the user has installed. Sounds like a reference problem for the offending PCs.

I prefer to use an API for allowing the user to select a file or directory. That will eliminate those types of problems.

Check out these APIs for calling the standard windows "File Open" and "Browse Folder" using VBA...

API: Call the standard Windows File Open/Save dialog box
http://www.mvps.org/access/api/api0001.htm

API: BrowseFolder Dialog
http://www.mvps.org/access/api/api0002.htm