Is is possible to block a table for not being updated?
with VBA code?

What do you mean by "block" it? Are you talking about being in a FORM and not allowing records to be edited? In design view, set these three form properties to FALSE:

Allow Edits
Allow Deletions
Allow Additions


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

no, that way you'll block the form but not the table from receiving records, what I want to do is block a table, doesn't matter if it is by form, direct in the table or by another application accessing to the database.

Thank you anyway :)

If you set security on the database and set a password

TOOLS > SECURITY > SET DATABASE PASSWORD

Then anyone opening and/or linking into the database will not be able to unless they know the password. You can store the back end (data tables and queries) in a password-protected MDB and give the user an unprotected front end (the forms and reports), and convert that MDB into an MDE (so they cannot edit the VBA code).


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Define blocking table. Are you taking security or are you talking record level/table level locks.

Block from who? when?
Security in Access can be a pain.



Sal

ok, sorry if I confused you guys, I'll explain exactly what I want to do

2 users acccessing the same database

there is a table that has counters

when one user get a counter he'll update it to counter+1, but in this time I don't want the other user to access that table so it'll not be possible for them to receive the same counter.

Now tell me if is it possible to block the table.