Web database with local tables?

[georgesOne]

Hi,

I have created an access/sharepoint web database inclduing one table, which is dynamic, i.e. it gets data from users and throws them out after a few minutes for another purpose. This table is a web table and worked well with few users (< 8). Now this application should become available for 100 users, which may use the app at the same time. I am afraid that the dynamic table (which would be filled and read by each user with different data) will bring problems.
Is this concern valid? How can I do it better? Any comment?

Thanks, georges

 

[georgesOne]

I forgot this: does it make sense to create (and finally destroy) a local table which would not be synchronized with sharepoint (only the vba to create, fill and destroy it)?
Thanks, georges

 

[lameid]

You mean you are using sharepoint for your table? What version of Access?

"Temp" tables in access.... The concern with these is that they tend to make the database grow and possibly corrupt the database. I have gone as far as to copy a backend file for the temp file to a local path, use it and delete the file when done.