Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exclusive Access To Tables. How Do I Implement IT?

Status
Not open for further replies.
HLEE1167

HLEE1167

Programmer
Mar 21, 2006
17
US
I do want to make a table exclusive in such a way that if anybody is using it and any user try to use it (including update queries, or even LINKING it) Access may not allow other users to use the table. Could any one Tell me how could you do this?

Thank you
 
Sort by date Sort by votes
Open the table, and click tools, then options. Click the advanced tab, and under default record locking, choose all records.
 
Upvote 0 Downvote
and wait patiently for the cries of angst as users get error messages and / or the app crashes?




MichaelRed


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

accesshelp1
  • Locked
  • Question
How can I remove parenthesis and everything that comes after it? 1
Replies
3
Views
785
Andrzejek
Andrzejek
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
488
mikrom
mikrom
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
4K
lameid
lameid
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
2K
combo
combo
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top