SharePoint and Data View

To create data source to Backup exec database (MSDE format)

1. Use SA and password for SA can be changed with Enterprise Manager
2. Use table "JobHistorySummary"

For ePO database (SQL 2000) - McAfee ProtectionPilot use "AVIView_LeafNode" view, but again I was not sucsessful with Windows Integrated Authentication, so used SA

Connection to Access databases is still not clear for me, despite the article with the connection description, I tried with Office Designer 2007:

For this demo I download a sample Access database from Office Online
http://office.microsoft.com/en-us/templates/TC010185481033.aspx
and placed it in a directory on my WSS server. The MDB can't be on a network share.Enable the Data Retrieval Services from the WSS Central Adminstration.
run the following stsadm command to check the OLEDB providers that are enabled

stsadm -o getproperty -propertyname data-retrieval-services-oledb-providers

If you don't see Microsoft.Jet.OLEDB.4.0 in the list, append it to the existing list of providers and set the new list of providers similar to this:

stsadm -o setproperty -propertyname data-retrieval-services-oledb-providers -propertyvalue DB2OLEDB;IBMDADB2;MSDAORA;OraOLEDB.Oracle;SQLOLEDB;Microsoft.Jet.OLEDB.4.0

In FrontPage, add a Data Source under Database Connection. You will have to select a Custom Connection string which should look like this

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\Drop\sample.mdb