I like the username solution.  That should fit our multiuser environment better (300 users).  Thanks for the code example for a non-secured database.  Not sure if we'll use it for...

We did several scenarios with this.  The database has always been split.  Initially, all the temporary tables were created in the front end.  The table lock problem occurrs when the...

Brian,

Thanks for the response.  Believe it or not, we did split the database and still got this problem.