How to edit Production DB

[HARI OM]

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

[Chuck Grimsby]

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?

[HARI OM]

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

[Larry Linson]

"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

[HARI OM]

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

[HARI OM]

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

[Ian Davies]

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

[Chuck Grimsby]

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

[jimfortune]

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