Can I decode the date based on its length......

Hi,
I need to run a stored procedure which accepts date as an input. If I input date say 11252000 (MMDDYYYY), it is accepting but for dates such as 03062000, it is throwing error "ORA-01843: not a valid month". Please help me out. In the procedure, I am using to_date to convert the date into MMDDYYYY format, but its not working for all cases. Also if someone gives a date such as 0622000 (June 2nd 2000) or 5112000 (May 11th 2000),...

Hi,
I have a sample ASP code which should get the records from a table in ACCESS database. However, while running the page I am getting the following error:

"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data."...