By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,618 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Making design changes while not having exclusive access

P: 17
Is there a way to make design changes to an access database using 2003 while not having exclusive access?
Jun 22 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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

P: 17
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
Expert Mod 10K+
P: 14,534
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.