Log in

View Full Version : Can Access 2000 Object Library use a different Const, than msoFileDialogFilePicker?


Micromax
Mar 9, 2011, 04:06 PM
I used Access 2003 to create a database and saved as Access 2000 format. I used some code that downloads a logo. This won't work in Access 2000 because of the Library Microsoft Office 9 Object Library can't pick up the msoFileDialogFilePicker object. It think it's a variable. I'm not sure if Access 2000 is setup right or the msoFileDialogFilePicker really isn't available in Access 2000. Does anyone know if there is a way that the database can be distributed to have this logo download if the user is using Access 2000? Any help re: Access 2007 and Access 2010 with regards to picking up the same code or Access 2003 functionality in those later Access program would be appreciated.
Thanks for you help.

Micromax
Mar 17, 2011, 04:03 PM
You can remove this question if you wish

ScottGem
Mar 17, 2011, 04:11 PM
References have little to do with the file format and much to do with the version of Access. The FileDialog object was introduced in Access XP So it can be used by anyone using the XP client or later regardless of the file format. However, it can't be used by earlier clients. To use the FileDialog object the Microsoft Office xx Library needs to be listed as a Reference where xx is version 10 or higher.

Micromax
Mar 18, 2011, 04:25 PM
I had a feeling about that Scott. I tested the database on Access 2000 and it could'nt read that line specifically that constant. Thanks Scott for letting me know. I appreciate your input as usual.