Back end databases?

[paulreed]

I have a database held on a intranet which details staff training sessions.
Is there a way in which other departments can access the *.mdb file as read-only, and cannot amend any of the data, just manipulate and statistically calculate its data.

 

[paulreed]

Thanks Pat, I didn't realise the solution would be this complicated!

 

[Crilen007]

Uhm... couldnt you just set their permissions to the folder to read only?

 

[paulreed]

I have checked with our corporate IT manager (who knows nothing about Access!), and am able to set different permissions to individual users, for example; all my department has full read/write access. but they could set read-only access for the 'stats' dept, and no access to everyone else.
Would the 'stats' dept be able to open the data read-only, without corrupting the data source?