I would like some advice please

[scubadiver]

I am not too sure where to ask this so I have opted for here.

At the moment I have one database for holding employee records. I am
currently re-developing it but it has been suggested to me by one manager
that each department has its own database.

To prevent unauthorised records, each department would have its own password.

Can I get around this password protection to compile the records into a
central database?

If so, I would like a run through on how to set up an administrator
password. I can't remember.

Cheers.

 

[S Panja]

A single table with a field for identifying departments is preferable. That
field value can be used to restrict data access.
--
********* http://panjas.org
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?