I have no choice, but have to create a web app based on M$ Access DBs. Yuck.

Anyways, what is the best practice for Adapter.KeepConnectionOpen. Should I set it to false to force the database to close all the time? The site will get 5-10 concurrent users.

All read-only access.

Ian

These are some links that explains the KeepConnectionOpen flag:

• Adapter functionality
• http://llblgen.com/tinyforum/Messages.aspx?ThreadID=11001
• http://llblgen.com/tinyforum/Messages.aspx?ThreadID=12037

For the KeepConnectionOpen flag, doesn't matter whether or not you are using MS Access.