|
||||||
Access 21 is Online By Richard Rost ![]() ![]() ![]()
00. Intro (7:14) 01. Import & Link Access Objects (14:45) Import by Click-and-Drag Import by External Data > Access Browse to Database Folder Import Objects Dialog Import Options Import Table Relationships Import Menus and Toolbars Import/Export Specs Import Nav Pane Groups Import All Images and Themes Table Definition AND Data Table Definition Only Import Queries as Tables Importing vs. Linking Link to Customer Table Custom Forms for Front End 02. Multi-User Database Theory (14:53) Sharing a Database Why Split Your Database Front End vs. Back End Databases Pros and Cons of Split Databases 03. Splitting Your Database 1 (20:38) Compact & Repair First Backup Your Data Database Tools > Move Data > Access Database Splitter Wizard The database engine could not lock table Already in use by another person Notice Linked Tables Set up Shared Folder Linked Table Manager Rename or Move Backend Database Refresh Location of Backend Links Setting up a Shared Folder Folder Properties > Sharing Assign Shared Folder Name Setup Folder Permissions Select Users or Group UNC Path Mapping a Drive Letter 04. Splitting Your Database 2 (21:15) Storing Images on Server Share Creating a 2nd Back End Database Move a Secure Table to Different File Creating a 2nd Front End Database Custom Databases based on User Role Distribute Encrypted Front End Users Cannot Make Design Changes File > Save As > Make ACCDE Trusted Location - Shared Folder 05. Record Locking (28:42) How Default Record Locking Works Write Conflict Error Message Save Record, Drop Changes Copy to Clipboard Form Properties > Record Locks No Locks, All Records, Edited Record What is an LACCDB file? Database Client Settings Page Level vs. Record Level Locking Default Open Mode: Shared / Exclusive File Open for Exclusive One Time Use Default Record Locking Open databases by using record-level locking Changes take effect when first user opens db Delete LACCDB file if record still locked 06. Review (6:15)
|
||
Check out these other pages that may be of interest to you: |
|
| |||