exposing Access / web services

[gregnell00]

We need to install a database and make data accessible across the internet (via XML/txt or linked tables - can someone give me pointers on this ?

Microsoft's website has a page 'Creating a Web Service data connection' where Access 2010 can create a web service to a source and apparently link tables: the ribbon should have the path 'External Data tab > Import group > Web Service' but my 2010 has External Data > Import & Link > and no web service icon. So I cannot even investigate.

We would like a remote site to ask a question of the server, have the Access database run some selects and transmit to the remote client an XML /txt file etc.



How can I do this ??

[TheShabz]

Unless you have a SharePoint Server, I'd really avoid using Access for web interfacing. php/MySQL is your friend.