Creating New Tables In Access

Question

Hi, i was wondering if there was any way of creating a new
table in Access by using a webpage. Say im making a site similar to
ebuyer and i want a product to have reviews, but theres no reviews
for an item hence no table. When a user review this item a table is
created with the necessary columns and enters the data from the
review into the newly created table.

I realise Access is not very good for this type of site but i
do not know SQL enough in order to use MS SQL database yet.

Any help would be appreciated.

Thanks, Adam

muzicmistro · Answer

Ok so say i create a database with a main table with the main product details in (ProductID, Title, Price, Description...) and then create a reviews table with a ProductID column and relate them together it would work that way alright ? I could use a memo field in order to store more than 255 Characters.

Thanks for your help Julian. Also i know this has nothing to do with my original question but it is to do with shopping carts. How do i create the numbers in ASP like prices and they deduct and add as needed ? just create a session ID with a value then use then ' price= -1 ' ?

Thanks Very Much,

Adam

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.