Re: Date filed in table

You might want to check out our AutoArchive product which can do most of what you need in a slightly different way. It can track changes at a very granular level and archive the data as it was before the change, mark the change with the user who did it, etc. It is also capable of tracking deletes if you set it up for that. It doesn't directly STOP the changes but by providing an audit trail it lets you see what is happening and how. You can find it on our product page (Link in my signature)

I would strongly encourage you to reconsider autoincrement keys if that is what you are using ai for. Check out the database basics paper on our paradox resources page for more on why but they are particularly problematic if you are linking any tables.

You can control some deletes, etc. from paradox based on passwords and permissions you set but they can be broken and it can get complicated to manage multiple levels across multiple tables and various users, permissions and systems. You may also want ot check out our Security Guard product to help you there. You can learn something about permissions and passwording from the documentation (free to download) anyway and you might find that helpful.

HTH

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and non-profits since 1982

spyregyre@xxxxxxxxx wrote:
Thanks to everyone who helped me on my last question. I've got the
table up and running and have even been able to get file numbers to
match up. The auto increment is working fine for now.

Now I have an issue. Multiple people will have access to this database
and I want to avoid unintentional and intentional damage. I am working
on the auxiliary password to prevent deletion of records.

When an entry in the table is created I would like a date stamp that
cannot be edited at all or only by the highest level user. I would
also like a field showing the last time the table entry was edited.

eventually, I would like to show the last 10 or so users who accessed
the table whether or not it was edited.

if this is getting into the "pay me for my services" realm let me
know.

thanks again.

j.


.

Relevant Pages

  • Re: Thinking outside the box on file systems
    ... multiple mailing lists now and I've had enough. ... *cannot* allow the entity who specifies permissions check semantics on ... In the Linux world there are two ways to proceed: ... difficulty winning people over that security modules that do depend on ...
    (Linux-Kernel)
  • Re: Problem managing accounts in protected groups
    ... As I understand it you have a collection of users in some group which are allowed to reset passwords of domain admin accounts? ... The permissions for this group have been applied to OU B and it ... or passwords for the users in the protected groups. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Clients not able to login to Domain
    ... Passwords are supposed to remained synched between AD and Novell, ... it may be a "permissions" issue. ... >> You say Not able to login, but then your error is not able to map? ...
    (microsoft.public.windows.server.sbs)
  • Re: Closed LAN: want WORKGROUP to share w/o passwords
    ... the passwords and permissions? ... I'm lost in PERMISSIONS and PASSWORD "hell"! ... XP Pro file sharing in a workgroup doesn't use permissions ... Please post any reply as a follow-up message in the news group ...
    (microsoft.public.windowsxp.network_web)
  • Re: Delegation - Password Reset - Access Denied
    ... You attempt to see if the permissions are being applied as you expected. ... Open up a user's properties and select the security tab, click on advanced, ... those groups and reset passwords when needed. ...
    (microsoft.public.windows.server.active_directory)