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  


Microsoft Access Forum
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

This forum is for the discussion of Microsoft Access.

Access is my personal specialty. Have questions? Comments? Want to discuss how to do something? Post it here. Also, I get a LOT of questions sent to me in Email from people around the world. I'll post the interesting ones in here. Feel free to comment on them.

Click Here To Subscribe to this forum and receive an email update whenever new posts are added, just scroll down to the bottom of this page and enter your email address in the comment form.

Permanent Link
Keywords: microsoft access forum
Post New Topic

Read Popup issue and Access 2010 issue by Gregory C. S @ 7/29/2017
The six tabbed forms were massive, many with several tabbed subforms, filling 1920x1200 screens with very little white space.  So, yes the 6 forms were much denser than what normal folks use and could cause memory problems, I decided.
Compacting and repairing, almost daily, kept the database healthy for over 6 years.  When I got the "you don't have exclusive access..." errors, I split the database as Alex Hadley recommended.  That error went away (Thanks, Alex, I was hero for a bit) but users started having memory issues with their computers.  Desperate to find a solution, I found a couple other folks griping that they did not have the "exclusive access" errors until they migrated to Access 2010.  I realized that I had just dumped my whole database into a blank 2010 dB, hoping to get newer features. I started rebuilding tables from scratch but gave that up when I realized the AutoNumber IDs would be renumbered if I pasted data into my new tables.  During the last weekend, I recombined the dB as Richard Rost taught me. Then, I cleaned out an old 2012 backup (old enough to be sure I was in Access 2007) and imported each group of objects into that old, 2007 version.  The unsplit database ran healthy and fine all week. And, with the single dB, we are able to continue taking the dB with us on trips to customers (tribes) at remote sites in Alaska and have all of their records on the small 90MB file.  
I think there is bad ju-ju in Access 2010.  I am happy now.  Lots of that happiness is thanks to Richard's lessons.  His lesson on importing was much faster than copying and pasting groups of objects.

Reply from Alex Hedley:

It's a shame that didn't work, glad you managed to restore from an backup.
Show Just This Thread        Post Reply
Read Popup issue by Gregory C. S @ 7/19/2017
Well, splitting the database and pushing the Front Ends to the Desktops of the users did eliminate the "...not have exclusive access..." errors.  However, perhaps because my AutoExec macro opens 6 tabbed forms, some of the users are getting errors that say, "Cannot open any more databases."  I have urged the users to close a couple forms and that seems to help, prompting me to think the local front ends are bumping into memory issues.  Is there something I can do besides opening fewer forms with the AutoExec macro?
And, my department head really liked the single dB that worked fine for us for 6 years until I updated all of the tables by moving them into a blank 2010 (still 2007-style?) database. I am recreating empty tables in an older, emptied, backup file without importing the newer-version tables.  I hope I am on the right path to get away from the newer-version tables that seem to have caused the "...not have exclusive access..." errors.  Advice or suggestions?

Reply from Alex Hedley:

I've seen this a couple of times on the Forum recently, it should be when a large number of objects are open, I wouldn't expect it at 6.
Was the db compact and repaired before distributed?
Does it compile fine in the VBA Editor?
Are they having memory issues?
Show Just This Thread        Post Reply
Read Popup issue by Gregory C. S @ 7/17/2017
I watched Richard's videos about splitting the database 3 times and moved my dB before splitting it.  I created a "READ THIS" file in the folder where the dB used to be.  The Notepad file was my explanation to the users that they need to put a copy on their computer.  The Notepad text for my users may help you.  The text follows:
In an attemt to get rid of the annoying "exclusive access" error messages, TTIMS has been moved so I could split TTIMS away from its usual location.

TTIMS has been split into two segments -- Back End (Tables) vs. Front End (Everything Else).

If I had left the Front End in the place that you are used to finding TTIMS, you would not know that the file with the same name as the real TTIMS is only a partial file that you need to copy anywhere you want.  I suggested copying the file your Desktop.

The file in the folder below looks like TTIMS but the tables are linked to the Back End of TTIMS.  The table icons are a bit different in the Front End and show tiny arrows pointing to a table icon.

Copy the file in the folder labeled:
T:\"Copy the file in here to your Desktop weekly" to your Desktop and open that file from now on.

The linked file may take a little longer to open, but once the file is open you will no longer have to rely on the speed of the network to send you a form or report because they will be stored on your desktop.

If you happen to create your own query or make permanent changes to a query, that query has to get into my working version of the front end for the next update to the Front End of TTIMS.

At the moment, I think the easiest way to share a query with me is to right-click on your query's tab while in either Datasheet View or Design View and select SQL View.  Copy and email me the SQL text with the name or a screen capture of the query's name.
Show Just This Thread        Post Reply
Read Popup issue by Dorothy A @ 7/17/2017
Awesome!  THANKS
Show Just This Thread        Post Reply
Read Popup issue by Gregory C. S @ 7/15/2017
The question and Alex's tip was perfectly timed.  We just started getting the same popup on my dB that has been stable for 6 years without being split.  I think the cause was that I recently copied all of the objects into a newer-version blank database.  One of my recent 599CD lessons suggested I import all of the objects into a dB when Compact and Repair fails.  Today, I sneaked into work to get exclusive access.  I will try Richard's Importing suggestion, but I believe Alex's idea is best.  Then I intend to recombine the dB today because we do like being able to take a full copy of the dB with us when we travel to remote villages across Alaska. This forum just helped me.  Thanks go to the questioner and Alex.
Show Just This Thread        Post Reply
Read Popup issue by Dorothy A @ 7/15/2017
Thank you for your feedback. Just to clarify my understanding, when you say "fe on each user's machine" can the fe be located on a shared server that users can access on their own pc or do you mean something else?

Reply from Alex Hedley:

No, thats the same as the whole db, fe/be being on the server, the point of splitting it is so multiple people can use it at the same time.
Show Just This Thread        Post Reply
Read Popup issue by Dorothy A @ 7/10/2017
My database is producing a popup saying "You do not have exclusive access the the database at this time. If you continue to make changes, you might not be able to save changes."  I understand fully that this would appear if I were trying to make design changes, but I'm not.  It happens when clicking on any Command Button to launch a form or report from my Main Switchboard while other people are logged in, but we should be able to all work in it at the same time. Is there a limit to how many people can be logged in at one time? I click OK and it repeats the popup what seems like 10-12 times and then it lets me go about my business and everything seems to work just fine.

What could be causing this and how can I stop it?

Reply from Alex Hedley:

If you have multiple users you should really split the db and have the be on a shared server and a fe on each users machine.
Show Just This Thread        Post Reply

Collapse All Topics


Post Your Comments or Subscribe
    If you would like to be notified of new posts on this forum,
    just enter your email address below. It will be kept private.
If you just want to subscribe to get email updates when this forum 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 6+7:
  Notify me when the this forum 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:

3/23/2018Microsoft Access Developer 7
2/22/2018Microsoft Access Developer 6
2/22/2018Access Assistance Available
2/21/2018Putting Access Databases Online
2/18/2018Microsoft Access Developer 5
2/10/2018Microsoft Access Developer 4
2/1/2018Access Tip: Salary History
7/19/2017Access Developer 2 and 3 Released
7/19/2017Microsoft Access Developer 3
7/19/2017Microsoft Access Developer 2

Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
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