The actual problem with stolen data from a websites' database really has nothing to do with how the database's tables are setup. For instance, if you decided to maintain all you clients information in one table, the only way to access anyone else's data is to have complete control of the database. If you are righting code that allows the user to query the database using SQL, yes, they would be able to access other people's information. But I pray that you don't allow this kind of access. The reason that data is being stolen is not because a hacker exploits the program using the database as a backend, the reason is that the hacker gains access to your computer, and subseqently has complete control of you database. Storing seperate client information in a single table is not insecure by any means, only the code that accesses this database and the overall network security are the weak points. As for using Access for you database, this is not a good idea. Access is not designed to allow for multiple users accessing the data all at once. Sure for a small site that may have 1 to 5 people it will suffice. But once this threshold is reached, Access has major problems. Try setting a test database up and having several users access all at the same time and you will see what I mean.
---------------------------------------------- Scott Anderson BTS/Compupay [EMAIL PROTECTED] 206-242-7088 xt231 ----- Original Message ----- From: "Bj" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 23, 2002 3:12 PM Subject: [wdvltalk] Re: Question on SQL Server Tables > ----- Original Message ----- > From: "Amrit Hallan" <[EMAIL PROTECTED]> > > > I think the privacy can be maintained in a single > > database too. Take for an example, a bank accounts > > database where privacy is a critical issue. Still, they > > don't have separate tables for separate customers. > > We have a unique account number in a common > > database and still our details cannot be accessed > > by other customers. > > I don't think you ever read the newspapers or watch the television, Amrit! > That happens all the time. Banks, insurance companies, utilities, shops and > even the UK Inland Revenue (tax authorities) have all had problems with > customers accidentally seeing each others' details. > > Bj > > > > ____ . The WDVL Discussion List from WDVL.COM . ____ > To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] > Send Your Posts To: [EMAIL PROTECTED] > To change subscription settings to the wdvltalk digest version: > http://wdvl.internet.com/WDVL/Forum/#sub > > ________________ http://www.wdvl.com _______________________ > > You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
