https://www.webmaster-forums.net/crss/node/1013990 en https://www.webmaster-forums.net/web-database-development/jetdrivers-and-password#comment-1080878 <p>I'm not sure offhand since I don't use that provider, did you try:</p> <p>UID=Username;PWD=Password</p> <p>If that doesn't work try:</p> <p>Username=Username;Password=Password</p> <p>As for you're other problem, it can be a variety of things.</p> <p>1) You're not closing your connections when you're finished<br /> 2) Someone has opened the database on the server<br /> 3) You've got a busy site and the Access database can't keep up</p> <p>As for what cursor and locktype to use, it depends on what you're doing. If you're just returning some data and not updating or deleting then a forward only cursor with read-only lock type is fine (1,3) but if you're updating then you need to use something like (3,2)</p> Tue, 10 Apr 2001 21:12:43 +0000 Peter J. Boettcher comment 1080878 at https://www.webmaster-forums.net