-
I have NEVER used asp or have never done any web development, so please excuse...
If I create a database (lets say an Access db) on my pc - c:\mydb and write a program which searches this database and upload it to my ISP and someone enters my webpage - where does the database get hit?? On my pc or do you upload the db to the ISP as well.
Another question is...
Say 1000 people connect to my page and try to search my db - how does a db like access handle this because as far as I know Access can only handle a limited amount of connections - do you need something bigger like SQL Server in such a case??
As I said, sorry for being stupid, but I'm VERY interested in learning this stuff.
-
Hi turfbult
for your first question, yes you do have to uppload your database to your ISP unless 1. you have direct network access from your PC to the host server or 2. Use RDO (But that means your computer needs to be on 24/7 connected to the net.
As for your second question. It is very rare for a page to get that may hit's at that precise time, but if it did happen access would just deny permission untill some connection's become free. But when I say access, it isn't actually access that goes to the database, it is IIS using an access driver to go to the databas using ADO. And finally if you did have that problemm SQL server does handle more connections
Hope this helps
Ian
-
Thanks
Thanks Ian,
This does help!!
I am definintely going to give web development a bash!!
