Updating a split ms access database hot dating in mumbai

02 Dec

This article discusses key best practices to deploy your Access database.This item is a must to make upgrades to your end users easier.A split database in MS Access simply means you will have one file that contains your tables only.This is sometimes called a "back end" or "data file." For simplicity, we'll refer to it as your Access Data File.Access is a desktop database, and you can store data and interface objects in the same file.But most developers agree that a split database is easier to protect and maintain.The second file is what is usually called your "front end" database.There is really no data stored in the file, it only contains your forms, queries, reports, macros, VB modules, and With your data separated from the user interface (forms/queries/reports) and business logic (VB/macros), you can keep the data anywhere that your users are able to gain access.

This arrangement solves a number of problems inherent to the Access file structure.Most of the users working in the front end won't realize they're actually working with two separate files, so splitting the database will have no negative impact on your users.However, this arrangement is not a comprehensive security lock on design.Splitting a shared database can help improve its performance and reduce the chance of database file corruption.After you split database, you may decide to move the back-end database, or to use a different back-end database.