How do you lock design view from users?

Kostika,

Convert your .mdb to .mde (Tools Database Utilities Make MDE file). The
..mde will have the full functionality of the .mdb but will not accept any
design changes.
Word of caustion: be sure to store the original .mdb securely so you can use
it to make changes if required, you won't be able to do it in the .mde!
It also helps to split your database into FE/BE (Tools Database Utilities
Database Splitter) and convert the FE to .mde, so when you then make
changes in your .mdb and make a new .mde you won't have to worry about the
data being out of sync.

HTH,
Nikos

"Kostika" wrote in message
om...
How do you lock design view from users?

Using Access 2000. Very basic DB. But can't have the users modifying the
design.

Thanks

I should have started by saying:

If it's a multi-user database, the first thing you need to do is split it to
FE/BE and distribute a copy of the FE to each user, or you are in for
corruptions!

Nikos

"Kostika" wrote in message
om...
How do you lock design view from users?

Using Access 2000. Very basic DB. But can't have the users modifying the
design.

Thanks