ACCESS 2003 : Settings at databse level

M

mssunny

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!
 
D

Douglas J. Steele

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Level resource allocation error 1
Forcing a date entry format of dd/mm/yyyy 1
user-level security and splitting database 3
Unlocking an Access Database so multiple users can access it. 2
Database Reports - display and access 4
Wise to set up user level security for a multi FE MDB ?? 9
Leveling and deadlines 2
Access 2007: Support for formatting long integers as date broken? 5

Top