An Access database is made up of objects, such as tables, queries, and forms. Tables are the main repository of data. Every other kind of database object helps you use the data that is stored in tables. So when you want to share a database, you usually want to share the tables, because they contain your data. When you share tables, it is important to make sure that everyone is using the same tablesÂ â€” so that everyone is using the same data.
Depending on your needs and resources, you have a variety of options for sharing your database. Following are some of the methods of sharing an Access database.
Split database – This is a good choice if you do not have a SharePoint site or a database server product. Tables go in one Access file, and everything else goes in another Access file, called a front-end database. The front-end database contains links to the tables in the other file. Each user gets his own copy of the front-end database, so only tables are shared.
Network folder â€“ In this, the database file is stored on a shared network drive, and people use the database file simultaneously. All database objects are shared.
SharePoint site – This is a good option if you have a server running Windows SharePoint Services. Several points of integration with SharePoint help make database access more convenient.
Database server – You should use this option if you have a database server available. Database servers are optimized for sharing data among many users. Only tables get shared.
Above methods are very much useful for sharing Access database according to the pertinent conditions. Sharing too often might end up in corruption of Access database. With Kernel for Access recovery software you can repair corrupt or damaged Access .MDB database file easily.