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

Opening database exclusively

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
If anyone has any experience or information on this problem, please
advise.

Thank you.

Nov 13 '05 #2

P: n/a
Split the database into 2 parts (Front End and Back End). Your application
(Front End) will contain all the queries, reports, forms, etc...but NOT
tables. Your tables will be LINKED to the Back End. This way you can make
as many changes to the Front End as often as you like without having to boot
your user out. The only time you will need to boot her out is if you are
making a structural change to the tables. Once your changes are done, just
copy your Front End to the users system and overwrite her file. Make sure
you link the data will a server name like \\MyServer\MyFolder\MyDB.mdb and
NOT c:\MyFolder\MyDB.mdb.

HTH
Paul

<ke*******@hotmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.