I am a SQL Server user and a first time Access user. The Start_date column in Access contains invalid Datetime. Whoever designed the Access allowed users to enter the start date so I have some rows that have an invalid start date like 9/9/199.
I have 150,000 records. How can I tell which rows are invalid. I also noticed that T-SQL that use in SQL View don't always work.
Help me please.