I share a database on the network with another user. When she has it
open I am unable to make design changes to tables, forms and reports or
create new ones. This being most of my work, it makes it hard for me to
find time into it "exclusively" without having to request her to close
it every time I need to work with it. Another recent work-around I have
adopted is making a copy of it on my C drive and creating the reports
etc. on it, then importing those objects into the database when she has
gone home. My repeated e-mails to request closure when not in use have
had no effect.
I am looking for a way so that any time I open it up it opens
exclusively for me and she may have read-only access to it.
Any leads?
Thanks
Kevin