ACCESS 2003 : Settings at databse level

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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)
 
Back
Top