Modifying a secure database

  • Thread starter Thread starter Christopher Johnson
  • Start date Start date
C

Christopher Johnson

I have a secure database that others use through a
network. I want to be able to make changes/modify this
database throughout the day, but I can't save changes if
someone else is logged on. Access says I don't have
exclusive rights. Is there a way to do this?
Thanks
Chris Johnson
 
Is there a way to do something that Access explicitly says can not be done?

Probably not :-)

It really is not sensible to change the design of tables, forms, reports &
modules while other people are currently in & using the database. This is
doubtless why msoft stopped people doing it. The proper way to go, is to
make your changes to a development copy of the database - test them there,
against a seperate back-end (data) database - then install them at a time
when no-one else is on the system. Any other approach, is asking for
problems.

HTH,
TC
 
Back
Top