link access database to a database on the internet

[Dealerloyalty]

I have a database of automobiles sold last month by 10 dealers.
I want to know how to set up on the internet a way I can have each of the 10
dealers log in and post the vehciles they sold so I can downnload the date
into access on my computer.

 

[Joe Fallon]

You can use an Access database on a Web server to do this. (Or SQL Server
Express.)
It is not the most common solution, but if done properly, it will work.
Designing a web site is a whole other problem. You can use ASP or the newer
ASP.Net.
If you don't have the skilss, equipment, funds to do this - then have then
email you a Text file in a standard format that contains the data you need.

 

[Dealerloyalty]

Thank You - I have downloaded ASP.Net Generator and now have to learn SQL
"where" to proceed.