limiting number of records in a table

#1

I have a table that is used to store configuration information,and it should
have only one record in it. I would like to protect it against having other
records added. I tried adding an autonumber field and limiting the value of
the field to 1, but I didn't like the result. It does prevent records being
added but is very awkward and inconvenient for a user if they try to add a
nother record. I would prefer to make it virtuallly impossible for a user
even to attempt to add a record, but still allow editing of values in the
existing record. Any suggestions on how this could be achieved?

#2

"Tim Blanchard" <toolmantim (AT) SPAMFIGHTERshaw (DOT) ca> wrote

Quote:

I have a table that is used to store configuration information,and it
should
have only one record in it. I would like to protect it against having
other
records added. I tried adding an autonumber field and limiting the value
of
the field to 1, but I didn't like the result. It does prevent records
being
added but is very awkward and inconvenient for a user if they try to add a
nother record. I would prefer to make it virtuallly impossible for a user
even to attempt to add a record, but still allow editing of values in the
existing record. Any suggestions on how this could be achieved?

Never mind, I found the answer

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

limiting number of records in a table

comp.database.ms-access comp.database.ms-access

limiting number of records in a table - 09-12-2003 , 09:32 PM

Re: limiting number of records in a table - 09-14-2003 , 01:33 AM