Recent content by rkkoller

QryString is defined, just not within the sub. It is defined at the top of the form code under Option Explicit. If you think the recordset would be better, how would I accomplish that? My intention with the DLookup is to simply force Access to connect to the DB and open the login window.

Thanks Banana, I will have a chat with my DBA. By the way, below is my code that I added to the switchboard that opens with the application to force the user to log-in and catch if they enter their password incorrectly. It works, but any advice or improvements are always appriciated...

Thanks for the quick replies. I tried the Microsoft ODBC for Oracle driver, but it didn't play nice with any tables that had a CLOB field. As for running a query right on application open (I guess I will run this on the main switchboard that opens with the app), I like that idea. I guess if...

I have a Access front end with an Oracle back end. I set up the connection with the typical Get External Data > Link Tables and selecting an ODBC Data Source. I have some issues with the way this works: - I'd rather have the user log into Oracle immediatly when they open the application, but...