Hi,
I'm building an ecommerce website. When a user logs into my site, I want to
create a temporary table (say called 'ShoppingCart') in my database. I'm
currently using MS Access, but may use SQL in the future. Since I cannot
create a temporary table in Access, I want to create the table and then
delete it (drop it) at the end of the session.
My question: If I call the table 'ShoppingCart', for example, will this
create a problem if multiple users simultaneously access the website and
have their own temporary table called 'ShoppingCart'? ...or do I need to
figure out some way to give the tablename a unique name for each user? Any
suggestions doing this would be appreciated.
Also, what is the best way to delete the table at the end of the user
session? I
am using ASP VBscript. Thanks.