Linking to a web hosted database

[denimknight]

Hi all,

I'm looking to link tables on a local access database (either 2007 or 2010, not decided yet) to tables held on a website.
Basically it will be a kind of stock control type of thing, where if someone places an order online the number in stock will be reduced by 1 and the local copy of the database will reflect this change automatically.
I was wondering if this is possible to do and if it is, how hard it is to set up.

Hope someone can help.

Thanks

Alex

 

[Pat Hartman]

It is actually quite easy to set up. You just need to set up a DSN with the IP of the server-side database. The web-database needs to be able to accept connections but I have no clue how to make that happen. The DBA should though. I've posted a picture of a database I tested with. The connection no longer works but it is an example of how easy it is.