Hi all - I am hoping someone can provide me with some insight on an SQL vs. MS Access issue. Here is the situation - I am in the process of designing a website that will have a good amount of DB interactivity. I am anticipating this site will also have a good amount of web traffic (given everything goes as planned).<BR><BR>The question then becomes - would it be more beneficial to use 1 SQL database with many seperate non-related tables (many being around 25) or use separate MS Access databases (i.e. one for each non-related table)?<BR><BR>From what I have been reading, it seems like SQL is the way to go but I just didn't know if stuffing everything in a single SQL DB would cause processing/overload issues.<BR><BR>And finally, one last question - if SQL is the best bet for what I am looking to do, what is the best route to create a SQL DB? I know Access 2000 has an upscaling wizard to do this but I wasn't sure how effective that would be? Or would I be better off buying a developers copy of SQL that would enable me to set up the appropriate tables/queries?<BR><BR>Thanks for any help you can provide!