Community Server

 Is there a way to show the survivor fee deducted on the weekly summary page?

 It is migrated to microsoft sql server.   Problem is, it is very modified from Mike's original, using avatars, messaging, chat room etc.

Usually you'll get an error like, the page cannot be displayed, or in other cases the page will just lock up on you.

 Access only allows a single write at the same time, so if your have 2 users try and submit their picks at the same time, 1 will be locked out.  I had this issue a lot last year, so I migrated to ms sql.

 Good call, thanks that worked.   Are you planning on migrating to sql next year?   My pool this year will be a working test.  If you want to check it out, you are more than welcome, i'll send you an invite code.

 My code sql = "INSERT INTO Credits" _                & " (Username, [Timestamp], Description, Amount)" _                & " VALUES('" & SqlEscape(username) & "'," ...

 Yea, I had tried that before.  Now I have users who had made picks and I don't want to mess with that.  Maybe it is something to to with ms sql, not sure.   But all the code looks right.

 The only way I could get it to work was by adding 1 game result in week 17 for the time being.  I'll erase it as soon as the first score is ready in week 1.

  I'm pretty sure I do.   Can you tell me which lines in particular I should check?

 Is there a way to only display the overall pot once the scores went in for the first game?  It is not really an error, just will be weird when I have 35 entries in for the pool, and it says that each person won $.20.  It looks like the code is saying each person is the overall winner until the database shows the game results.