Update Table by only one User

[rhernand]

I have a split DB accessed and updated by several Users. How can I limit the update of one table to only one User, administrator if you will.

 

[gold007eye]

1 option is to use AccessDB Security; you could then put persmissions on that table allowing only those logged in as "Administrator" to be able to update the database.

 

[rhernand]

Thanks

I will give it a try

 

[Pat Hartman]

When you implement Access workgroup security, it is imperative that you read the security FAQ and follow its directions EXACTLY. Any deviation could leave you locked out of the database or leave the database unsecured even though it seems to be secured on your computer. http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp#_Toc493299666