468,538 Members | 1,759 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,538 developers. It's quick & easy.

Making design changes while not having exclusive access

Is there a way to make design changes to an access database using 2003 while not having exclusive access?
Jun 22 '07 #1
3 1463
MMcCarthy
14,534 Expert Mod 8TB
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
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 Expert Mod 8TB
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

Post your reply

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

Similar topics

10 posts views Thread by Jeff Grills | last post: by
2 posts views Thread by Matthew Hood | last post: by
3 posts views Thread by reageer | last post: by
11 posts views Thread by Hari Sekhon | last post: by
17 posts views Thread by roN | last post: by
2 posts views Thread by existential.philosophy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.