Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Read-only Database Access
- Thread starter rnooraei
- Start date
Access and security usually leads to some sort of concession.
Is the backend located on the network? Can you have people with write permission to the database log in with a special workgroup (join it through access or use a shortcut)? Is it o.k. for readers to be able to delete the database?
Do readers and writers need simulatneous access to the file?
Is the backend located on the network? Can you have people with write permission to the database log in with a special workgroup (join it through access or use a shortcut)? Is it o.k. for readers to be able to delete the database?
Do readers and writers need simulatneous access to the file?
- Thread starter
- #3
are you familiar with access work group security?
it's not particularly brilliant, but it will allow you to set up users, groups, and then set specific permissions like read/write/modify design... against tables/forms/reports for those users or groups.
--------------------
Procrastinate Now!
it's not particularly brilliant, but it will allow you to set up users, groups, and then set specific permissions like read/write/modify design... against tables/forms/reports for those users or groups.
--------------------
Procrastinate Now!
- Thread starter
- #5
it's quite easy really, all gui driven.
basically, a new file with a .mdw extension is created, and on each computer you set the access default work group security file to use this new file.
In this instance, you would put the .mdw file on the network, and just point everyone to that.
you should be able to google or F1 for everything you need to know...
--------------------
Procrastinate Now!
basically, a new file with a .mdw extension is created, and on each computer you set the access default work group security file to use this new file.
In this instance, you would put the .mdw file on the network, and just point everyone to that.
you should be able to google or F1 for everything you need to know...
--------------------
Procrastinate Now!
I was getting to what Crowley16 is saying...
But if you are the only one making changes I would not publish the workgroup. Instead I would give the admin user (which is common to all workgroups) read permissions only.
Then only you have to worry about the workgroup. This is particularly useful if it is being read by a program that does not support workgroups (I don't know about Crystal).
To create a workgroup go to Tools, security and workgroup administrator and hit create. You will later want to either join it or use a command line switch to open access with it. This is just a nudge in the right direction like Crowley16 said.
But if you are the only one making changes I would not publish the workgroup. Instead I would give the admin user (which is common to all workgroups) read permissions only.
Then only you have to worry about the workgroup. This is particularly useful if it is being read by a program that does not support workgroups (I don't know about Crystal).
To create a workgroup go to Tools, security and workgroup administrator and hit create. You will later want to either join it or use a command line switch to open access with it. This is just a nudge in the right direction like Crowley16 said.
ZmrAbdulla
Technical User
>>if you have any instruction to do that. I really appreciated.
________________________________________________________
Zameer Abdulla
Help to find Missing people
________________________________________________________
Zameer Abdulla
Help to find Missing people
- Status
Similar threads
