1 / 9

Database Splitters

Database Splitters. Let’s think about our database. Anyone who has access to the database can make changes in any place. An inexperienced someone might delete valuable data accidentally or corrupt created macros, etc. So far we’ve created single user databases.

blantonc
Download Presentation

Database Splitters

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Splitters

  2. Let’s think about our database . . . • Anyone who has access to the database can make changes in any place. • An inexperienced someone might delete valuable data accidentally or corrupt created macros, etc. • So far we’ve created single user databases. • Realistically, several people could have and would need access to a database at the same time.

  3. Our database . . . • The larger a database gets, the slower or more sluggish it tends to become.

  4. How can we alleviate these problems? • Through a database splitter. • A database splitter protects the data that is stored in tables. The tables remain in one location while forms, queries, etc., are maintained in another location.

  5. How do we split a database? • By using the Splitter wizard. • Warning! Before splitting a database, create a backup copy of it! • This is a risky process.

  6. How do I split the database? • Create a backup copy first • Click file, save and publish, backup a database. • In Access, click the Database Tools tab. • In the Move Data grouping, select Access Database – Note the icon shows a single database splitting into two sections (a front end section and a back-end section). • The wizard will walk you through the rest of the steps.

  7. Database Splitter . . . • When the wizard asks for file names, use the default names.

  8. Database Splitter . . . • The users will utilize the front-end file created during the split. • Send the users an e-mail with the front-end file attached; or • Store the front-end file on a network server for users to copy to their computers; or • Copy it to removable media for loading onto users’ computers.

  9. Database Splitter • The developer of the database can continue to make design changes to the database, while users are inputting data, etc. • Now use this process to create a splitter on your Nursing home database and then repeat on your Resort Rentals database.

More Related