låsning af tabel

... som består af ca 20 forskellige. Forskellige hvad?

As far as I know you cant. You can get Access to generate an error if two people try editing the same record but not becuase to people want to see the same record.

In the tools menu choose Option and the select the advanced tab.
Here you can see/cahnge the Default Record locking

sorry min fejl.
Databasen bestpr af ca 20 forskellige tabeller og det er der låsen gerne skulle foretages.

as far as I know it isnt possible with Access own security methods.
And if you want to work directly in tables then I very much doubt you can make your own security method. If you work through form then you maybe can.


An idea would be to have a table which contains information such as
User name, form name and a yes/no field indicating if that user is using that table.

When a user want to open a form with on eor more underlaying tables a check is made to see if any other user has that form open. If they do then a message is displayed. If not the yes no field is set to Yes(true).
When the form is closed the field gets set to No(false)

That was just an idea

status?

stusus is that we dropped the locking of tabels and uses an old proven method we call the datamonkey. The person which uses the data take the toy datamonkey and then the others know who uses the database. This was the only way we could make it work

can you explain waht your datamonkey is, maybe a field in the record you set to on/off?
If your finished with th equestion you can close either by palcing an asnwer yourselef and accepting or accepting other answers.

The datamonkey is a stuffed toy we use instead of a digital lock

that tells m ea lot :o)

Thanks anyway

we use a stuffed toy formed as a monkey to indicate which user have the database. The user who wants the database go to the physical place where the monkey and place it on the users place

are you saying that you have a physical toy to do this? Well as they say "Keep it simple" :o)

You are right this was the best and simplest way we could do it. And yes keep it simple