Newbie Advice - Access & Asp website development

Here is the deal, I'm developing an Access 2007 database for my business. I want to be able to have my website save results from context sensitive forms into the relational database. By context sensitive forms, I mean the user selects A, B, or C and the forms dynamically change to depending on the results.

I'm technically savvy, but not a programmer and while I can figure stuff out given enough time, I want to avoid making mistakes.

I am using Microsoft Expressions Web for the "design" aspect, but will likely hire somebody to create the context sensitive forms to save the data in the database.

My basic question is what is the preferred/best way to get the data from the Website into my access database stored locally on my server? Access 2007 doesn't appear to want to connect to the .mdb file, say it can only connect to a file locally or with a UNC path. In fact, Access says it can only connect to XML files, but the discountasp.net server apparently isn't XML compatible according to Expressions Web.

Should I first develop my tables in Access then convert them to SQL then ... what?

Any advice to get me on the right track would be much appreciated. Referrals to somebody that can handle the web forms and database connections would also be great.

I've read so much stuff, I'm now starting to get confused and unsure what direction I should be heading.

Post Edited (TemeculaMike) : 9/5/2007 3:53:57 AM GMT

 

That is what I was afraid of. Does anybody know of an easy way I can sync the remote dbf file to my local server (say, every hour or so)?

 

Unfortunately this will not be possible with MS Access. MS Access was always intended to be a desktop database not a server side database. This is a limitation of MS Access. If you are looking to access a database directly via remote connection, your best bet is to upsize to a SQL 2000 or SQL 2005 database.