About sharing the database connected to a data access page
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
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 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.
More information
Sharing an SQL Server database