Hi guy,
    How can we make sure the date format that we pass in MS Access are
constantly the format that we wish.
    I ask this is because My select statement work in some computer and some
not. Even  I have check the computer system date format there are same. What
will effect the date format in MS Access. How to prevent this thing happen.
I can't use access anymore if it work like that.

   Thanks in advance,

With regards,
Goh

Use parametrised query instead, something like: select * from somewhere
where datefield = ?

Show quoteHide quote

Hi Goh,

I agree with Miha, that we can use parameterized query to overcome the
format issues.

In addition, the MS Access stores DateTime with 8 bytes. It doesn't stores
any format information in the database. The format/culture information is
used according to the machine's regional settings.

Kevin Yu
Microsoft Online Community Support

============================================================================
==========================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
============================================================================
==========================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)

I assume you are dealing with globalization issues (i.e., some comupters
belonging to people in some countries have different date formats). If so,
switch to a common globalization setting before saving to the database.

http://www.c-sharpcorner.com/Code/2005/April/GlobalizationusingASP.NET.asp

Show quoteHide quote

SQL connection timeout -- is it pretty useless or what?
ObjectSpaces is realy good?
Access Lock Remains after Connection Closed - OLE DB / Jet
Index column in Dataset (or Datareader) !!!!
Enterprise Library (what should I use...)