I think I understood your original problem. Perhaps the fact that I've never used Access 97 means that I don't know enough about it to understand how it works and any attempts to explain what to look for are inaccurate. I don't how to solve or even trouble shoot the problem for Access 97.
I was just suggesting possible work-arounds to the problem. Sometimes you just have to give up on the solution you are trying because the tools you are using were not designed to work the way you think they should.
One solution is to use the run-time instead of trying to fix Access 97.
Since you mentioned Access 2K, I was assuming that you had the ability to develop the application in that version. You are perhaps assuming that you are stuck with Access 97 because those other computer are only licensed to install Access 97.
Even though other computers don't have a license to install full Access 2K application, you may have a license to install the Access 2K "run-time" on those other computers. If you do have a license, then you could install the Access run-time while you're installing your app. Using Access 2K run-time instead the Access 97 full install my solve the problem you are having with the Date/Time picker control.
The "run-time" is a component that comes with every version of Access version 2000 or later. This MSDN article discusses it further. http://msdn.microsoft.com/library/de...ssolutions.asp
Another solution is to abandon the date/time picker control in favor of building your own forms to pick a date. John Viescas (http://www.viescas.com/
) demonstrated how he did this at our last PNWADG meeting. If you build your own forms, you are not as dependent on what version of Access people are running or what version of the control is installed on their machine.
You asked if there were other dependencies for the date/time picker control. Your assumption is that there are. You may be correct. However, by installing VS or Access 2K/XP on the computer, you may be installing something that cannot be installed without a license to either VS or Access 2K/XP. It's difficult to tell what all gets installed. But you may be installing one or more DLLs that have new ways of managing forms, DLLs that aren't available unless you are upgrading your software or that are too complicated to install without a full software upgrade.
Maybe it's time to move forward to Access 2K/XP instead of trying to fix Access 97. OTOH, maybe the Access run-time won't install the proper components such that the Date/Time Picker control will work.
At any rate, if you must stick with Access 97 and the Date/Time Picker control, I'm no help. Sorry.
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group