File Dialog Problem in Acc2000

[Gumbolia]

Hi all,

I know this may sound silly but here it goes. I have written a scripting program in access 2003 and all is well except when it is run on access 2000. It seems the "FileDialog" object is not found in 2k. I have updated to the jet 4.0 and no help. I do not have a reference to the 2k object library and would like to know how to do the simmilar things that "FileDialog" dose but make it work in both 2k and 2k3. Any help or suggestions would be great.

John

 

[BuGlen]

The native file dialog library was not introduced until Access 2002, so Access 2000 or earlier will not be able to use that method.

Instead, there is a great article on MVPS.ORG that shows how to call an API method that works in Access 2000 as well.

Here's the link:

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

Hope this helps.

- Glen

Know thy data.