Click here to Skip to main content
15,898,222 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: finding a string in a CString Pin
Steve Maier5-Aug-01 3:47
professionalSteve Maier5-Aug-01 3:47 
GeneralRe: finding a string in a CString Pin
Baafie5-Aug-01 3:51
Baafie5-Aug-01 3:51 
GeneralRe: finding a string in a CString Pin
Baafie5-Aug-01 3:51
Baafie5-Aug-01 3:51 
GeneralRe: finding a string in a CString Pin
#realJSOP5-Aug-01 5:02
professional#realJSOP5-Aug-01 5:02 
GeneralRemoving Help button from Wizard Pin
4-Aug-01 20:53
suss4-Aug-01 20:53 
GeneralRe: Removing Help button from Wizard Pin
Bill Leibold4-Aug-01 21:30
Bill Leibold4-Aug-01 21:30 
GeneralRe: Removing Help button from Wizard Pin
Paolo Messina5-Aug-01 5:54
professionalPaolo Messina5-Aug-01 5:54 
GeneralMaintaining Referential Integrity Pin
Reno Tiko4-Aug-01 15:37
Reno Tiko4-Aug-01 15:37 
I'm pretty new to ADO and need some guidence. I'm using MS Access 2K. I have
three tables. The tables looks as follows:

UserAccounts
------------
UserAcctID (key, autonumber)
UserAcctData

Queues
------
QueueID (key, autonumber)
QueueName

QueueRights
-----------
UserAcctID (foreign key)
QueueID (foreign key)
Rights

I'm using ADO and DCOM so there's potential of multiple admin users trying
to access and modify the tables at one time. I need to ensure that referential
integrity is ensured, and wondered if developers typically use locking mechanisms
or the referential integrity tool in MS Access, or both.

I also, have the following situations, and am not sure of the best way to resolve
them in terms of locking and ensuring that the keys/data won't be out of sync:

1) When one admin is editing another user's account, another admin cannot edit that
user's account. What's the best way to lock the account? Add a lock timestamp
column to UserAccounts?

Also, is this a user-friendly restriction? Do other administration program lock
another user from editing the same account, or do they allow them to edit it and
then notify them that it has changed when it's time to update and for them to reload
and redo what they've done?

2) When an admin is about to update another user's queue rights, I would need to
lock the entire "Queues" table from being added to while records are being added
or updated to the QueueRights table. What's the best way of accomplishing that?

3) Also are there any good websites and/or books that discusses how to resolve
issues with multiple users and databases?

Thanks in advance for any help!


GeneralUsing CTabCtrl Effectivelty Pin
AJ1234-Aug-01 12:11
AJ1234-Aug-01 12:11 
QuestionWhat's the difference? Pin
4-Aug-01 10:21
suss4-Aug-01 10:21 
AnswerRe: What's the difference? Pin
Chris Losinger4-Aug-01 10:26
professionalChris Losinger4-Aug-01 10:26 
GeneralRe: What's the difference? Pin
4-Aug-01 10:32
suss4-Aug-01 10:32 
GeneralRe: What's the difference? Pin
Christian Graus4-Aug-01 11:39
protectorChristian Graus4-Aug-01 11:39 
GeneralRe: What's the difference? Pin
Ben Burnett4-Aug-01 11:40
Ben Burnett4-Aug-01 11:40 
GeneralRe: What's the difference? Pin
Christian Graus4-Aug-01 11:43
protectorChristian Graus4-Aug-01 11:43 
GeneralRe: What's the difference? Pin
Ben Burnett4-Aug-01 12:00
Ben Burnett4-Aug-01 12:00 
GeneralRe: Gloabl variabl, reference & pointer. Pin
Masaaki Onishi5-Aug-01 6:27
Masaaki Onishi5-Aug-01 6:27 
GeneralRe: What's the difference? Pin
Joe Woodbury5-Aug-01 9:03
professionalJoe Woodbury5-Aug-01 9:03 
Generallinked list with fast sorting Pin
4-Aug-01 4:17
suss4-Aug-01 4:17 
GeneralRe: linked list with fast sorting Pin
Christian Graus4-Aug-01 11:41
protectorChristian Graus4-Aug-01 11:41 
GeneralRe: linked list with fast sorting Pin
6-Aug-01 0:12
suss6-Aug-01 0:12 
GeneralRe: linked list with fast sorting Pin
Malcolm McMahon6-Aug-01 2:40
Malcolm McMahon6-Aug-01 2:40 
GeneralRe: linked list with fast sorting Pin
6-Aug-01 4:08
suss6-Aug-01 4:08 
GeneralRe: linked list with fast sorting Pin
Malcolm McMahon6-Aug-01 5:09
Malcolm McMahon6-Aug-01 5:09 
GeneralRe: linked list with fast sorting Pin
7-Aug-01 1:09
suss7-Aug-01 1:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.