Microsoft Access Connection

[chrisperkins]

Please help,

Could someone give me a step by step guide on how to display data from a Microsoft Access database in Sharepoint. I have looked at editing the Sharepoint page with Frontpage 2003, but it requires a connection string??? Do I have to set up a DSN datasource? All the examples are for connecting to Oracle or SQL Server.

Any help is greatly appreciated.

Chris

 

[willscarlet]

Access 2003 is sharepoint aware.

From Access click File, Get External Data, Link Tables and Sharepoint is one of the options in the files of type field.

Enter the URL of the sharepoint site and your authentication details and the lists at that site are displayed. Choose one or more and from then on its just another attached table that you can produce reports on etc.