settings page and disallowing new records

[Mark Reed]

I would like to create a settings page for my application.

This would be a layout where a user would set global fields such as:

COmpany Name

COmpany website

Thier Name

ect..

I have a settings table, and the fields inside are global - I have a layout setup and all is working great.

The problem I have is that a user can create new records which I need to not allow.

I plan on creating this app as a runtime and putting it out to a few different users - each running it for thier own purpose.

I need to find a way to make the settings layout only allow one record and the updating of the fields for that record. New records need to be disabled.

I am not sure how to do this. I thought about the user security, but I have never messed with it, and I am also not sure how that would work with a runtime since I do not want users to have to log in when using the app each time.

Anyone that has done something similar and is willing to share some tips, advice, or approaches, I would appreciate it.

[mr_vodka]

If they are truely global fields then it doesnt really matter how many records they create really.

However, if you still do not want them to create more than one record, turn off access to create records in that table. Then create a script that creates a record if there are no records in that table, otherwise dont create. Run this script with full access privileges.