Peter, I think I'm trying to accomplish the same thing you describe. Basically, I just want my Access DB to remember the MaxDB ODBC login user/pw so non-Access proficient users don't get annoyed every time they open the database to review data. Is there a simple setting within the MaxDB ODBC driver that can remember the login info? I also think your login form idea is pretty good. Would you mind sharing the details with that (VBA code specifically for making the database connection and looping through the tables)? Thanks, Chad
