uploading Ms access database ..

starter posted this at 18:02 — 5th November 2003.

Joined: Feb 2003

Hihi

My estate agent friend down the road was asking me if i could built them a simple database website and system, after consideration i ve decided to write a Visual basic program based Ms Access database. i ve kinda got that VB proggy side now up and running .

My next hurdle is to figure a way of how to make it idiot proof in uploading teh database onto my ISP's webserver, from there i ll build a website using ASP which i havent started yet.

So what im asking is if any1 have any experience who have done this be4 can gimme a few pointers, or know of any programs that is very easy to use (like 1 button process) that will just upload the database from the desktop straight into my ISP's webserver.

They are definately not very PC savvy if they thought stopping the clock on thier pc will extend the 30 days trail period on their software ...

Any help would be appreciated .

Thx

druagord posted this at 19:01 — 5th November 2003.

He has: 335 posts

Joined: May 2003

For uploading from asp you need to install some dll on the server. i used to use aspupload wich can be found at aspupload.com but you will have to pay for it. there are good exemple for different usage.

You must know that a access database on a web server is not a good idea at all. In my experience more then 2 or 3 users searching the db at the same times will make it incredibly slow, however i don't use MS product anymore so maybe they improved.

IF , ELSE , WHILE isn't that what life is all about

starter posted this at 03:09 — 6th November 2003.

They have: 80 posts

Joined: Feb 2003

2-3 connections ? ouch .. i thought it was about 15-20, but i cant be sure on that, reason why Access is because due to the database that is working with my VB program. im trying to make it real simple for these folks, thier database is not that big and also i really dont expect more than 15 connections at the same time.