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)
 
You must log in or register to reply here.

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

Could not update Currently Locked 4
user-level security and splitting database 3
Unlocking an Access Database so multiple users can access it. 2
Database Reports - display and access 4
Access 2007: Support for formatting long integers as date broken? 3
Access 2003 - hyperlink warning 1
How to set multiple indent levels in powerpoint 2007 1
Forcing a date entry format of dd/mm/yyyy 1

Back
Top