Read only for writing pw needed

[lkmaurik]

Hello,



First I will explain the scenario. At work I engineer a measurement system, that write his data in Access 2010. But now I want to make the file corruption proof. So it must be a Only Read file and my software gets the password to write.

In Excel and other applications of office you need to do the following steps:
Click on file> save as > in save as dialog box> click on tools> general options >

Sadly Access 2010 won’t go further then:
Click on file> save as > in save as dialog box> click on tools>
The only option you can select here is "Network connection".

Can someone help me with this problem to give access 2010 Database a Password to write.

Thank you in advance,
Leroy

[NoellaG]

Hi,

I would suggest you give the users a front-end where all forms are set to read-only. Never give the users direct access to the tables, but always design forms/reports to this purpose.
If you really want a secure environment, then move the back-end tables to SQL server. there you have a lot more security possibilities.

gr
NG

[lkmaurik]

Hi NG,

Sorry for my late response, I was on holiday.

Well i going to try to design a form and will start a meeting to discuss a SQL server.

Thank you for your reply,

Leroy

[NTC]

There are several different levels/concepts involving security - and going to sqlserver isn't the defacto approach alone.

As you emphasize that only you should be able to edit fields - it would be possible that managing the AllowEdits (Additions, Deletetions too...) may be a very viable and relatively simple approach.

Certainly sqlserver can bring a higher level of security; but it is somewhat like saying that an 18 wheeler can carry more cargo. It is true. But if one only has a pickup truck's worth of cargo - it can be both true and yet not necessarily the best approach.

If your primary concern is that others not edit records - that can be handled with form properties.

Hope this helps.

[lkmaurik]

Well, My only concerned is that others cant edit the files. So I will make a form.

I don't have a lot experience with forms, but I'm a fast learner. Thx for your reply.

Gr