Record Locks

M

Microsoft

I have a multi user database. Front end loaded on each PC with Data Tables
stored on the server.

I don't want people to be able to access records when someone else has them
open.

How do I go about this?

The table structure is:

Table1 - PK EstNo
linked to
Table2 - PK EstNo, ItemNo
linked to
Table3 - PK EstNo, ItemNo, LineNo

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Child Table With Two Parent Tables 4
Search-Edit record-Page-Subform 0
Listbox problem agaie 3
File Size Spiralling Out of Control 5
Duplicate record in Form and Subform 0
File Size Spiralling Out of Control (Continued) 2
Writing "transaction" records via continous forms and checkboxes 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top