app locked against changes

D

David#

We have a Zccess file created in Access 97 - Has since been converted to
Access2000 - Changes are needed. Msg returned "You can't make changes...
This app created in an earlier version of ACCESS..." Are there any means
available to edit forms,structure, etc in this file?

Thanx - David
 
G

Gina Whipp

Sounds like the database was never 'converted' to Access 2000, just opened
in Access 2000. You need to convert it, to do this, go to Tools...,
Database Utilities... and select Convert.

IMPORTANT NOTE: Once you do this you can no longer share or open in Access
2000 (which may be why it was converted in the first place.)
 
6

'69 Camaro

Hi, David.
Access2000 - Changes are needed. Msg returned "You can't make changes...
This app created in an earlier version of ACCESS..."
Click to expand...

It was opened in Access 2000 and although you may no longer be receiving the
message to convert the database to Access 2000, it wasn't converted. This
can happen when one logs in as a user other than the owner of the database
when User-level security has been applied, and then converts the database to
a more recent version of Access.

In any event, log in as the owner of the database and launch Access without
a database file selected. (You may need to join the secure workgroup first
if User-level security has been applied.) Select the Tools -> Database
Utilities menu and select "Convert Database" and select "To Access 2000 File
Format..." Browse to this database and select the name of this MDB file,
then select the "Convert button." When complete, you should be able to make
changes to the database.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Top