Access 2010 and Web Services (not using Sharepoint)

[gregoryenelson]

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 ??

 

[G37Sam]

From what I read, it seems an easy way to do it would be to move your BackEnd to SQL Server and make that online.

 

[gregoryenelson]

Perhaps, but the only way the large corporation can get this through without months of committee meetings is to use Access a smallish Office tool. .....