I've made the effort to read thru some of the threads so that I don't duplicate them but I can't find anything, so here goes.
I'm kinda new at this, so be gentle .
I'm building a database driven site using ASP (no lectures from MS haters, cos I'm trying to learn other stuff too) and I'm using Access.
OK, I'm trying to build a database with information of companies from different countries. Each company profile would consist of the basics. Name, address & contact no. Then there's other stuff about them. I was thinking of creating seperate tables for them as there would be too many fields/colums if I dumped everything in a single table.
Now my question is, do I create these tables for EVERY country in one db (too many tables in one db). Or is it better to create A db for each country (too many dbs).
I hope my question is clear & someone's able to give me an appopriate answer. Remember I'm not a pro like most of you guys (& gals). So take it easy. Thanks in advance.