Microsoft Access software lets you create a small database you can use on your website. You must first create a new database, then create the tables that store the website information. Access is beneficial for small websites and webmasters who are unfamiliar with database structures. Access includes a wizard and designer that helps you create a website and its tables.
Using Access Database For Website
Microsoft Access Databases can be used in all Web Hosting Plans. You should upload your own Access Databases. Please do not create your Access Database using the File Manager in your Control Panel.
If you want to use Microsoft Access Database, please send a Support Ticket to ask for your website to be put in 32-bit Mode on IIS. This is because our Web Servers are 64-bit Servers and all websites are in 64-bit Mode by default. Whereas Microsoft Access is an old technology and can only operate in 32-bit mode on IIS.
Access 2010 and Access Services (an optional component of SharePoint) provide a platform for you to create databases that you can use on the Web. You design and publish a web database by using Access 2010 and SharePoint, and people who have SharePoint accounts use the web database in a web browser.
How it works
When you publish a web database, Access Services creates a SharePoint site that contains the database. All of the database objects and data move to SharePoint lists in that site. The following video illustrates the process.
After you publish, SharePoint visitors can use your database, based on their permissions for the SharePoint site.
Full Control This lets you make data and design changes.
Contribute This lets you make data changes, but not design changes.
Read This lets you read data, but you can’t change anything.
You can open the web database in Access, revise the design, and then sync your changes — effectively, save them to the SharePoint site. The following video illustrates the process of making a design change after you have published your web database.
You can also take your web database offline, use the offline version, and then sync data and design changes when you are back online.
Note: To build a web database, you need Full Control permissions on the SharePoint site where you want to publish it. For more information about SharePoint permissions, see the See Also section.
Forms and reports run in the browser
Forms, reports, and most macros run inside the browser. This lets Access refresh data on the screen without having to redo the whole page.
You can create a form to help people navigate your application. A new control, the Navigation control, makes it easy to add standard Web-style navigation buttons to a form for this purpose.
Note: The Navigation Pane (the feature that you use in Access to browse the objects in a database) is not available in a web browser.
Data is stored in SharePoint lists
All of your tables become SharePoint lists, and records become list items. This lets you use SharePoint permissions to control access to your web database, as well as take advantage of other SharePoint capabilities.
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). 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. 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. Exercise caution when you share copies of a database that contains links to lists in a published web database.