I used to see this a lot and never figured it out (altho timestamp did help). Somewhere along the way (having upgraded to SQL 2012 and Access 2013) the problem...

My problems come from the federal gov't and I don't care to try to fix!...this link might be useful for scripting find and replace: https://stackoverflow.com/questions/5477209/how-to-replace-text-in-text-file-using-bat-file-script

I have used simple find and replace in the text as a workaround in similar situations (at least until it can be fixed at the source)

Too simple? export as CSV and tell them to open in Excel 2007 or higher.

cautionary note: it does not pay to be right IF the boss is wrong

Perhaps you can use DATEPART?

Access ACTUALLY stores dates and times as numbers. Leverage that to get your answer. Go here for some help: https://support.microsoft.com/en-us/kb/210276

A possible, easy and repeatable option: connect to SQL via Access (ODBC, for example).In SQL, create a View that has your query results.Access attaches to Views and the results can...

I've definitely been burned by letting wizards, etc. do this ..I suggest creating (via SSMS?) your tables in SQL the right way (and empty). Then put the Access data into...

I saw this problem recently and it turned out a Cryptovirus had encrypted the mdb. You might want to check other .mdb files just in case. And pray that is...

If the data is on a network server, use the "Close open File" option (Control Panel | Administrative Tools | Computer management | Shared Folders | Open Files.

Otherwise you can...

I have been using an Access front-end to SQL Server for many years. It has a few quirks but is mostly very good. At the beginning, simply use SQL as...

Not sure if this query extract is helpful but it helped me in a recent situation where I was trying to deal with non-alpha characters:

WHERE ([Bill Freq] IS NOT...

No settings were changed and my execution time DOES = 0..apparently, tho, (thru a bug in SSMS or SQL 2012?), those settings impact Queries (runs about 90 seconds and is...