Inserting Date/Time into MS Access Database

[bburan]

Hi TDT.  I was using probes, and did see the date/time string prior to posting.  I tried your suggestion of omitting it and it didn't work for some reason the first time I tried your idea.  However, I suspect this is partially due to the fact that I had a fairly complex query updating multiple values.  After setitng up a "test" case using a much simpler query, I found that your suggestion worked, and was able to apply it to the more complex case.  I'm sorry I didn't give you enough credit for your answer, and will be sure to do so next time. 

Thanks to everyone who helped out.

Brad

[bburan]

I just realized why I was having so much trouble!  My column was named "time", which is a reserved word apparently. 

[roboticstudent]

Hello bburan,

Question for you.

What does your VI look like that wrote/inserted your data from LabVIEW into MS Access?

Thanks.

[R_J]

Hi All

I am able to write the Date in MS Access but i am not able to read it. In my case i have to read the data where Start Date=02/10/2007 and End Date= 23/10/2007. I am using this command -

SELECT*From Ram Where Date between '02/10/2007' AND '23/10/2007'   

but i am getting error -

Error -2147217887 occurred at Conn Execute.vi->Untitled 2.vi

Possible reason(s):
Exception occured in Microsoft OLE DB Provider for ODBC Drivers: ODBC driver does not support the requested properties. in Conn Execute.vi->Untitled 2.vi

Please give suggestion to read the data.

regards

J

[NoahR]

Hi J,

Thanks for contacting National Instruments.  I have been looking into your question a little more and I do have a suggestion for you.  I have attached link below that goes through a similar problem that has been encountered before when trying to access other documents.  It looks like the most likely reason that you may be encountering this error could be because of the syntax that you are using with your database.  The link below also has a link included in it that relates to a Microsoft website that you may find useful.  Are you using LabVIEW to try and access the database, or are you using LabWindows CVI?  If you are using CVI, you may want to try and post your question to the CVI forum instead of LabVIEW.  Also, another hint that may help you out is to create a new thread on a forum instead of posting to one like this since it is almost 2 years old.  This way, you may possibly have more people that will actually view the thread since it is new.  I hope the link below helps you out and please let me know if you have any more questions.  Thanks!

http://digital.ni.com/public.nsf/allkb/0C2269E34F83285186256A9D0062AEA4?OpenDocument