Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Access Split Database Seminar
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   9 years ago

In this seminar, you will learn how to set up a database using Microsoft Access with multiple back-end (table) files: one that every database user can access, and another for sensitive information, such as financial data, that only a small, select group of users can access. You will then learn how to use Windows file and folder sharing to secure the sensitive back-end database file so that only the users you select can read that data. This seminar will cover:

1. Set up multiple customer tables, one for normal data, one for sensitive data
2. Build two customer forms; the sensitive form requiring a password to open
3. Split your database into 3 files: front end and two back-end files for tables
4. Create shared folders on your server or Windows PC
5. Use Windows-level file & folder security to prevent access to the sensitive data
6. Move the back-end files to the server and relink with the Linked Table Manager
7. Encrypt your front-end database and create an ACCDE file

You can learn more about this seminar here: Microsoft Access Split Database Security Seminar

Missing HB Upload Images   Link 
Edward Soares 
3 years ago
Hi Richard

for some reason I am not able to view the handbook of the Access Split Database Seminar via the "Theater Home"

Could you please look into it.  Thanks

Reply from Alex Hedley:
Add a Reply
Access Split Database Seminar Upload Images   Link 
3 years ago
I am also interested in this.[See below]
Currently I split a database and about 5 employees are using the one FE.accde file. We haven't had any issues, but let me know if you are aware of any. Did you ever make this seminar? That might work better for me. THANKS! Read More...
Add a Reply
Topic Interest Upload Images   Link 
Ravi Chandiran 
5 years ago

I am interested on this topic.

Thank You,

Ravi Chandiran

Reply from Alex Hedley:

Which topic?
Add a Reply
Linked PDFs Upload Images   Link 
5 years ago
They are in a folder outside of database but on same computer as database folder. I wanted to put copy of front end on different computer's and the backend on network/server. Everything works except this linked pdf. I really don't know vba coding that's why the seminars are so great! If front and backend stay on network/server with the pdf folder everything works great! I guess I could make a copy of front end for each person on network/server? Read More...
Add a Reply
Linked PDFs Upload Images   Link 
Mary Franklin 
5 years ago
Rick, I used your seminar on workorders to make my database. I've split the database now but I can't open my linked PDF's in my workorder file that was already there. But I can add a linked PDF.Can you help me! Read More...
Add a Reply
Shared Folders on the Cloud Upload Images   Link 
6 years ago
Can you set up the shared folders on the cloud?  For example, Box or Dropbox?

Reply from Alex Hedley:

Yes there is usually a right click option on the folder or a share button link. Read More...
Add a Reply
Synology server as SQL server Upload Images   Link 
Gergely Papp 
7 years ago
Thanks a lot! So what would you combine Access with in this situation?
Add a Reply
Synology server as SQL server Upload Images   Link 
Gergely Papp 
7 years ago
Hi Richard!

Thanks for the thorough seminar. I've checked several forums and in general people don't recommend copying the backend database to a shared folder on a NAS server. I've just learned that Synology can manage mySQL. Could it be an appropriate solution for a small company (with 5 client computers in various locations) to use the Synology server as SQL server. Read More...
Add a Reply
When it comes to setting up windows share properti Upload Images   Link 
David Koehler 
7 years ago
When it comes to setting up windows share properties, arent you also interest in turning off offline caching

Reply from Richard Rost:

That's a good idea, yes. I don't believe "offline caching" is the default setting though - but I could be wrong. Read More...
Add a Reply
excellent excellent presentation Upload Images   Link 
David Koehler 
7 years ago
excellent, excellent presentation

Reply from Richard Rost:

Thanks. :)
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

7/24/2021Missing Months
7/24/2021Center Vertically
7/22/2021Buy Access
7/21/202164-Bit Access
7/18/2021Splash Screen
7/11/2021Access Developer 30
7/11/2021Access Developer 31
7/11/2021Access Developer 31 Lessons

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access split database security seminar  Page Tag: whatsnew  PermaLink