limiting a table to one record?

[Mark Reed]

How can I limit the number of records allowed in a table?

I have a preferences table and I only want one record in that table - the record that contains the preference field entries.

There is no need for additional records, and I would like to limit it to where if a user tries to create another record it will not allow them and instructs them on setting the preferences.

I cannot use account name or login name security since this will be a runtime file distributed to a few different folks.

Any idea or examples of handling this?

[Raybaudi]

Custom menus ?

[Fitch]

I don't see why you can't use security to turn off create and delete for that one table.

You could also use custom menus to take over the New Record and Duplicate commands, or get rid of them altogether.

[Vaughan]

If the record level access privileges for that table are set to not allow create or delete, the new and delete record commands won't work even of the user invokes them.

Be aware, however, that if a clone of the database is make the table will be empty: you might want to put a check in the startup script for this and take appropriate action. That action could be to make the new record and set default values, ot to just alert the user that there is a problem.