get data from the web

[goodhead]

I'm building a database that stores data about people toy car collections.
How easy is it to have an online database that the clients can add a model number that they own and it queries it and populates their fields with data about that car.

Bit like mymovies.dk

local db but looks up movie info for your local db.

 

[Galaxiom]

Ideally you would design a page with ASP or PHP code.

The page can include a connection to a database. However it is not as simple as Access which can use bound forms.

HTML form fields are used to enter data, Javascript runs the actions to submit the form to the server and information is returned to elements such as tables or divs on the page.

It is a consderable learning curve.

Alternatively Access 2013 has web database facilities but I have never used them.

 

[goodhead]

Thats way way over hy head!!

Ideally you would design a page with ASP or PHP code.

The page can include a connection to a database. However it is not as simple as Access which can use bound forms.

HTML form fields are used to enter data, Javascript runs the actions to submit the form to the server and information is returned to elements such as tables or divs on the page.

It is a consderable learning curve.

Alternatively Access 2013 has web database facilities but I have never used them.

 

[Galaxiom]

If that is way over your head then unfortunately so is the task until you learn about web page design.

Your only option then would be to investigate web databases in Access 2013 but I don't know anything about them. However I doubt that any serious web resource would use anything other than php or asp based designs.

In these cases the backend database is usually held in MySQL or MS SQL Server.

 

[Catalina]

There is software that can generate a set of PHP based forms of an Access database.

I have used it in the far distant past and it worked, with some tweaking.
I'm sure the newer version is more capable and flexible.
But it's not cheap.

http://xlinesoft.com/phprunner

Catalina

 

[goodhead]

I'll stick with the main database being in access for time being.
If I wanted to have a feature called for sale. Users of the database can choose a model from their access database that they want to sell. It would then send to a MySQL page for models for sale. All users of this database would submit to same sql database. And also in their local access database a table of models for sale from others users by reading info from sql. Obviously relies on web connection, but not much of an issue these days.

How easy would this intergration be.

I have now got sql and dreamweaver working so know a bit about that now. Its just the intergration in access.