I am developing an application on VB.Net and works with MS Access database.
The application I am developing will be used by users that have European Culture in their computers and the dates they use are dd/mm/yyyy.
But when I send the date as 17/05/2012 (the month is May) via VB.Net to Access database , in the Access database it gets stored as 07/17/2012(the month is stored as July, and it is changing the date to US date format ). So to solve this I had to send the date with the name of the month, like 17/May/2012.
I got the name of the month by using the dateObject.ToString("MMMM").
But when I deployed this application on my client computer who was using Netherland culture, got errors and I found the error as that the month May was getting passed as 'Mei in Dutch'. And it was because the Access was not Dutch but English. Since Access that they were using was an English version it could not identify the months in Dutch.
So is there any solution that I can solve this problem by making sure that the date I send in European format is stored as an European date format in Access, because after it reaches into Access it is being converted to US date format.
How can I solve this problem.
Thanks in advance.