Query data with no SQL code in SQL Server
A beginner free course for analysist and everyone who don't want to learn SQL language but need to query data from a database. Report designer or specification writes can learn how to use a built-in visual gui tool in SQL Server Management Studio. Lean to use Query Designer in this short (40 minutes) course in 11 sections:
That means the next time you relink a table, the date/time field definition becomes the new data type. The issue with that is there is no corresponding type in VBA and any code you have that works with the field will treat it as a string. This will break your application.
At the present time, the only thing you can do is roll back to 2008.