Dont even bother telling me that you can do this using the design feature of Access because I cannot open the db as its busy on the server.
I need to ALTER or if not drop and then CREATE another table with a date type set as longdate.
What is the SQL to do this.
CREATE Table blabla (TheDates longdate) will not work
CREATE Table blabla (TheDates date) will work but it doesnt allow you to specify which date type