When you have determined what your application must do, consider whether a database template would work. Note: The following list is not exclusive. Macros and data macros New macro design experience with IntelliSense Reviewing summarized data, such as sums, averages, and groups The following table lists the desktop-only features, and the new feature that helps support the same scenario. However, there are new features that support many of the same scenarios as these desktop features. Some database features that you can use in a desktop database are not available with Access Services. Plan security early so you can build it into your design. Plan your security You can take advantage of SharePoint security to control access to your web database.
If you want to test your design in a browser while you design it (not a bad idea), you have to publish it first. Identify the SharePoint site you will use to publish You cannot publish at all without SharePoint. If you line up your data before you start designing, you can avoid having to refit your design to accommodate unexpected data challenges. Any data that you want to use that will not originate in the database must be imported before you publish. Moreover, there are design differences between web databases and desktop databases that you should know about, especially if you are an experienced Access developer.ĭetermine the purpose of your database Have a clear plan so you can make good decisions when working out design details.įind and organize the information required You cannot use linked tables in a web database. There are a few tasks that you should perform before you start to design your web database. Maintain data integrity by using data macrosĬreate a Navigation form and set it as the default form to display on start Set up a record validation rule and messageĬreate a relationship between two web tables Set up a field validation rule and message In this sectionĭesign differences between desktop and web databasesĭesktop-only features with no Access Services counterpart This section describes key new features and provides steps for the basic design tasks you need to complete to create a web database.
Microsoft is offering an Internet-facing, hosted SharePoint solution. You can publish to your own intranet SharePoint server, or to the Internet. This helps improve network performance by limiting traffic to result sets. Queries and data macros run on the serverĪll SQL processing happens on the server. Exercise caution when you share copies of a database that contains links to lists in a published web database. Even if the credentials aren’t saved with the connect string, a malicious user could modify permissions on the SharePoint site with the assistance of a collaborator who already has sufficient permissions. In a database that has a link to a SharePoint list and the link includes the username and password, a malicious user could change which list is the target of the link, using the saved credentials.
Online microsoft access database password#
Security Note: The connect string for linked tables is unencrypted, including the username and password if that information was saved (and the link target supports user accounts).
0 kommentar(er)
