Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

News      User Comments     History     Notify Me

5/18/2014 2:28:53 PM
Microsoft Access Expert 21
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

Microsoft Access Expert Level 21 is 1 hour, 54 minutes long. In this class focuses on importing from and linking to other Access databases, setting up your database for a multi-user environment, splitting your database into front-end and back-end files, and record locking. Lots of good stuff in this course if you have any intention on sharing your database on a network. Topics include:

- Import Access Database Objects
- Linking to Other Access Databases
- Splitting Your Database
- Custom Front-End and Back-End DBs
- Database Splitter Wizard
- Shared Folder Permissions
- Creating an Encrypted Front-End File
- Preventing Design Changes
- Record Locking in a Shared Environment

Click here for more information on Access Expert Level 21, including a course outline, sample videos, and more. This course was recorded using Access 2013, but is also valid for Access 2007 and 2010 users. This class follows Expert Level 20. The next class in the series is Expert Level 22.

Permanent Link
Course Link: Microsoft Access Expert 21
Keywords: access expert 21 importing linking splitting splitter encrypted accde record locking
Page Tag: whatsnew
Post Reply

Renamed front end Comment from vicki Hudson @ 6/3/2015
The front end can not find the .accdb file that I renamed.  time 9:26 in video.  I get  the error if I rename to .accdb.  I think I will split manually :-).  I just like things to be exactly like in the video but we were hown how to manually do the split
Show Just This Thread        Post Reply
Split Database shows accdc Comment from Vicki @ 5/31/2015
I tried that and it automatically added the .accdc to the end and I had a file with .accdb.accdc. Unusable file. I tried checking for updates to access as well. Thanks for the reply

Reply from Alex Hedley:

Looks like you don't have file extensions showing.
Show them then you can actually change the file extension and not just the name

Displaying the File Extension in Windows Vista and Windows 7

1. Click the Start menu. ...
2. Type "folder options" (without the quotes). ...
3. A dialog box with the title "Folder Options" will appear. ...
4. Click to uncheck the box for "Hide extensions for known file types".
5. Click the "OK" button at the bottom of the dialog box.
Show Just This Thread        Post Reply
Split Database shows accdc Comment from vicki Hudson @ 5/30/2015
At 4:22 you click on "Split Database" , It gives you a file name with the extension of .accdb.  Mine is showing extension.accdc (Microsoft Access Signed Package (*.accdc).  I don't have an option to change it to .accdb.  How can I change  extension? Not sure about the .accdc functionality.

Reply from Alex Hedley:

This looks to be an issue with Access 2013
Sources say you can just rename it .accdb and it will work.
Might be worth testing this to confirm
Show Just This Thread        Post Reply
Comment from Fernando Romero Galvan @ 5/21/2015
Interested in a networking class! That'd be cool
Show Just This Thread        Post Reply
Drag Drop Objects Comment from Michael @ 5/16/2015
Hi Alex,

I am not able to open two Access databases simultaneously. When I try to open a second database, Access opens it but then when I try to switch back to the first one I can't find it. I am guessing Access closed it. Is there a settings adjustment that I need to make somewhere? (Other than my brain, of course...hahahaha.) Thanks in advance for your help.


Reply from Alex Hedley:

So you can't open Access ready on the choose a db screen, and repeat.
Two aren't showing in the Taskbar?
If you Alt+Tab you can't switch between them.
Does the Task Manager not show two in the Applications tab?
Show Just This Thread        Post Reply
Drag Drop Objects Comment from Michael @ 4/25/2015
Hi Richard / Alex,

In lesson one (Import & Link Access Objects), you show clicking and dragging a table from one database into another. When I tried this, I wasn't able to simulate what you demonstrated - I think that I may not be able to have multiple Access databases open...can you please let me know where I may be going wrong?


Reply from Alex Hedley:

Are you getting a cross symbol when you try and drag it?
Are you dropping into the Navigation pane, table section?
Is it accdb to accdb?

Can you copy paste the objects?
(Even copy paste a table from excel should paste in as a Table in Access,)
Show Just This Thread        Post Reply
Small Office Network Class Comment from Scott Schumacher @ 4/7/2015
I am also interested in small office network class. Please let me know if you decide to do one.
Show Just This Thread        Post Reply
Microsoft Access Expert 21 Comment from Nicholas S @ 3/18/2015
Hi, If I add a new table to my front end how do I get it to the Backend and how do I then link it for the local computer and other users
kind regards

Reply from Alex Hedley:

You'd want it adding to the Backend then you'd need to redistribute the FE to your users.

Or you would have to use some fancy SQL that's covered in the SQL Seminar Series.
Show Just This Thread        Post Reply
Missing Digital Signature Comment from William Lewis @ 3/4/2015
I have the same problem as Brian. When I followed your steps it created the back end. But now when I open the back end file it shows a warning saying that it is missing a digital signature. The type of file matches yours so nothing is different except I cannot open.

Reply from Alex Hedley:

Is this on a domain environment too?
Show Just This Thread        Post Reply
vba distribution front end Comment from CHARLES FULGHAM @ 2/4/2015
Mr. Rost, another vote for vba distribution front end updates. Thanks!

Reply from Alex Hedley:

Me too
Show Just This Thread        Post Reply
Network Course Request Comment from Hans Peeters @ 1/8/2015
I'm interested in a network course :-)
Hans from Belgium
Show Just This Thread        Post Reply
Shared database Comment from John Kosey @ 12/9/2014
Hi Richard
Your lessons made it possible for me to put together a database for a prayer group. I have it on my home pc using Access 2013. Can the database be shared with four users using Office 365's Access? Can I upload it to Access Office 365?

Reply from Alex Hedley:

Hi John,
Have you seen Rich's Blog Post on the matter?
It should help with a number of options you can try.
Show Just This Thread        Post Reply
So heres an odd thing I split my database and it Comment from Brian Farley @ 11/7/2014
So heres an odd thing.  I split my database and it will only save it in a "Microsoft Access Signed Package"  Still has a .accdb but a different icon.  Also, I can NOT open the backend directly.  Throws an error stating that there is no digital signature and to have the issuer send me another copy.  Well I'm the sender so that's not going to work.

I worked around this just by coping the tables to a new db, deleted the tables in the working db and linked the tables.

So what happens to the joins?  like the global ones.  They had to be deleted when I deleted the tables.

I'm on a domain environment, so I'm thinking that's why I can't split them properly, unless you have another idea.

Office 2013, current and updated.

Keep up the great work!

Reply from Alex Hedley:

Hi Brian,
If you just click save does it prompt to save as another format?
If you click Save As does it give you other options?
Were you the original developer of the access db?
Could someone else already have signed the db before?
Show Just This Thread        Post Reply
Comment from simon baynton @ 8/29/2014
Here is another vote for mini seminar on distribute new front-end database updates using VBA code.


Show Just This Thread        Post Reply
Split Databases Comment from Salvatori C @ 7/5/2014
Hello Richard.
    Is the speed of the network the basic restriction of why not have both front end and back end files on the server. Having the front end and or the encryption  file on the server would be easier to manage with only a short cut to the files on the desktop.

Reply from Richard Rost:

Yes, it would make management easier, but you're also transmitting a LOT of extra information over the wire. Having your front-end local saves a lot of load time and overhead unless you have a REALLY fast network and/or a REALLY small database file.
Show Just This Thread        Post Reply
Comment from Bonnie @ 5/27/2014
Richard, I would be interested in such a mini-seminar, also comments and tips on further development once you have split your database.

Great classes!
Show Just This Thread        Post Reply
Comment from Alice Morgan @ 5/27/2014
Good Afternoon, Richard.  I am also interested in Database updates using VBA.  Hope it gets enough interest! :)

Show Just This Thread        Post Reply
Comment from James Gray @ 5/21/2014

I would like to see this as well.  Thanks
Show Just This Thread        Post Reply
Microsoft Access Expert 21 Comment from Deon R @ 5/19/2014
Hi Richard,

Please count me in on this mini seminar.

Thanks for this and best regards,

Show Just This Thread        Post Reply
Comment from Richard Rost @ 5/19/2014
So far, one student has asked if I will show how to distribute new front-end database updates using VBA code. If enough people are interested, I can make this into a mini-seminar. Post here or email me if you're interested.
Show Just This Thread        Post Reply
Microsoft Access Expert 21 Comment from Deon R @ 5/19/2014
Hi Richard,

As usual the course was brilliant. Thank you for the excellent teaching and giving us your experience.

Looking forward to the Developer Series.

Kindest regards,

Show Just This Thread        Post Reply

Add Your Comments or Subscribe
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
  Your Name:  Required
  Your Email:  NOT Public


Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 7+7:
  Notify me when the News is updated.
  Remember Me for my next comments
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard



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

6/20/2019TIP: Validation Rules in Access
11/20/2018Microsoft Access Developer 12
8/25/2018NEW: Access Dev 9, 10, 11
8/25/2018Microsoft Access Developer 11
8/25/2018Microsoft Access Developer 10
8/25/2018Microsoft Access Developer 9
8/23/2018Access Dev 11 is ONLINE
8/17/2018Access Dev 10 is ONLINE
8/15/2018Access Tip: Search Form
8/15/2018Access Tip: Locked v. Enabled

Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP