Begræns antallet af poster

No simple method of doing this is possible

You would need to do it in code, and it would be an idea to use an MDE version so that the code cant be tampered with.

Du skal nok overveje at lave begrænsningen i dit program og ikke i selve databasen.

Hvis brugeren har adgang til en database, så vil brugeren jo altid kunne tilføje ekstra poster mv, men hvis du så laver begrænsningen i dit program/webside eller hvad du nu laver af brugerinterface, så kan du begrænse det, så der altid kun hentes max 10 poster ud og der kun kan gemmes data hvis der er mindre end 10 poster i databasen.

/LAsse

Some thing like this could work.

Private Sub Form_BeforeInsert(Cancel As Integer)
If Me.Recordset.RecordCount = 5 Then
    MsgBox "Not Allowed im demo version"
    Cancel = True
End If

End Sub

thanks

But this would only happen if there are 5 records. What if the user entered 6 records where no. 6 would be typed directly in the database.

Should it not be if me.recordset.RecordCount > 4 then
ect....

/Lasse

Hi Lasse
Your right, there will always be a possibility that the uase goes directly into the tables but if the application was designed correctly then this could be stopped.