Can you lock Access files?

NeVeR

Can you lock microsoft access files so that only you can edit them? but others can view it.

Karoma

Tools -> security ->
-> User and Group Permissions :: I would have thought?

Would it not be better to create a presentation-only layer for them i.e. ASP page,etc.?

NeVeR

i'll try that and see.

Does the program know what computer made the file ? and set the promission?

Karoma

Explain what you're trying to achieve.

NeVeR

well i have a master file with all our company's dealers listed with names/address/phone number/ etc all there account info.. No this file will be placed on the company server for all the workers to view.. but we dont want anyone changing any info on it apart from me the person that made the file.

NeVeR

anyone?

Ginger

Do they just need to view the data???

You can do a number of things.

1. Use Excel just to display the data. They can manipulate to their hearts content without messing your data

2. Use an ASP page to display the data. Requires a bit more work.

3. Use the forms within Access to show the data.

4. Use the Tools Security idea and create a user and admin level user. You can specify different levels.

HTH

Asok

If its a windows file share simply login to the server and set the appropriate ntfs file permissions for the file or another way would be to disable write access via the share permissions completely.

Ginger

The problem there would be the LDB file as it has to be created for access to function.

atheist

I agree with Ginger
Save the data in an other format, such as comma delimited
Use ntfs or network permissions
Access can use and modify external file formats

Ginger

To be honest your best bet is the Excel file because then you can uninstall access from the other machines and they definately cant open it.