When i go to open my Access database from certain computers, i get multiple popup messages stating the same thing. They all say "You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later [Show Help >>] [OK] [Cancel]"
Now, when I open the db from different computers, I don't get the error on open, but if I try to open a form in Design Mode.
There is a program running that has "control" over the database. All this program does create new records in the main table, and creates a "data" table for the new record entered in the main table.
Is there a setting that Access has to open the most recent form or anything in design mode? Can that be changed? Has anyone ever encountered this error?
I thank you in advance for your time to look over my problem.
Thanks
9  7375  NeoPa 32,576
Recognized Expert Moderator MVP
This message comes up when the database is open anywhere (It can even be in a separate Access session on your own PC.) and an object is open in design view. It applies to forms; reports; some others but not to Tables & Queries I think.
Thanks NeoPa.
Is there any way to disable objects from opening in design mode on access/db startup?
NeoPa 32,576
Recognized Expert Moderator MVP
:confused:
I don't think that any objects will open automatically to design view on open.
The area to look at for automatically opening objects or running code is Tools / Startup... though.
OK. That's kinda funny.
On my 3 different computers, the file opens fine. When i try to go to design mode, then i get a problem.
However, one user on a laptop wants to open in the design mode. I tried 2 other users for the laptop, and no problem. I find it unusual that onlly one user wants to "open in design mode"
I'll try and look more into it.
NeoPa 32,576
Recognized Expert Moderator MVP
Do they understand what Design Mode is?
Do they understand what Design Mode is?
yes, because i'm the one opening everything. I'm testing a db that will be used by different people.
NeoPa 32,576
Recognized Expert Moderator MVP
I'm not sure that explains why they would have to know about design mode. Clearly you do, but they (users) would not generally be expected to go within a mile of design mode in a database.
I'm not sure that explains why they would have to know about design mode. Clearly you do, but they (users) would not generally be expected to go within a mile of design mode in a database.
yeah, sorry. i wrote that reply in the midst of doing other work. i thought i had more, obviously not.
yes, i know about design mode. yes, the users of the db will not need to know, nor should they ever go near, the design mode.
now, let me restate again what is going on. there is a program (hidden) that runs in the background of the "db server" i.e. the computer where the db is located. it basically has the db open, so data can be entered to the db. now the users can open the db via network connections to view different reports and forms based off of this information. while testing the db, i was able to open the db on several computers. i wasn't able to make any code/apperance changes to the db (due to the hidden program).
when i would go to design mode from my computer, (while the hidden program was running) i would get an error saying changes would'nt be saved. howeveer the db would open fine (no errors about saving issue). this was the cse in two other computers. however, when opening the db from one of our laptops, the no save error would come op on the db open, thus making the "user" click ok about 8 times (for the different forms/reports that might be changed)
my only guess is that on the laptop, the db seems to open in design mode. i was trying to figure out what settings may cause this.
 MMcCarthy 14,534
Recognized Expert Moderator MVP
Standard practice is that you wouldn't open a form from an operational database in design mode. This should always be done on a copy of the database which can then be uploaded as the operational database. You don't say if the database has a front and backend. This is one of the reasons why it is necessary. It means you can upload a new frontend without disturbing the data.
Mary
yeah, sorry. i wrote that reply in the midst of doing other work. i thought i had more, obviously not.
yes, i know about design mode. yes, the users of the db will not need to know, nor should they ever go near, the design mode.
now, let me restate again what is going on. there is a program (hidden) that runs in the background of the "db server" i.e. the computer where the db is located. it basically has the db open, so data can be entered to the db. now the users can open the db via network connections to view different reports and forms based off of this information. while testing the db, i was able to open the db on several computers. i wasn't able to make any code/apperance changes to the db (due to the hidden program).
when i would go to design mode from my computer, (while the hidden program was running) i would get an error saying changes would'nt be saved. howeveer the db would open fine (no errors about saving issue). this was the cse in two other computers. however, when opening the db from one of our laptops, the no save error would come op on the db open, thus making the "user" click ok about 8 times (for the different forms/reports that might be changed)
my only guess is that on the laptop, the db seems to open in design mode. i was trying to figure out what settings may cause this.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Mark |
last post by:
When the following VB code is executed (code from an aspx page), the
following error message is issued: "Microsoft Access can't open the
database because it is missing, or opened exclusively by another user. "
The Access database is not opened by another so I don't know why it is being
issued.
Any ideas?
VB Code
|
by: Chuck Van Den Corput |
last post by:
I have encountered a problem that I am hoping someone can shed some
light on.
I have a multi-user A97 app. All users have a personal front-end MDE
accessing a shared back-end.
There is no specific MDW file for the app as security rules are housed
within the app itself.
On a couple of occasions, different users have launched the app only
|
by: MyndPhlyp |
last post by:
I am about to completely lose what is left of my poor mynd! The historical
dissertation gets rather verbose, so I hope you can wade through it all. I
really need some help on this one or I'm looking at rewriting all my hard
work in something else (wasting probably a month or more).
(If you want to run and hide now, the error message is "The decimal field's
precision is too small to accept the numeric you attempted to add." I
haven't yet...
|
by: Wayne |
last post by:
Can someone please help with this problem. When referring to opening a
database in Exclusive mode the Access 2003 help says:
"Under Default open mode, do one of the following:
If you want others to be able to open the Microsoft Access database at
the same time you have it open, click Shared.
If you want sole access to the Access database when you have it open,
click Exclusive."
>From my experience and from what I have read on the...
|
by: JohnC |
last post by:
I have this exact same scenario. It is new and seems to be related to when
we installed Adobe 7.0 Standard/Professional.
We have an MDB on a LAN file server. Using Access 2K and Windows 2K. When
the application is opened by someone, it seems that if one of the Adobe 7.0
(Standard or Professional) users susequently open the application, they get
the error - "...You do not have exclusive permissions to the database.
Changes that you...
| | |
by: Andre Laplume via AccessMonster.com |
last post by:
I have inherited a bunch of dbs which are are shared among a small group in
my dept. We typically use the dbs to write queries to extract data, usually
dumping it into Excel. Most dbs originated in MsAccess 97 or prior and have
been converted to 2003. On occassion user 1 will open a db. When user 2
opens the db it will not let user 2 modify macros and what not. I can
understand this and realize we could split the db; it is not worth ...
|
by: Mark |
last post by:
When the following VB code is executed (code from an aspx page), the
following error message is issued: "Microsoft Access can't open the
database because it is missing, or opened exclusively by another user. "
The Access database is not opened by another so I don't know why it is being
issued.
Any ideas?
VB Code
|
by: CJJ |
last post by:
hi Folks,
I am opening my access database file (Access 2003) from a C#
application. The connection string specifies mode=Share Exclusive
The intent is that the application have exclusive access to the
database file. No other instance of MS Access or this particular C#
application (or any other app) should be able to open the access
database file concurrently.
|
by: pavankumarveera |
last post by:
how to unblock the CF
below error what was the solution.
GES: Potential blocker (pid=282) on resource CF-00000000-00000000;
enqueue info in file /exlibris/app/oracle/admin/meta4/bdump/meta4_arc0_22455.trc
Killing enqueue blocker (pid=282) on resource CF-00000000-00000000
by killing session 189.549GES: Potential blocker (pid=8833) on resource CF-00000000-00000000;
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
