I currently run a cricket equipment website for a customer, which is manually controlled from a stock point of view and ordering system (using mals-e.com)
I'm now looking to take the website to the next stage which would be to control it via a database. This would allow my customer to update his own stock levels and have some control over what appears on his offers page etc.
The website has been designed in frontpage and I now have hosting which supports asp asp.net access databases & mysql
So I have a couple of questions for anyone willing to help.
1/ Is access the best database to use ie what limitations are there to number of users using the database at one time ?
2/ If I use access is it better to have several smaller tables of one or two bigger tables, is there an optimium size for a table to be ?
Thanks in advance
I'm now looking to take the website to the next stage which would be to control it via a database. This would allow my customer to update his own stock levels and have some control over what appears on his offers page etc.
The website has been designed in frontpage and I now have hosting which supports asp asp.net access databases & mysql
So I have a couple of questions for anyone willing to help.
1/ Is access the best database to use ie what limitations are there to number of users using the database at one time ?
2/ If I use access is it better to have several smaller tables of one or two bigger tables, is there an optimium size for a table to be ?
Thanks in advance