The Microsoft Access database or Microsoft SQL Server database that is the OLE DB data source for a data access page must be on a shared server or computer in order for other users to view and interact with the page in a Web browser or in a mail message.
It's a good idea to place the database on a shared server or computer before you create your page. If you move the database that the page is connected to after you create the page, you must change the OLE DB data source connection of the page. To do so, in page Design view, right-click on the database icon in the field list, and then click Connection.
Important Make sure you use a universal naming convention (UNC) path, instead of relying on the drive letter of a mapped network drive in Windows Explorer. A drive letter can vary on a computer or may not always be defined, whereas a UNC path is a reliable and consistent way for the page to locate the data source.
Although the data source of a page can only be an Access database or SQL Server database, you can make other data formats accessible from a page by using linked tables from an Access database.
To make your data access pages as secure as possible, you must put the Access database or SQL Server database on the same Web server as the data access page.
Sharing an SQL Server database
Importing and linking to other data formats