Share database read-only

C

Casa

Hi there;

I have a database (Access 2003). I want to share it over my network to my 3
co-workers. I want to have it read-only. I also want to make a front-end so
that they can easily query data and export it to excel (is querying and
exporting data allowed in a read-only environment? Also, can I make my front
end actually do these functions?).
I've heard about splitting databases, but I'm not sure if this is what I
should do (in my circumstances). I want to do this properly. What should I
do?

Casa
 
R

Rick Brandt

Casa said:
Hi there;

I have a database (Access 2003). I want to share it over my network
to my 3 co-workers. I want to have it read-only. I also want to
make a front-end so that they can easily query data and export it to
excel (is querying and exporting data allowed in a read-only
environment? Also, can I make my front end actually do these
functions?).
I've heard about splitting databases, but I'm not sure if this is
what I should do (in my circumstances). I want to do this properly.
What should I do?

Casa
Click to expand...

You can use network permissions to make a databse read only, but only if you
want ALL users to have read only access. The reason is that once a read only
user opens the file then anyone else who opens the file afterwards will be
restricted to read only access since no LDB file was created. If that is
acceptable, then what you are describing is very doable.

It is better to split and give each user their own local front end file, but
this is less of a concern in a read only situation. Your users will not be able
to make queries in a monolithic read only file though so if you want the data to
be read only and still allow the users to create queries then you pretty much
have to split the app. In that case only the back end file is read only and the
local files are not.
 
C

Casa

I guess I'll have to split the database. I want people to be able to make
queries but not alter the original data. I need to read up on how to do
this. Thanks for your help!
 
Top