Restrict Tables to One Row

[SteveF]

I have a couple of tables that I only want to enter one set of data into, the idea being that each time the new numbers replace the old ones. My tables are automatically creating a second row though, and if I tab beyond the end of my form when entering data I end up with a big mess.

How can I restrict my tables to just the one row?

All help appreciated.

 

[Banana]

There are no way to manage this at table level.

However, one approach would be to use a "Administrator form" where it query that table, and has properties "AllowAdditions" set to No, so new records can't be added to it.

If you also want to enforce this against end users trying to fix it, you can set up security in such way that locks up the table and they would only have right to use the form to modify the value.

I also should note that there is nothing wrong with creating a single "Constant table" to hold all values, rather having several one-row tables. You can always query for the value using the constant's name (e.g. "SELECT ConstantValue FROM tblConstants WHERE ConstantName="MyConstant";")

HTH.

 

[SteveF]

That got it straight off the bat, no additions. Thanks

 

[SteveF]

I got the 'no additions' bit so it all seems good now, thanks for help on this. This whole database experience has been a revelation to me, Access is a brilliant product and this forum has been amazingly helpful.