exclusive access

[Guest]

I am working on a database (one I didn't create) and am trying to create new
reports. When I try to save the report, I get an error message telling me I
don't have exclusive access to the file and can't save design or object
changes. My report is accessing a table being used by other people. I am
going to be the one maintaing this db - how can I change this setup? I'm not
looking to redesign a form or table while someone is in it, but need to be
able to do new reports. I checked and the db is set to be in shared mode and
no record locking.

Thanks!

 

[Tom Ellison]

Dear Lori:

First, it would be good to make your changes in a private copy of the
database, not the copy others are using. Copy it somewhere, go to work, and
don't distribute it till it is thoroughly tested.

Next, find out what "model" of distribution is being employed. Is the
database split (separate front- and back-ends? Is the front end on each
workstation? Where is the back end server? You're going to need this
information when you go to distribute your changes.

This is just the barest of outlines. Look for a book on the subject if your
job is going to be to do this, or read everything online you can find.

Tom Ellison

 

[Guest]

I am not an expert, but try this. In access click open when the open
dialogue box appears highlight the file and on the 'open' button click the
little arrow button and click 'open exclusively'. This may work.

 

[Guest]

Thanks for the advice Tom. I think it's a good idea to make my changes in
another copy of the db.