[MS_AccessPros] Re: Date Format Issue in Access 2013 FrontEnd and SQL Server 2012 BackEnd

 

Tim

Check the field that failed. It sounds like it is a text data type in the Access table and has an entry that is not a real date.

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

---In MS_Access_Professionals@yahoogroups.com, <timdbui@gmail.com> wrote :

Regarding my question on the Date/Time formatting issue, a message I received from SQL Server is "Conversion failed when converting date and/or time from character sting (#241)".

Thanks  for your help!

Tim

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (4)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___