Server / Security Issues

[gettingsmarter]

I wrote a main database for the department I work in, and also wrote a "mini"
database for each Rep. in the department so they can input records that
pertain to them. The main database is stored on one server, and the Rep's
databases are stored on a different server. The tables in the Rep's databases
are linked to the tables in the main database. They cannot access their
databases because they do not have access (thru our IT dept.) to the server
where the main database is stored. There is information stored in this
database that can not be viewed by everyone in the department. I feel my only
option is to move the main database to the drive that everyone has access to.
Is this true? If so, then I would have to set security levels within the main
database. I am not familiar with setting any security levels within Access.
Where, and how would be the best way to abtain this information to get the
quickest lesson. HELP!!

 

[Keith Wilby]

I wrote a main database for the department I work in, and also wrote a
"mini"
database for each Rep. in the department so they can input records that
pertain to them. The main database is stored on one server, and the Rep's
databases are stored on a different server. The tables in the Rep's
databases
are linked to the tables in the main database. They cannot access their
databases because they do not have access (thru our IT dept.) to the
server
where the main database is stored. There is information stored in this
database that can not be viewed by everyone in the department. I feel my
only
option is to move the main database to the drive that everyone has access
to.
Is this true? If so, then I would have to set security levels within the
main
database. I am not familiar with setting any security levels within
Access.
Where, and how would be the best way to abtain this information to get the
quickest lesson. HELP!!

Yes the file containing the tables will have to be in an area that all users
can see for obvious reasons. There is no quick lesson in user-level
security I'm afraid. It is a complex topic with a steep learning curve so
you may want to explore the possibility of controlling security at file
level. If this is a non-starter and you need to learn ULS then study the
FAQ from MS. There's a link to it on my web site along with a working
example.

Quick tip - don't store users' GUI files on a server, rather give each of
them their own local copy.

HTH - Keith.
www.keithwilby.com

 

[linnext]

thx

Yes the file containing the tables will have to be in an area that all users
can see for obvious reasons. There is no quick lesson in user-level
security I'm afraid. It is a complex topic with a steep learning curve so
you may want to explore the possibility of controlling security at file
level. If this is a non-starter and you need to learn ULS then study the
FAQ from MS. There's a link to it on my web site along with a working
example.

Quick tip - don't store users' GUI files on a server, rather give each of
them their own local copy.

HTH - Keith.
www.keithwilby.com