One record in DB

  • Thread starter Thread starter Jorge
  • Start date Start date
J

Jorge

Hello

I have a DB that I would like only one record in, no more.
This DB/Table will function as just a table with prices.

When an individual selects what transaction it is just going lookup into
this DB and pull information.
I don't want someone inadvertently stumbling into this table and adding
additional prices etc.

Thanx in advance.
George
 
Jorge said:
Hello

I have a DB that I would like only one record in, no more.
This DB/Table will function as just a table with prices.

When an individual selects what transaction it is just going lookup into
this DB and pull information.
I don't want someone inadvertently stumbling into this table and adding
additional prices etc.
Click to expand...

Use a numeric Primary Key field with a validation rule of =1 and have your one
row use the value 1 in that field. Any attempt to add more records with a value
of 1 will be rejected because the PK cannot have duplicates and any attempt to
use a different value will violate the validation rule.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy table with records from one DB to other DB 2
Record insert/delete anomaly 0
On db Exit 4
Access Automatically Send a notification email once a record is added 0
Import table from one db into another 5
Access Db remote access 2
Migrate updates from developement to production DB 2
how to display data from Table 1 ("one") in Form for Table 2 ("man 4

Back
Top