Locking single records in a table

[Guest]

Hello

I'm trying to lock one (or more) records in a table in a shared db. Is this
possible? The db is build up with one "master" table, and a number of
"sub-tables" linked with one common field. All input to the tables from
forms.

I want to be able to lock one or more records, and also while doing it, lock
all records in the relevant sub table. All records should be visible, but not
accesable for editing (until I "un-lock the record)

If this is possible, can someone direct me to a sollution?

 

[John Vinson]

On Thu, 26 Oct 2006 04:12:01 -0700, Evald Nergaard <Evald

I want to be able to lock one or more records, and also while doing it, lock
all records in the relevant sub table. All records should be visible, but not
accesable for editing (until I "un-lock the record)

About all I can suggest is opening a Recordset selecting the specified
records, with the recordset's property set to deny writes. Take a look
at the VBA help for OpenRecordset for the specific arguments.

John W. Vinson[MVP]

 

[aaron.kempf]

MDB doesn't support multiple users.. I reccomend growing some balls and
learning SQL Server