Flash Uploader : how do I pass values to "uploader.php" (flash uploader question from tufat.com)

1) Any multi-user database should be split. You will get performance enhancements by installing the front end locally. If your app creates temp tables to perform some functionality, then it would be better to have it local.

2) A temporary table is just that, a table created to temporarily hold data used for processing purposes. Sometimes just creating queries doesn't do the job and you have to actually create a table to hold the data to report on or perform some other function. Same with a temorary recordset. Temp tables could cause problems if they are stored in the back end. Temp recordsets usually are created in memory.

3) I suggest you read up on Scope in Access help. Where you create the variables depends on how they are dealt with.

4) I'm not sure what books you have or where you have looked. The first two questiona are not restricted to Access, but applies to any database. So does the third to some extent, but there is a discussion on scope in Access Help and should be in some design books.

Hope this helps,
Scott<>

Please don't forget to provide feedback for this response (either by rating or followup). It helps me help people better if I know how my advice worked.