Making design changes in a shared database

[Tessadear]

I have database that is shared. Sometimes I need to make design changes to the database but I access tells me that because I do not have exclusive use of the database I can't make design changes. If I try to open the database in exclusive mode it tells me I can't do tha because other users are using the database. What I need to be able to do is to be able to disconnect other uses from the database while I make design changes. (without shutting down my server)

Is there a way that I can forcefully disconnect users from the shared database?

 

[randy700]

One method is to have a production version and a design version of the database. Make all changes to the design version, then import them when ready.


Randy

 

[Tessadear]

What about disconnecting the user from the share

 

[JoeAtWork]

Have you split the database into frontend/backend versions? This would be the first step.