How to connect to MS Access in Sharepoint Server

Hi Frndz,
i need some help.
I have a aspx page which needs to be coonected to MS Access DB and fetch the records in SharepointServer.
what command should i use to connect to a MS Access DB in Sharepoint Server.

1 answer

The connection string examples are on this site at: http://www.connectionstrings.com/sharepoint

To determine the ListID for your Sharepoint List, navigate to the list on the Sharepoint site. Click on the "settings" button and then choose "List Settings" from the drop-down.

When the list settings page finishes loading, observe the address of the page in the address bar in the browser. At the end of the address is the ListID.

Some of the characters in the list may be encoded, so you'll have to convert those into either curly braces or hyphens for your connection string.