database login issues

V

vandy

Hi All,

I have a database that i created and now is being used by 6 users.

I ran the security wizard and have assigned 2 users full data user access
The rest 4 have read only access.

I have set administrator rights for me to uhable to bring about any changes
if required.

The problem now is when i enter with my login and try to enter the screen
design it prompts saying you do not have exclusive rights and the changes
will not be saved since other users are using the system. I am working on
Access 2003. how to work around this problem. I need to be able to make
changes when users are using the system simultaneously. Any help will be much
appreciated.
thanks in advance.
 
R

Rick Brandt

vandy said:
Hi All,

I have a database that i created and now is being used by 6 users.

I ran the security wizard and have assigned 2 users full data user
access The rest 4 have read only access.

I have set administrator rights for me to uhable to bring about any
changes if required.

The problem now is when i enter with my login and try to enter the
screen design it prompts saying you do not have exclusive rights and
the changes will not be saved since other users are using the system.
I am working on Access 2003. how to work around this problem. I need
to be able to make changes when users are using the system
simultaneously. Any help will be much appreciated.
thanks in advance.
Click to expand...

You cannot make design changes while users are in the file. Not since Access
97.

Do what all serious developers do and split your app into a shared back end
and separate front ends that you give each user. You can then have a
development copy for yourself that you work on.
 
V

vandy

Hi Rick,

Thanks for your response. Access 2007 supports simultaneous data change is
that right.

Is there anyway I can work around this without splitting my database in 2003.

I did not mean to repeat my request just making sure, we have 2007 software
which i can switch to if required.
 
R

Rick Brandt

vandy said:
Hi Rick,

Thanks for your response. Access 2007 supports simultaneous data
change is that right.
Click to expand...

All versions support simultaneous *data* changes (as long as its not the same
record). But you indicated that you wanted to change the *Design* of objects.
Access 97 is the last version that allowed that.
Is there anyway I can work around this without splitting my database
in 2003.
Click to expand...

Not if your intent is to make design changes.
I did not mean to repeat my request just making sure, we have 2007
software which i can switch to if required.
Click to expand...

That will not help since Access 2007 does not allow this either.
 
K

Keith Wilby

Rick Brandt said:
That will not help since Access 2007 does not allow this either.
Click to expand...

Think about it logically vandy - you can't expect to drive your car whilst
it's being worked on by a mechanic, so you can't expect people to use your
user interface whilst you're changing it.

Keith.
www.keithwilby.com
 
Top