Recent upgrade to Office 365 including MS Access (iisues)

[Chuck]

First, since I am a very infrequent user of this forum I would appreciate re-direction to the right sub group as is appropriate for my questions.

1) What are the pros and cons of converting my Access 2003 in V2000 format to the current version? I have upgraded to V 2016 but have not converted to the new file format yet.

2) How can I un-register the activex control relating to the calendar control (MSCAL.OCX)? I no longer require it and opening my DB results in an error message relating to this item.


My web search indicates that this is still the correct method.

3) I have a few queries that are designed to select records by the current date, next week, this month. For the current date query I was using Date() as the criteria. My web search indicates that this is still the correct way of expressing this criteria, but this does not work. Trying to use it produces this error message: unidentified function ..

[CJ_London]

1.if you don't convert soon, your upgrade path will become extremely convoluted. Also MS say 2003 is not certified compatible with Windows 10 but might work
2. delete the control
3. as time has gone on, access has become less tolerant of 'poorly defined' language. But it might be the libraries are incompatible - particularly if you are using the 64bit version of Access. I would go into the VBA IDE and check for missing libraries

[Micron]

Research Office 64 bit and you'll likely find that it's ill advised for most people, and there are pitfalls if you're developing db's for others who are not on it. Don't upgrade the only 2003 db's you have - upgrade copies and work with those until you're confident everything in it works. Then archive the originals. Upgrading from 2003, you will have an issue with any custom menus or toolbars you created. You will lose the GUI tool that allowed you to create them as well. Some references may break/go missing but you should be able to resolve those. IMO the application windows/forms lack visual appeal to put it mildly. There is always the possibility of running 2 versions if you need it, but you have to know what you're doing with that.

[Chuck]

I found a solution to #3 (the date issue).I found the solution here: http://allenbrowne.com/ser-38.html

I unchecked a library that was marked as "missing" and that solved the issue, even though this library on the face of it did not appear to be remotely relevant to the issue I was having.