Prevent table from amendment

haj1503

Registered User.
Local time
Today, 17:28
Joined
Jul 1, 2003
Messages
50
Hi friend,

It is possible to prevent my table from my users make amendment instead from my form or create a new database and make link which the new database without password.

Your cooperation is much be appreciated.
 
In Tools > Startup of your database you can hide the database window which would prevent users having access to the table. Also, if you click Advanced on this dialogue box there's also a box where you can turn off "Use Access Special Keys" which would also prevent the user from bringing the database window back by pressing f11.

You can of course override this by holding the shift key down but you can lock this as well by putting in extra code. Look at this post where Hayley has attached an example.

Hope this helps.
 
Hi Ally,

Thanks on that you reply.

Actually for you info, I've set lock my table from bypass but the users still make amendment where they make a link table then make amendment through new link database.

Did you know how to prevent the user from make amendment through table bacause if through form at least I can make audit trial but through table how?

sorry if my explanation not so good enough for you understand.

Best regards,
 
Oh - I hadn't actually realized that you could make changes to a linked table. I've learnt something.

I'm very sorry, but I'm not sure how we can overcome this. Hopefully someone else will be able to answer. I'm sure there must be a way of making it read-only. If I find anything I'll post back.
 
You need to set up Access security. Be VERY careful. Read ALL the FAQs before you start and make sure you understand them. Make plenty of backups. Because you're securing your be, you will probably need to modify all the queries in your fe to add the WITH OWNER ACCESS option. Read about this in help and be aware that it will only work with stored querydefs. If you have SQL that you build dynamically or use as recordsources, that code will no longer work.

Here's a link to get you started:
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp#_Toc493299709

Ally, haj1503 is not talking about changing the linked table object, he's talking about changing the data in a linked table.
 
Hi Pat,

I understand when I create system security, the db would be prevent the user from editable the table but the problem is when we upgrade the db to the future db then we should be upgrade the system security also, is luckly if the history of the system security available in your safe box. how if the system security is unavailable?, then we will facing another problem which we can't open the db in the future.

might I'm right.... anywhere anybody can solve the problem.... this is a good challenges....:mad:
 

Users who are viewing this thread

Back
Top Bottom