|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 31st, 2007, 06:51 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
ACCESS 2003 : Settings at databse level
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
|
|
#2
October 31st, 2007, 09:06 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
ACCESS 2003 : Settings at databse level
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) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "mssunny" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
