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

How to edit Production DB

P: n/a
I have a Access 2000 DB Running on the Shared Network Drive.
I would like to make changes to that DB. When I DOUBLE-CLICK on that,
it open up the DB and when I change my Query... I CANNOT SAVE the Query
I changed...

How can I change....? Infact the SAVE Button (floppy disk) is grayed
out.

My friend was telling you should OPEN it by HOLDING the CONTROL or
SHIFT Key and then DOUBLE CLICK.... but it still DOES NOT WORK.

Any hints?

HARI OM

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


P: n/a
Holding down a key while opening the database probably won't help in
this case. Access probably thinks you're not the only one in the
database (You don't have "exclusive" access _within_ Access).

I assume you have _full_ control of the MDB in the directory, and that
the file isn't a MDE, right?

Nov 13 '05 #2

P: n/a
Thanks Chuck.

The File is esupport.mdb and NOT MDE... I have the file in my C:/ and
do have FULL ACCESS to this Directory.

How should I ensure EXCLUSIVE Rights withing Access...?
I tried playing with Tools--> Option--> Advanced---> Exclusive... but
still in VAIN....

Any other hints?

HARI OM

Nov 13 '05 #3

P: n/a
"HARI OM" wrote
How should I ensure EXCLUSIVE
Rights withing Access...? I tried playing
with Tools--> Option--> Advanced--->
Exclusive... but still in VAIN....


Make certain that no other users are logged in.

Make certain that there is not an .LDB file of the same name as your
database (a possible corruption issue). If there is, delete/erase it. It
indicates the current users and sometimes is "corrupted" so that there
always seems to be a user.

Open Access directly (don't double-click the database), look for the
checkbox, and check "Exclusive Use".

Larry Linson
Microsoft Access MVP
Nov 13 '05 #4

P: n/a
THANKS Larry....

NO ONE else is using the Database at the same time.... I copied the DB
and moved to C:/ so that I can only have access to it... I then tried
to change it to EXCLUSIVE MODE... but still I CANT CHANGE..... Even the
NEW Query Button (like save-floppy icon) is GRAYED out...

Can any one please help me out on this?

THANKS a BILLIONS....!

HARI OM

Nov 13 '05 #5

P: n/a
Assuming it is MDE File... how can I make changes... and convert it
back to MDB

Nov 13 '05 #6

P: n/a
You cant you should have kept a copy as a mdb as well

"HARI OM" <ha*****@hotmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
Assuming it is MDE File... how can I make changes... and convert it
back to MDB

Nov 13 '05 #7

P: n/a
Hmmm....

Check the "Updatable" property of the database:
Open up the VBA editor, and in the Immediate window type in:
Debug.Print CurrentDb.Properties("Updatable")

If it's "False", you can't make changes to the database.

HARI OM wrote:
Thanks Chuck.
The File is esupport.mdb and NOT MDE... I have the file in my C:/ and
do have FULL ACCESS to this Directory.
How should I ensure EXCLUSIVE Rights withing Access...?
I tried playing with Tools--> Option--> Advanced---> Exclusive... but
still in VAIN....
Any other hints?
HARI OM


Nov 13 '05 #8

P: n/a


HARI OM wrote:
Assuming it is MDE File... how can I make changes... and convert it
back to MDB


You might want to try something called mde2mdb2k written by Krzysztof
Naworyta. I haven't tried it yet.

http://www.access.vis.pl/naworyta/mde2mdbv.html

James A. Fortune

Nov 13 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.