Conversion problem

  • Thread starter Thread starter Jam N. Butter
  • Start date Start date
J

Jam N. Butter

Recently converted an Access 97 to Access 2000 and now can't alter any
tables or queries. It says I don't have exclusive rights to do so. I've
check the rights for users and even the Admin has the modify radio button
grayed out. What can I do to change this? The conversion made some changes
that need to be corrected so everything will flow again.

James
 
Jam N. Butter said:
Recently converted an Access 97 to Access 2000 and now can't alter any
tables or queries. It says I don't have exclusive rights to do so.
Click to expand...

After A97 you must be the only user in the file if you want to make design
changes. Does anyone else have the file open?
 
New with 2000, you must have the mdb opened exclusively to modify any of the
design.

Open Access, File, Open, select your mdb and choose Open Exclusive in the
dropdown in the lower right.

You should split your database, and put the frontend on each user's
computer. You can then make design changes in your copy of the frontend,
and distribute the update to users once you're done.

For backend changes, you'll need to get exclusive access to make any
changes.
 
Back
Top