ACCESS 2003 : Settings at databse level

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mssunny - 31 Oct 2007 19:51 GMT

Hi,
Can we set few properties (as we have NLS in Oracle) at database level in
ACCESS 2003?
Most important is setting a date format for the whole database (though
regional setting is one option but i want to do that programatically or once
time by setting that at database level)

Thanks!

:)SB

Reply to this Message

Douglas J. Steele - 31 Oct 2007 22:06 GMT

Access gets its date strictly through Regional Settings and, in fact, it
ignores the Regional Settings in SQL statements (dates must be in mm/dd/yyyy
format, or an unambiguous format such as yyyy-mm-dd or dd mmm yyyy)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hi,
> Can we set few properties (as we have NLS in Oracle) at database level in
[quoted text clipped - 6 lines]
> Thanks!
> :)SB

Reply to this Message