Thank you Richard. This is very helpful.

Yes, Q3 was about whether users can upload the data that they entered in the offline db. I later remembered the techniques you demonstrated in the web synchronisation seminar and deleted the question.
Q4 was accidentally removed. I wanted to know whether you can upload more than one Access db for one domain name. In the examples i have seen so far in the lessons, you used only one database.

Once again, thank you Richard.

MICAH

---

Reply from Richard Rost:

3. Yep, that's what the Web Synch seminar is for. I do that myself, still, for a lot of things. My course database, for example, is kept in my office (offline) Access database. When I add a new class, I put all the info in my Access DB and then click one button to upload it to the web site's database.

4. Yes. This is actually a pretty complex answer. There are several different ways to set up Access databases online. The first, and easiest, method is actually NOT the one I show you in the original ASP Access Web Database Seminar. That method involves having your OWN Windows Server, or the ability via your ISP to set up a System DSN (Data Source Name). It allows you to set up databases that can be shared across multiple domains. That's why I also included instructions on the outline page to do it a different way (I thought of this AFTER the seminar was finished)...

In the Web Synch Seminar, I show you how to upload a database (MDB file format) using FrontPage or Expression Web and then just connecting directly to it WITHOUT a DSN. You just put all of the code you need to connect to the database in your ASP code. This allows you to have as many different database files as you want for your web site, but you can't share them across domains.

There's also a third option which I haven't covered. Many ISPs (like the one I currently use, GoDaddy) have options in their user interface to add Access or SQL Server databases. Their GUI takes care of all the setup for you. I'll probably make a short video in the future showing how to do this at least for GoDaddy.