how to back up your split database in microsoft n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
How to Back up Your Split Database in Microsoft Access PowerPoint Presentation
Download Presentation
How to Back up Your Split Database in Microsoft Access

Loading in 2 Seconds...

play fullscreen
1 / 7

How to Back up Your Split Database in Microsoft Access - PowerPoint PPT Presentation


  • 2 Views
  • Uploaded on

If you are looking for Ms access query https://www.amazon.com/Microsoft-Access-2016-Understanding-Relationships-ebook/dp/B077ZF997L/ref=sr_1_3?s=digital-text&ie=UTF8&qid=1519245676&sr=1-3\n

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'How to Back up Your Split Database in Microsoft Access' - BenBeitler14235


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
a split database is created by splitting

A split database is created by splitting two database files ending up with a ‘Back-End’ and ‘Front-End’ database files.

A ‘Back-End’ database normally contains only the data tables while the ‘Front-End’ comprises the remaining database objects such as queries, forms, and reports.

The data that a user inputs in a database object will be stored in the tables that back-end databases hold. Anybody can go through the information available in the front-end database but in order to access the back-end, the user needs to have administrator permission. 

Splitting a database can improve its performance, help secure your data, and enables greater availability.

Since both databases have diverse properties, they are also backed up self-sufficiently. Front-end databases, which containminor types of data, use up less space.

Because of that, it takes a smaller amount of time to create the backups. But that’s the not the case with back-end databases as they hold all the data. For that reason, it is imperative to generate regular backups to avoid incidents of corrupted Access databases.

creating a backup for back end databases before

Creating a backup for Back-end Databases

  • Before generating the backup, make sure to inform all users on the system about it. Creating a backup requires exclusive access to all the database files. This process restricts users from using the database.
  • Here are the steps in creating a Back-end database backup.
  • Start Access.
  • Click Open Other Files.
3 click browse

3. Click Browse.

  • 4. Select the back-end database file that you want to back up.
  • 5. Click the arrow next to Open.
  • 6. Click Open Exclusive.
7 click file and select save as 8 under file

7. Click File and select Save As.

  • 8. Under File Types, click Save Database As.
  • 9. Under Advanced, click Back Up Database.
  • 10. In the Save As dialog box, review the name of your database backup and select a location in which to save your backup.
  • 11. Click the Save button.
creating a backup for front end databases since

Creating a backup for Front-end Databases

  • Since the front-end database is available to most users in an organisation, they all have a separate copy of that database. Users may modify and restructure their copy according to their needs. The changes made by a user to his own copy of the front-end database will only be visible to him/her.
  • Every user needs to generate a backup of the front-end database especially if he wants to see the customised arbitrary design changes in the front-end database.
  • Here are the steps in creating a Front-end database backup.
  • Once you’re done making the necessary changes, click the File tab.
  • Then, click Save As.
  • Under File Types, click Save Database As.
  • Under Advanced, click Back Up Database.
  • In the Save As dialog box, review the name of your database backup and select a location in which to save your backup.
  • Click the Save button.
contact us ben beitler ben@accessdatabasetutorial

Contact us Ben Beitler

ben@accessdatabasetutorial.com

(+44) 7881 502400

United Kingdom

London

https://www.accessdatabasetutorial.com/