Lock Table

[aprentice]

I want to lock a table to disallow further records.
I want to have only one record (I would have created this rec by myself) to store initial conditions and infos such Username/company etc.
Any ideas?
I'm also interesting in other solutions than locking a table if sucj a thing is not possible or nt functional.

Tnx in advance

 

[aprentice]

If you use an autonumber or long integer pk, you can add a validation rule that will allow only a single record.

= 1

A new problem arises.
I want to use the value of a field of this single record as a criteria in a query.
This query is based in more than one tables.
As it is obvious I get an error message saying that no unique value could be specified, I suppose because this table (InitialConditions) is not related to any as it should be.
Any suggestions?
As I said I'm also interesting in other ways of storing initial conditions and referring to them later in a query.