nicora — Mon, 14 Mar 2005 20:02:51 +0000

any db will be more effective than a txt file. i agree with openmind that MySQL is your best bet.

openmind — Mon, 14 Mar 2005 19:01:28 +0000

TBH you shouldn't really use Access as a production database as its limited by concurrent connections and is not designed for web sites. MySQL is a much better method and using a tool such phpMyAdmin or MySQLFront, simple to manipulate...

CptAwesome — Mon, 14 Mar 2005 16:10:31 +0000

I've never really dealt with Access, so, it could be a full DB, but I'm not sure if the processor burden is on ASP (in your case) or if there is a background process running that is Access.

bja888 — Mon, 14 Mar 2005 14:40:14 +0000

Ok so lets try this a diffrent way... I can write a SQL string to retrive infomation from a Acess database. Now how is that diffrent or simaler to useing MySql?

CptAwesome — Mon, 14 Mar 2005 06:46:31 +0000

SQL stands for Structured Query Language, and it's a database programming language. I think it takes a lot of the work out of the PHP/ASP programming by using smaller statements to gain information quicker. I could be wrong though. Always fun to read The Wikipedia Article on it

bja888 — Mon, 14 Mar 2005 06:36:08 +0000

The only thing I know about SQL is.... you gotta make one string to retrive serten thing from a database. Other than that I dont know any thing about those 3 letters. Fill me in please.

CptAwesome — Mon, 14 Mar 2005 02:04:08 +0000

Well, I don't think Access is a real SQL DB (though I could be wrong) so it's just semi plain text. If you get something like MSSQL or MySQL then that's faster and more secure. If you have an Access DB created, I'd use that because it probably automates the data input process more, and would make for cleaner code.