473,500 Members | 1,955 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Making design changes while not having exclusive access

17 New Member
Is there a way to make design changes to an access database using 2003 while not having exclusive access?
Jun 22 '07 #1
3 1770
MMcCarthy
14,534 Recognized Expert Moderator MVP
Is there a way to make design changes to an access database using 2003 while not having exclusive access?
What do you mean by not having exclusive access? If you mean you don't have security permission to do so then no, that's the whole point.
Jun 22 '07 #2
jjstevens
17 New Member
What do you mean by not having exclusive access? If you mean you don't have security permission to do so then no, that's the whole point.

No I mean, I have 17 users in three different states using the database. If any one is in the database besides me I can not make design changes. The error message says you do not have exclusive access. I am not talking about security rights, I am the administrator.
Jun 22 '07 #3
MMcCarthy
14,534 Recognized Expert Moderator MVP
No I mean, I have 17 users in three different states using the database. If any one is in the database besides me I can not make design changes. The error message says you do not have exclusive access. I am not talking about security rights, I am the administrator.
Sorry, I misunderstood the question.

Normally you would make your changes on a copy of the database which is why using a frontend/backend system is usually the best way to go.

You can make your changes to a copy of the frontend and simply replace it without affecting the data which is located in the backend.

You will have to get all other users to log off the database while you make design changes.
Jun 22 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

6
4244
by: Mike Wiseley | last post by:
We recently converted our department wide shared Access97 database to Access2K. We used to be able to open various reports in design mode and make changes to the design (or create new reports) even...
9
2000
by: Mike McGee | last post by:
I am new to database apps, but I am making a db with access 2002. Here is what I have and what I would like for it to do. tblCustomers = holds customer info (Name, Address, City, State, Zip,...
10
1847
by: Jeff Grills | last post by:
I am an experienced C++ programmer with over 12 years of development, and I think I know C++ quite well. I'm changing jobs at the moment, and I have about a month between leaving my last job and...
2
1839
by: Matthew Hood | last post by:
My company has expressed a desire to convert an existing MS Access application to a full VB.NET application. My experience is with VB6 so I want to ask a few questions and get some input on the...
3
1849
by: reageer | last post by:
Hi all, I have a design question: I have a bunch of users (name, address, zip, etc.). They are assigned a card with a specific id. The only thing unique is this card id, or probably the...
11
3161
by: Hari Sekhon | last post by:
I have written a script and I would like to ensure that the script is never run more than once at any given time. What is the best way of testing and exiting if there is another version of this...
17
4824
by: roN | last post by:
Hi, I'm creating a Website with divs and i do have some troubles, to make it looking the same way in Firefox and IE (tested with IE7). I checked it with the e3c validator and it says: " This...
2
1269
by: CoopEng | last post by:
Hey all, I've been pouring through hundreds of forums recently and finally decided that I should get in on the action. I am trying to update some forms and reports, also some minor back end...
2
9813
by: existential.philosophy | last post by:
This is a new problem for me: I have some queries that open very slowly in design view. My benchmark query takes about 20 minutes to open in design view. That same query takes about 20 minutes...
0
7018
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7182
Oralloy
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,...
0
7232
jinu1996
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...
0
7397
tracyyun
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...
0
5490
agi2029
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,...
0
4611
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...
0
3110
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...
0
3106
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1430
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 ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.