I am hitting an Oracle back-end from a rather involved Microsoft Access Front end application. All the Access code, forms, reports, queries etc were developed using access's default of Case insensitivity (originally both front and back-end were Access). Naturally, when we moved the back-end to Oracle, case sensitivity is killing us. Can we have Oracle run in a case insensitive mode?
Any help would be appreciated.