Help on design issue please, read only, sharable table...

[Blackshark]

I would like to have an Access table of data, that anyone can access on a read only basis. Also though, I want it to be updatable by an administrator at any time.

So a few questions:

1. Is it possible to make a table read only? (ie so that when people create a database they can 'link' in to the table)

2. The table will need to be upadted on an ongoing basis by a single person. Is there a way this can be done with the possibility of people viewing the table?


I work for a large business and it would seem sensible to have a difinitive 'employee tree' describing each employee and who they work for. At teh moment we have 100+ seperate user created databases being updated as and when and I am certain that 99% of them are not up to date.

I considered maybe having a main table and copy that people can link. I could then write some code to wipe and copy from the Main to the Copy every evening.

Any thoughts gratefully received.

Thanks Tim

 

[RickSpr]

The security installed with Access can give you the control you need. Warning: Be very careful to read and completely understand the help file topics related to security and permissions, before you begin to implement Access security. Make certain to follow the instructions to the letter, especially if you're using Access 97. Many, many people have come here asking for help after discovering that their "secured" databases were actually wide open. It's much easier to get it right in the first place than it is to fix it after setting it up wrong.

Access security is intricate, but it can be done well, and in such a large organization you really need it. If there's anything you don't quite understand from the help file, feel free to come to Tek-Tips for explanation.

Good luck! Rick Sprague

 

[Blackshark]

Thanks Rick.

Expect a few questions later half of next week, unless by chance it goes swimmingly well in which case I might right a FAQ!!!

Regards Tim

PS Yes, I'm expecting the first as well !->