Inserting from VB .Net into Access

[zrefugee]

I'm working on a VB .Net program that uses an Access database. I can't seem to find a way to insert a datetime value. No matter what I try I keep getting "Data type mismatch in criteria expression". Any help with this would be greatly appreciated.

 

[AlexCuse]

The date delimiter for access is the pound sign (#).

So try this in place of the string you are trying to insert:

 "#" + myDateString + "#"

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[chrissie1]

Shiver.

Christiaan Baes
Belgium

"My old site" - Me

 

[AlexCuse]

Is it cold over there Chrissie1?

Ignorance of certain subjects is a great part of wisdom

 

[zrefugee]

Alex I've already tried that and still get "Data type mismatch in criteria expression" no matter how I how format the date string. I've worked more with SQL Server and MySQL and this has not been a problem.

 

[AlexCuse]

Maybe you should post the code you are using, and some info on the Access database as well.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[chrissie1]

Perhaps you should use the parameters that come with the command object. This way you also prevent sql-injection and any future problems with dates (like the fact that the dafult can change on the serverside).

Christiaan Baes
Belgium

"My old site" - Me

 

[chrissie1]

Please erase the first word in my previous post.

Christiaan Baes
Belgium

"My old site" - Me