Access 97 would let me make design changes to a database while it was in use. Now we’ve converted to Access 2000 (and WIN2K) if I try to do this I get a message telling me I don’t have exclusive permission and I may not be able to save my changes. Sure enough, I can’t. Is this a new “feature”?
Oh and please don’t get on my back about bad practice etc. I know it is but we’re talking minor tweaks like adding an item to a combo box list (for example).
![]() |
Patch reliability is unclear, but widespread attacks make patching prudent. Go ahead and patch, but watch out for potential problems. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Can’t change a form if database is in use
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Can’t change a form if database is in use
- This topic has 7 replies, 4 voices, and was last updated 24 years, 2 months ago.
AuthorTopicWSJon Dean
AskWoody LoungerApril 9, 2001 at 8:32 pm #354846Viewing 2 reply threadsAuthorReplies-
WScharlotte
AskWoody LoungerApril 9, 2001 at 11:11 pm #522195Sorry to disappoint you, but you can’t do that in Access 2000, period end of story. Access 2000 does not permit design changes (and that includes your combobox example) unless the database is opened exclusive.
There are good reasons for it, so your only option is to change your modus operandi.
-
WSJon Dean
AskWoody Lounger -
WSDouglas Martin
AskWoody LoungerApril 10, 2001 at 9:04 pm #522344I’ve had intermittent problems with database corruption in Access 97 almost from day 1. After much grief and serious swearing at my computer I came to the realization that even minor changes to forms and reports while others are using the database (even if the others don’t even look at those forms or reports) is a major gamble. I’m assuming that that restriction was put in Access 2000 specifically to prevent that problem.
-
-
-
WScharlotte
AskWoody Lounger -
WSPhilJeary
AskWoody LoungerApril 18, 2001 at 12:12 pm #523210Hi Jon,
I’m not sure if this will help but by using a .MDE front end, the original .MDB front end is always free for editing. Therefore changes can be made and the new .MDE can be copied over the old without problem. This obviously doesn’t apply if, for some reason a .MDE cannot be used. -
WScharlotte
AskWoody Lounger -
WSPhilJeary
AskWoody Lounger
-
-
Viewing 2 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
The Simpsons Kills Off Marge In Shocking Season Finale Twist
by
Alex5723
3 minutes ago -
AnduinOS (Windows 11 look alike)
by
Alex5723
42 minutes ago -
Total Commander updates
by
Alex5723
54 minutes ago -
Have you checked your FICO score?
by
Susan Bradley
1 hour, 25 minutes ago -
Chrome ‘Scream to Unlock’ : Scream louder to get more time on Social Media
by
Alex5723
2 hours, 50 minutes ago -
Taskbar icon size
by
CWBillow
6 hours, 44 minutes ago -
Is it Local or is it Microsoft Account?
by
RetiredGeek
2 hours, 8 minutes ago -
Does Your State Reveal Who’s Been Hacked?
by
Nibbled To Death By Ducks
22 hours, 20 minutes ago -
A one-year extension to Windows 10 — almost free!
by
Susan Bradley
3 hours, 26 minutes ago -
Windows Configuration Update (KB5062324) – June 2025
by
Alex5723
9 hours, 43 minutes ago -
A federal judge sides with Anthropic in lawsuit over training AI
by
Alex5723
1 day, 3 hours ago -
Name of MS Word Formatting Feature
by
John Baum
16 hours ago -
InControl Failure?
by
Casey H
14 hours, 22 minutes ago -
Microsoft : Free 1 year support for Windows 10 after EOL
by
Alex5723
16 hours, 5 minutes ago -
MS-DEFCON 3: Businesses must tread carefully
by
Susan Bradley
7 hours, 48 minutes ago -
McLaren Health Care says data breach impacts 743,000 patients
by
Nibbled To Death By Ducks
2 days, 2 hours ago -
WhatsApp banned on House staffers’ devices
by
Alex5723
1 day, 21 hours ago -
Is your device eligible?
by
Susan Bradley
2 days, 5 hours ago -
Windows 11 Insider Preview build 26200.5661 released to DEV
by
joep517
2 days, 11 hours ago -
Windows 11 Insider Preview build 26120.4452 (24H2) released to BETA
by
joep517
2 days, 11 hours ago -
Hello Windows…My Problem is Windows Hello…
by
rdleib
2 days, 12 hours ago -
New Canon Printer Wants Data Sent
by
Win7and10
2 days, 12 hours ago -
I set up passkeys for my Microsoft account
by
Lance Whitney
2 hours, 14 minutes ago -
AI is for everyone
by
Peter Deegan
2 days, 12 hours ago -
Terabyte update 2025
by
Will Fastie
2 days, 6 hours ago -
Migrating from Windows 10 to Windows 11
by
Susan Bradley
13 hours, 50 minutes ago -
Lost sound after the upgrade to 24H2?
by
Susan Bradley
1 day, 6 hours ago -
How to move 10GB of data in C:\ProgramData\Package Cache ?
by
Alex5723
1 day, 15 hours ago -
Plugged in 24-7
by
CWBillow
2 days, 21 hours ago -
Netflix, Apple, BofA websites hijacked with fake help-desk numbers
by
Nibbled To Death By Ducks
4 days ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.